instyle and News Show Pro GK5

HEllo,

I am trying to use this and I read all post about this here in the forum.
Follwoing issue:
J3.6.2
VM 3.0.16
Main Language for admin and Site russian.
When I go the module /data source/virtumart Product or Categories and than to virtuemart addtionals settings and add there the language the VM language override to ru_ru ( acc. DB) than the error message

1146
Table 'web2sql24.#__virtuemart_products_' doesn't exist SQL=SELECT `#__virtuemart_products`.* ,`#__virtuemart_products_`.* FROM `#__virtuemart_products` INNER JOIN `#__virtuemart_products_` using (`virtuemart_product_id`) WHERE `#__virtuemart_products`.`virtuemart_product_id` = "1"

Why this happens?
If I change this to the language en_gb than the module is running but there are no Product or categories seen.( what is okay there are no Products or categories)

When some one can assist me here would be great.

Best regards,

Dirk

Hello all,
now I found a way how to avoid the 1146 or 1063 error. In the virtuemart addtional settings under VM language override after saving I press addtional the enter in the field VM language override and the tool is running but is not dispalying nothing from Virtuemart but something from K2. Can me someone help here?

Best regards,

Dirk

Hello,
forget my prevoius Post. If I do this the tool is automatically jumping to the source of Articel "All K2 articels"


1146Table 'web2sql24.#__virtuemart_products_' doesn't exist SQL=SELECT `#__virtuemart_products`.* ,`#__virtuemart_products_`.* FROM `#__virtuemart_products` INNER JOIN `#__virtuemart_products_` using (`virtuemart_product_id`) WHERE `#__virtuemart_products`.`virtuemart_product_id` = "3"
I Checked the DB and all tables are there an not empty.

Thank you for help here.

Best regards,

Dirk

Hi

If You are making a new installation, just remember to select "English (United Kingdom)" on first screen. That's all. Demo content is provided with english only, so if You select a different language tables for this language will not be created.

If You already has a site go to VM settings, include all languages You will need and after that use VM Tool to update database. It will add missing tables.

Hi,

thank you for reply here. Installation was done as written the quickstart documenationn and all other steps done as written here in Forum. Now the main Language is russian, Tables created for en-gb and ru-ru but not working

Any other suggestions ?

Thank you very much.

Dirk

Hi

Do You mean that error is still showing ?

If You mean that only NSP is not working to display products it's because it's capable of displaying only one language. You need to use table prefix override (it's in NSP settings for VM) to force it to use a content from desired language tables.

Hi,
Thank your for your reply.

I assume you mean the section where is written "VirtueMart Addtional Settings"
VM language override. I added there ru_ru an the error message
1146
Table 'web2sql24.#__virtuemart_products_' doesn't exist SQL=SELECT `#__virtuemart_products`.* ,`#__virtuemart_products_`.* FROM `#__virtuemart_products` INNER JOIN `#__virtuemart_products_` using (`virtuemart_product_id`) WHERE `#__virtuemart_products`.`virtuemart_product_id` = "12"
It appears the page you were looking for doesn't exist. Sorry about that.

If I enter the en_gb the ´module is working but no showing any products (because we added no products in english)

What else I can do?

Best regards,
Dirk

Hi

Probably suffix is different, remove it from NSP. Try login to admin panel while selecting the language You've entered products in. Configure NSP while using this language. This way suffix will be selected automatically.