我用的是Discuz 4.0 Rc4.在批量删除主题里.我准备删除60天没有回复的主题.但执行失败.显示下面的内容
Discuz! info: MySQL Query Error
User: 帛
Time: 2005-8-6 2:48am
Script: /admincp.php
SQL: DELETE FROM cdb_posts WHERE tid IN (0,1137164,1126004,1122830,368643,1125084,406412,410728,1110150,1122431,430040,1122430,438631,456484,1116233,479232,479816,487798,489959,506811,1123447,501796,502575,504963,516624,519535,1125574,535523,1126157,1127230,1125570,1013246,560727,574887,1082996,1122990,575565,584490,1126046,588653,587973,588620,59174751649,1151690,1152018,1151696,1151694,1151918,1151706,1151707,1151844,1151711,1151715,1151725,1151948,1152625,1151857,1151765,1154424,1151733,1151749,1152050,1151747,1151756,1151760,1152784,1153276,1151764,1151807,1151770,1154833,1151874,1151779,1151783,1151787,1151791,1154247,1151793,1151799,1151801,1151812,1152310,1151829,1154429,1152791,1151836,1151838,1151839,1151852,1151867,1151930,1152521,1151889,1152290,1151895,1152023,1151900,1151909,1151929,1153913,1154847,1151916,1151975,1151931,1153146,1152261,1151959,1151944,1153415,1151946,1151953,1155816,1155835,1155838,1155839,1155844,1155857,1155863,1155875,1155888,1156062,1155895,1155897,1155899,1156048,1155915,1155921,1155929,1155934,1155953,1156139,1156025,1156018,1156071,1156009,1156065,1156020,1156023,1156201,1156049,1156050,1156067,1156089,1156104,1156124,1156117,1156122,1156182,1156200,1156221,1156223,1156226,1157426,1157429,1157424,1157432,1157438,1157444,1157447,1166964,1169037,1169475,1174477,1174729,1178727,1212183,1208889,1224233,1232789(太多了,我删除大部分主题代码留一部分给大家看)
Error: Got error 124 from table handler
Errno.: 1030
An error report has been dispatched to our administrator.
然后我随机选了个其中的有问题主题看.显示
Discuz! info: MySQL Query Error
User: 帛
Time: 2005-8-6 2:50am
Script: /viewthread.php
SQL: SELECT p.*, m.uid, m.username, m.gender, m.groupid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6, m.extcredits7,
m.extcredits8, m.email, m.gender, m.showemail, m.invisible, m.avatarshowid, mf.nickname, mf.site, mf.icq, mf.qq, mf.yahoo,
mf.msn, mf.location, mf.medals, mf.avatar, mf.avatarwidth, mf.avatarheight, mf.sightml AS signature, mf.customstatus , mf.field_2, mf.field_1, mf.field_4
FROM cdb_posts p
LEFT JOIN cdb_members m ON m.uid=p.authorid
LEFT JOIN cdb_memberfields mf ON mf.uid=m.uid
WHERE p.tid='950512' AND p.invisible='0' ORDER BY dateline LIMIT 0, 15
Error: Got error 134 from table handler
Errno.: 1030
Similar error report has beed dispatched to administrator before. |
楼主