VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: dros1a on August 24, 2016, 15:42:50 PM

Title: When the Cart is not Empty i am getting Mysql error on Articles, Contacts etc...
Post by: dros1a on August 24, 2016, 15:42:50 PM
When the Cart is not Empty i am getting Mysql error when i browse to Articles, Contacts, blogs etc...

that error is happening since i installed virtuemart and joomla

i will explain this with a picture.
https://i.imgur.com/YXuJa2x.png

How do i fix this?

i also fixed the vendor problem, since i have only one vendor i made a different account only for the vendor then i set my user as "is not a vendor" and now i don't see the error in that situation.

VirtueMart 3.0.16
Joomla 3.6.2
Title: Re: When the Cart is not Empty i am getting Mysql error on Articles, Contacts etc...
Post by: GJC Web Design on August 24, 2016, 16:04:27 PM
it is a lang table problem

what ever is producing these queries isn't detecting/adding the lang suffix to the table

#__virtuemart_products_??_??

Title: Re: When the Cart is not Empty i am getting Mysql error on Articles, Contacts etc...
Post by: dros1a on August 27, 2016, 12:34:30 PM
Quote from: GJC Web Design on August 24, 2016, 16:04:27 PM
it is a lang table problem

what ever is producing these queries isn't detecting/adding the lang suffix to the table

#__virtuemart_products_??_??


My website is not multilingual, i tried changing languages both on virtuemart and on joomla.
I tried to remove and recreate vendors products and etc but i have the same issue.

i enabled vmdebug
this info is produced in every page that contains virtuemart components but not in the pages i get the mysql error when i add products in the cart
vmdebug LangCount: 1 $siteLang: en-GB self::$vmlangSef: en self::$_jpConfig->lang en_gb DefLang en_gb
in the problematic pages(articles) there is not vmdebug info at all maybe i should enable some modules?

i tried to go into database and check if there are other non english characters or anything missing.
i tried to disable some modules but nothing i don't know where to look and fix the lang suffix.
any tips or ideas how to debug this?
Title: Re: When the Cart is not Empty i am getting Mysql error on Articles, Contacts etc...
Post by: GJC Web Design on August 27, 2016, 15:40:33 PM
find where these queries are produced (vm core?  3rd party ext.?) then debug why the lang isn't detected
Title: Re: When the Cart is not Empty i am getting Mysql error on Articles, Contacts etc...
Post by: dros1a on September 20, 2016, 02:42:57 AM
i wanted to say that i fixed this with a not very efficient way.

because you said language sufx isn't detected i thought that maybe i should put in the page something from the virtuemart database(products,manufacturers, etc..).
i made a module with 1 product inside i put it somewhere in the page and then hide the div with a css and it WORKED.

:s
Title: Re: When the Cart is not Empty i am getting Mysql error on Articles, Contacts etc...
Post by: GJC Web Design on September 20, 2016, 09:21:42 AM
is this a 3rd party cart module?