Renewal problems 4.0.4 - featured ads renew free

[crystal +]

I am having an issue with renewals. There is a mysql error for all renewals, and featured ads are renewing free! The error happens after the user clicks the link to renew, then clicks continue after personal info/payment. The next step returns this error:

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 ' display='N' WHERE id=49' at line 1 SQL: UPDATE class_listings SET , display='N' WHERE id=49 in /pathtomyclassifieds/includes/classes/database/mysql.php on line 134

The error is just on the top of the site, the rest of the site appears below. It shows the "verify the information" step with the ad package and the featured ads come up with $0.00 as the total! If the user presses 'continue' their ad renewal is submitted and successful.

The user can continue that step, then place the order and the ad renews and becomes active. Please help before all of my featured ads renew for free!

Thank you kindly!

[Eric Barnes]

Hi Crystal,

Yes this is a bug. Here is a link to the fix:
Renewal Problems

This bug only affects renewals with no upsale items. (Featured, Highlighted, Bold, Etc)

[crystal +]

Thank you. I tried the fix in the post you gave and it took away the mySQL error but now it's not processing my renewals at all. When the user gets to the thanks page all the info is blank, and if submitted the ad becomes active but does not change the date.

Please help... renewals are not working at all now!