(Sorry i posted this in the wrong category yesterday)
Hi, I am using Order List to try to export orders to spreadsheets, but I get this error:
the invalid payment method is Error reading VM Payment Method Info = DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT * FROM hoi2_virtuemart_paymentmethods WHERE virtuemart_paymentmethod_id=
The Payment system is Standard - Payment on Collection and the check out does work successfully and the orders are listed within virtuemart succesfully.
Can anyone point me in the right direction to solve this error?
I have attached a screenshot of the MYSQL table in PHPmyadmin in case you can see a problem there.
Many thanks,
Molly
[attachment cleanup by admin]