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

500 Error when adding product to cart

Started by pm4698, October 16, 2016, 00:29:47 AM

Previous topic - Next topic

pm4698

Hello there,

Joomla 3.6.2
Virtuemart 3.0.18

If you check here: goo.gl/zva4Yi and click on add to cart button (ΣΤΟ ΚΑΛΑΘΙ)  on the right side, while having console open you will see something like:
GET http://.......... 500 Table does not exist etc etc

Any ideas about this?

Thank you in advance!

GJC Web Design

#__virtuemart_products_

this is a missing language table detection

should br I guess gr lang  - u need to find this query and fix - cart module perhaps... try unpublishing

#__virtuemart_products_xx_xx
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

pm4698

This is not the cart module because i tried with the default one and still get the error at the console.

But i found that responsible for this json action is a script inside the template here:

https://goo.gl/GyTVAx

I found where this json is called, but no way i can find something about the SELECT query.

GJC Web Design

the fact remains the tables suffix is missing so that means the lang isn't detected

it has nothing to do with the json call per se  .. the call fails because there is an invalid query later in the function

u have nutty amounts of JS loading so that could be related .. in my experience 3rd party ext. have also broken the queries because their lang detects weren't working (old VM2 code etc) .. but who knows in this case

but u have to find the faulty query and find why the $lang is empty and fix

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