I just upgraded my server to mysql 5 and I am getting these errors every now and then. Any suggestions?
Code:
SELECT thread.threadid, thread.forumid FROM thread AS thread, subscribethread AS subscribethread LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread') WHERE subscribethread.threadid = thread.threadid AND subscribethread.userid = 756 AND thread.visible = 1 AND lastpost > 1148125274 AND deletionlog.primaryid IS NULL
Comment