Shopping Basket

 x 

Cart empty


Log In

Find Us Elsewhere

SSL

Forum Search

Keyword

GbaseXML shopping feed - querying wrong table in db

  • DA CANAL GILBERTO
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 3 months ago #7998 by DA CANAL GILBERTO
GbaseXML shopping feed - querying wrong table in db was created by DA CANAL GILBERTO
Hello,
when i go in "category map" or in "product override" i get this error:


500 - Si è verificato un errore.

Table 'shopdacanal.cqd4s_virtuemart_categories_en_gb' doesn't exist SQL=SELECT a.*,b.category_name,c.category_parent_id FROM cqd4s_googlebasexml_cats as a LEFT JOIN cqd4s_virtuemart_categories_en_gb AS b ON a.virtuemart_category_id = b.virtuemart_category_id LEFT JOIN cqd4s_virtuemart_category_categories as c ON a.virtuemart_category_id = c.category_child_id ORDER BY a.id ASC Table 'shopdacanal.cqd4s_virtuemart_categories_en_gb' doesn't exist SQL=SELECT a.*,b.category_name,c.category_parent_id FROM cqd4s_googlebasexml_cats as a LEFT JOIN cqd4s_virtuemart_categories_en_gb AS b ON a.virtuemart_category_id = b.virtuemart_category_id LEFT JOIN cqd4s_virtuemart_category_categories as c ON a.virtuemart_category_id = c.category_child_id ORDER BY a.id ASC LIMIT 0, 20 Table 'shopdacanal.cqd4s_virtuemart_categories_en_gb' doesn't exist SQL=SELECT a.*,b.category_name,c.category_parent_id FROM cqd4s_googlebasexml_cats as a LEFT JOIN cqd4s_virtuemart_categories_en_gb AS b ON a.virtuemart_category_id = b.virtuemart_category_id LEFT JOIN cqd4s_virtuemart_category_categories as c ON a.virtuemart_category_id = c.category_child_id ORDER BY a.id ASC


My ecommerce is single language, only italian, ther is not a en_gb table only it_it
any suggestions?
best regards
Davide

Please Log in or Create an account to join the conversation.

More
1 year 3 months ago #7999 by boggler
Hello, this is an issue that occasionally happens when for some reason it is unable to detect the correct language settings for your site. We used to see it a lot, we mostly fixed it but it seems that it can still happen occasionally

The extension tries to show tables for the language selected in the Joomla admin, so the things to check are:-

1. That the Joomla admin language is set to Italian
2. That Italian is set as the default language in the Virtuemart configuration.

If that does not solve the issue, can you please supply an admin login for your site? Don't post it here, you can send the login details by replying to the address from which you received your invoice (fiona at spiral scripts).

It is certainly possible to fix this and we will do so. For example it should be possible to find a way to force the store language as Italian.

Please Log in or Create an account to join the conversation.

  • DA CANAL GILBERTO
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 3 months ago #8000 by DA CANAL GILBERTO
Replied by DA CANAL GILBERTO on topic GbaseXML shopping feed - querying wrong table in db
set "Italian" in VM2 Configuration - First tab - 'Multilingual shop' form field, problem solved
thank you for your assistance and quick reply

Please Log in or Create an account to join the conversation.

Moderators: boggler
Time to create page: 0.239 seconds

Donate to Us

If you like our extensions, consider making a donation to say thanks.