Print Page | Close Window

Error then connect to MySQL database

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=3050
Printed Date: 13 December 2025 at 1:47am


Topic: Error then connect to MySQL database
Posted By: Guests
Subject: Error then connect to MySQL database
Date Posted: 03 March 2004 at 7:13am

Get this message in Activity log then i try to list quarantine mail.

03-03-04 13:07:03:725 -- Exception occurred during DoDeleteExpiredQuarantineList: [MySQL][ODBC 3.51 Driver][mysqld-3.23.54]You have an error in your SQL syntax near 'DISTINCTROW tblMsgs.* FROM tblMsgs INNER JOIN tblQuarantine ON tblMsgs.MsgID = t' at line 1

 

HELP ME, Please

 


Replies:
Posted By: Desperado
Date Posted: 03 March 2004 at 4:33pm

Patric,

Can you please post the MDAC version you have running?  I think 2.8 something is the latest but I believe 2.7 also works but not earlier.

Regards,

Dan S.

Posted By: Guests
Date Posted: 04 March 2004 at 6:11am

Hi!

 

Installed MDAC 2.8 and errormessage disappeared.

 

Thank you for good support

Posted By: Desperado
Date Posted: 06 March 2004 at 2:33pm

Patric,

Just to be safe, can you be sure to follow the following thread?

http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=2739" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=2739" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=2739

There were some issues with some 2.8 versions and I want to make sure you don't fall into that group.

Regards, Dan S.


Print Page | Close Window