SQL errors after Paymate transaction

[Bucketman]

Just testing some Paymate transactions and getting SQL Errors. After placing an Ad on the site and being redirected to Paymate to process the credit card payment - it all goes through fine but when redirected back to my site for the Thank You page it generates a bunch of SQL Errors.

Notice: Query failed: 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 title,price FROM class_products WHERE id= in /home/gobuyitb/public_html/includes/MySQL.php on line 120

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/gobuyitb/public_html/includes/MySQL.php on line 178

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gobuyitb/public_html/includes/MySQL.php on line 201

The payment has gone through fine and the Ad has activated so for all purposes the process has gone through OK but I don't want to user to see any SQL errors.

Any Ideas ....

[Bucketman]

Just checked the emails that are being sent to admin to notify of a new ad and all are showing as no title, no price and no listing ID - could this be what the SQL errors are about. The Ads seem to be fine, and definately have a title, price and listing ID but the email to admin shows no details at all.

[Eric Barnes]

Ashley,

What version are you running?

[Bucketman]

I am running version 3.015. I had the problem with Paymate a week or so ago and you (sukaw) remoted into my site and found the paymate file was causing the problem.

[Bucketman]

I was supposed to go live with payments 2 days ago but can't until I get this sorted out.

[Eric Barnes]

Ashley,

Will you send me your ftp details again and I will have a look. Also include any other details such as what payment provider you used, etc.