Support Analyst’s Talk

errorlog.php in forumdata does recorded mysql error. however it is not complete,

so I have to find mysql error log file and check what went wrong with the database.

also in backend of database, under system tools, it has system error record, which bring the details from errorlog.php.

the last error shows:

MySQL         07-5-30 10:24     forumdisplay.php : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘-3, 30′ at line 5 - SELECT t.*, p.rate FROM cdb_threads t LEFT JOIN cdb_posts p USING(tid, dateline) WHER …

so after sleep , I got to find check the details of each wrong query from mysql error log, though i don’t even know where the mysql error log is.