[badgerracing]

Hello,

My classifieds install is having an issue with certain members ads not completing correctly after the ad/product is purchased by not marking the ad as sold and it does not send out the message or emails since the ad was not marked as sold.

All my tests with my account and my test accounts work fine, all the ads that I purchased are marked as sold and the message/emails are sent out. The weird thing is that multiple members (with different user groups) are experiencing the problem with their ads not completing correctly as I stated above. I changed my test user to have all the same account settings as one of the users that was having the issue and my test user ads still work fine.

I also started getting the following DB errors recently:

An error was encountered during execution of the query:
--------------------------------------------------------------------------------------
INSERT INTO cp_messages (msgid,userid,datestamp,message,type,product) values(NULL, 1551, 1309329003, 'RCLargescale<dot>com Renewal Notice<br /><br />savagefan04, your ad on RCLargescale<dot>com for ATX rear tire carrier is going to expire in 0 days.

If you have not sold your product and wish to renew your ad for an additional 30 days, please click on the link below:

www<dot>rclargescale<dot>com/classifieds/editproduct.php?resell=60]Login - RCLargeScale Classifieds

If you have sold your item, please let us know by clicking on this link:

www<dot>rclargescale<dot>com/classifieds/editproduct.php?sold=60]Login - RCLargeScale Classifieds

Thank you!', 'm', )

The query returned with an errorcode of:

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

An error was encountered during execution of the query:

INSERT INTO cp_messages (msgid,userid,datestamp,message,type,product) values(NULL, 6348, 1308637802, 'RCLargescale<dot>com Renewal Notice<br /><br />m3lov3r, your ad on RCLargescale<dot>com for HPI BAJA 5B SS 2011.RTR WITH MANY EXTRAS. Ultimate BAJA ********************** is going to expire in 3 days.

If you have not sold your product and wish to renew your ad for an additional 30 days, please click on the link below:

www<dot>rclargescale<dot>com/classifieds/editproduct.php?resell=59]Login - RCLargeScale Classifieds

If you have sold your item, please let us know by clicking on this link:

www<dot>rclargescale<dot>com/classifieds/editproduct.php?sold=59]Login - RCLargeScale Classifieds

Thank you!', 'm', )

The query returned with an errorcode of:

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


My Server/env. details are:

URL - www<dot>rclargescale<dot>com / classifieds (Can't post my exact URL because of this stupid rule "You are only allowed to post URLs to other sites after you have made 15 posts or more.")

PP Classifieds version 4.2

CentOS release 5.5 (Final)
Apache/2.2.3
MySQL 5.0.77
PHP Version 5.1.6
GD 2.0.28

safe_mode Off Off
Sockets Support enabled