Discuz! info: MySQL Query Error
Time: 2005-5-31 11:21pm
Script: /viewthread.php
SQL:
, max(s.lastactivity) as lastactivity
FROM cdb_posts p
LEFT JOIN cdb_sessions s ON s.username=m.username
WHERE p.tid='182' GROUP BY p.pid ORDER BY dateline LIMIT 0, 10
Error: 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 ' max(s.lastactivity) as lastactivity
FROM cdb_posts p
Errno.: 1064
Similar error report has beed dispatched to administrator before.