1146 error after upgrading fromJoomla 2 to 3 also VM

[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

[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