VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: mrwebmedia on May 10, 2016, 11:08:58 AM

Title: 1146 error after upgrading fromJoomla 2 to 3 also VM
Post by: mrwebmedia on May 10, 2016, 11:08:58 AM
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
Title: Re: 1146 error after upgrading fromJoomla 2 to 3 also VM
Post by: GJC Web Design on May 10, 2016, 13:00:22 PM
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
Title: Re: 1146 error after upgrading fromJoomla 2 to 3 also VM
Post by: mrwebmedia on May 10, 2016, 13:45:24 PM
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.
Title: Re: 1146 error after upgrading fromJoomla 2 to 3 also VM
Post by: GJC Web Design on May 10, 2016, 16:54:17 PM
tip -- use google to search this forum -- the native search IMHO is useless