I keep getting this error, what could cause it?

[Goanna]

I have my store setup to email me whenever a mySQL error occurs, because I used to be hosted on Ipowerweb, and would always have problems with the whos online and sessions tables.

 

So, I moved to a new host and havent had any problems in a long time, but all of a sudden I keep getting this error message sent to me via email every day, several times a day.

 

1064 - You have an error in your SQL syntax near '' at line 1

delete from customers_basket where customers_id=

 

I have been placing test orders and using the admin to try and see if I can replicate the error in real time, but I cant. I have no idea what causes the error.

 

I did make some changes to the database, but all I did was add 3 feilds to the orders table in order to accomodate the USPS, UPS, and FedEx tracking Contributions. On my test server, this caused no problems what so ever, but on the real site, this error message started showing up after I made new feilds.

 

Does anyone know what could be causing this, and how I could fix it? Any information will be greatly apreicated. Thank you.

[OceanRanch]

Just a few thoughts...

 

The delete customers_basket sql is performed in multiple php files after I searched for it in the source. It appears it's being executed to clean up the basket/session for a "non-existent" customer. Maybe there's a session that is very old and the customer no longer exists.

 

Can you modify your custom email alert notification on mysql errors to identify the program module that is causing the error.

 

Another option could be to remove all of the sessions (in /tmp or in the database) when you can bring the site down for maintenance. This might clear up the problem.

 

HTH

Tom

[Goanna]

Thanks for the reply. I have to bring the site down within a couple of days in order to move it to a new secure server, so I guess I will try deleting some of the sessions when I do so and see how that works.