secure trading mod problem

[Nick1973]

Hi I'm using the module supplied by secure trading, however after installation I get this error when trying to process payments on stage 3 - Order Confirmation.

WARNING: An Error occurred, please refresh the page and try again.

I've looked in my debug files and they show [24-May-2012 01:38:20] PHP Fatal error: 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 :: SELECT zone_code FROM zones WHERE zone_id = in /home/MYSITE/public_html/winepayments/includes/classes/db/mysql/query_factory.php on line 101

The database is compatible and the tables exist. I've tried setting up zones but then I get an error saying 'we are currently not shipping to you zone at the present time'

Really need some help with this.

Nick

[DrByte]

Sounds like either you've configured the module to be restricted to a certain zone that no longer is defined in your Zone Definitions screen, or the module has been coded incorrectly and is unable to handle whatever zone you have selected (or if you've selected "--None--" then it doesn't know how to handle that).

Suggest you go into the module's settings in your admin area and change what Payment Zone you've set it to use.