I'm getting these errors in my logs every so often, and it's causing CF to hang up pretty hard. In executive.log I'm getting this: "Error","TID=2051","06/09/01","01:37:52"," Error running SQL to expire client data from Data Sourc clientvars: ODBC Error Code = 37000 (Syntax error or access violation)<P>: [MERANT][ODBC MySql driver][MySql]You have an error in your SQL syntax near 'SELECT CGLOBAL.cfid FROM CGLOBAL WHERE CGLOBAL.lvisit < '2001-05-30 01:37:52')' at line 1<P><P>" In mysql.log I'm getting a lot of these: 010609 1:36:47 Aborted connection 57 to db: 'sfa' user: 'root' host: `localhost' (Got an error reading communication packets) Data source "sba" is called from one of my CF web pages on a user's site. Looks like CF tries to run the scheduled task to clear out old client data from the data source "clientvars" which I've defined for CF to use as a storage area for client variables. For some reason it's puking on this task, which ends up causing something to hang, and then MySQL starts reporting errors when subsequent CF pages are hit. I think I remember reading somewhere about an issue with CF and MySQL on Linux with this scheduled client data expiration task, but I can't recall the details. Please help! :) -Rob Patrick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
