Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Error then connect to MySQL database
  FAQ FAQ  Forum Search   Register Register  Login Login

Error then connect to MySQL database

 Post Reply Post Reply
Author
Patric View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Patric Quote  Post ReplyReply Direct Link To This Post Topic: Error then connect to MySQL database
    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

 

Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
Patric View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Patric Quote  Post ReplyReply Direct Link To This Post Posted: 04 March 2004 at 6:11am

Hi!

 

Installed MDAC 2.8 and errormessage disappeared.

 

Thank you for good support

Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post 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

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.

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.258 seconds.