When the Cart is not Empty i am getting Mysql error on Articles, Contacts etc...

Started by dros1a, August 24, 2016, 15:42:50 PM

Previous topic - Next topic

dros1a

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

GJC Web Design

it is a lang table problem

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

#__virtuemart_products_??_??

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

dros1a

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?

GJC Web Design

find where these queries are produced (vm core?  3rd party ext.?) then debug why the lang isn't detected
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

dros1a

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

GJC Web Design

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