VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: pm4698 on October 16, 2016, 00:29:47 AM

Title: 500 Error when adding product to cart
Post by: pm4698 on October 16, 2016, 00:29:47 AM
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!
Title: Re: 500 Error when adding product to cart
Post by: GJC Web Design on October 16, 2016, 01:02:53 AM
#__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
Title: Re: 500 Error when adding product to cart
Post by: pm4698 on October 16, 2016, 11:10:38 AM
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.
Title: Re: 500 Error when adding product to cart
Post by: GJC Web Design on October 16, 2016, 11:33:17 AM
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