Discuz! info: MySQL Query Error
User: admin
Time: 2005-10-31 1:07pm
Script: /redirect.php
SQL:
SELECT p.*, m.username, m.gender, m.groupid, m.adminid, m.regdate, m.lastactivity, m.postnum, m.credit, m.email, m.site, m.icq, m.oicq, m.yahoo, m.msn, m.location, m.avatar, m.avatarwidth, m.avatarheight, m.signature, m.customstatus,
m.showemail , m.bank, m.money, m.bankmimi, m.bankstatus, max(s.lastactivity) as lastactivity
FROM cdb_posts p
LEFT JOIN cdb_members m ON m.uid=p.authorid LEFT JOIN cdb_sessions s ON s.username=m.username
WHERE p.tid='56' GROUP BY p.pid ORDER BY dateline LIMIT 0, 10
Error: Got error 28 from table handler
Errno.: 1030
Similar error report has beed dispatched to administrator before.
|