You have an error in your SQL syntax; WHERE virtuemart_paymentmethod_id=

[molly-redseed]

(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]