News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

1146 error after upgrading fromJoomla 2 to 3 also VM

Started by mrwebmedia, May 10, 2016, 11:08:58 AM

Previous topic - Next topic

mrwebmedia

Hello there,

i got a issue after upgrading Joomla and VM. I got this error

1146 - Table 'ps.#__virtuemart_categories_'.VMLANG.'' doesn't exist SQL=SELECT L.category_name as name, L.virtuemart_category_id AS category_id, CC.category_parent_id, C.published as category_publish FROM `#__virtuemart_categories_'.VMLANG.'` as L JOIN `#__virtuemart_categories` as C using (`virtuemart_category_id`) LEFT JOIN `#__virtuemart_category_categories` as CC on C.`virtuemart_category_id` = CC.`category_child_id` WHERE C.published = '1' ORDER BY category_parent_id, C.ordering

The website is only in German and the table #__virtuemart_categories_de_de is in the database. What could went wrong, i have no idea.

Thanks
Mike

GJC Web Design

well.. I must have answered this about 5 times now

did u search the forum

the error is that the de-de is missing in the query so SOMEWHERE you have a script /ext. calling this query but not detecting the land extension

a module?  a plugin? etc etc .. you need to find what calls this query and fix the code
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

mrwebmedia

Sorry i'm not really good in searching stuff, but thanks for the help i found the modul and changed the code and it worked again.

GJC Web Design

tip -- use google to search this forum -- the native search IMHO is useless
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation