Author Topic: 500 Error when adding product to cart  (Read 361 times)

pm4698

  • Jr. Member
  • **
  • Posts: 156
500 Error when adding product to cart
« 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!

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9176
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
Re: 500 Error when adding product to cart
« Reply #1 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
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

pm4698

  • Jr. Member
  • **
  • Posts: 156
Re: 500 Error when adding product to cart
« Reply #2 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.

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 9176
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.4.2
Re: 500 Error when adding product to cart
« Reply #3 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

GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation