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. |