News:

Looking for documentation? Take a look on our wiki

Main Menu

1054 error when checking out

Started by jadeblack, December 05, 2020, 11:02:03 AM

Previous topic - Next topic

jadeblack

Hello,
I am using VirtueMart 3.8.6 ,  Joomla 3.9.23, and  VMUIKIT X 10.1

When submitting the button to checkout,  I get this error : 1054  Unknown column 'Array' in 'where clause'   
on a white screen.

How do I fix this ?


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

jadeblack

Thanks for the link but i have already tried that (the edit to products.php )
I'm getting the error at the moment of confirming an order.  The expected result is to be sent to a paypal payment window.  Instead I get a white screen on my site, with the 1054 error message.

GJC Web Design

have u tried installing http://dev.virtuemart.net/attachments/1276/com_virtuemart.3.8.7.10378.zip ?

It is vm3.8.6 with the fix ( and perhaps one or 2 small changes) but should be safe to test

otherwise full reporting and debug on so u get a trace to see where the error is thrown
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