Discuz! info: MySQL Query Error
User: Ax天荣星
Time: 2008-3-6 12:55am
Script: /index.php
SQL: SELECT COUNT(p.pid) AS num, p.author, p.authorid, m.credits,m.posts,m.digestposts,me.location,m.groupid,me.avatar,m.oltime,me.avatarwidth,me.avatarheight FROM [Table]posts p LEFT JOIN [Table]members m ON p.authorid=m.uid LEFT JOIN [Table]memberfields me ON p.authorid=me.uid WHERE p.dateline>1204300800 AND p.invisible='0' AND p.authorid>'0' GROUP BY p.authorid ORDER BY num DESC LIMIT 1
Error: Table 'p' is marked as crashed and should be repaired
Errno.: 1194
An error report has been dispatched to our administrator. |