Discuz升级后（旧版本到3.2版本），发现抱歉，该附件无法读取的错误

古城技术联盟

报错信息：
' d- U( D3 x$ [& p) a5 K

抱歉，该附件无法读取

: x* B" L9 @6 [; t

, S& [; P9 q" a" |  H' S经排查，权限之类的完全正确。排查了数据库，发现数据升级时候丢掉了一些数据。
主要是这个表：pre_forum_attachment，丢掉了大部分附件所有数据。

解决办法：sql执行以下命令（有一个缺点，附件下载次数没有了）。如果想完全的恢复，只能恢复备份数据重新执行。
再次郑重说明，删除数据一定要谨慎，数据无价，谨慎操作。

" f9 F! m5 Z2 F; v4 `; Z

1. INSERT INTO pre_forum_attachment(aid,tid,pid, uid,tableid,downloads)SELECT aid,tid,pid, uid,1,'10' FROM pre_forum_attachment_1 d WHERE NOT EXISTS (select tid from pre_forum_attachment where pre_forum_attachment.aid = d.aid);
   8 o! @3 S; T+ K! {
2. INSERT INTO pre_forum_attachment(aid,tid,pid, uid,tableid,downloads)SELECT aid,tid,pid, uid,2,'10' FROM pre_forum_attachment_2 d WHERE NOT EXISTS (select tid from pre_forum_attachment where pre_forum_attachment.aid = d.aid);
   + r: D0 t5 o3 N
3. INSERT INTO pre_forum_attachment(aid,tid,pid, uid,tableid,downloads)SELECT aid,tid,pid, uid,3,'10' FROM pre_forum_attachment_3 d WHERE NOT EXISTS (select tid from pre_forum_attachment where pre_forum_attachment.aid = d.aid);
   
4. INSERT INTO pre_forum_attachment(aid,tid,pid, uid,tableid,downloads)SELECT aid,tid,pid, uid,4,'10' FROM pre_forum_attachment_4 d WHERE NOT EXISTS (select tid from pre_forum_attachment where pre_forum_attachment.aid = d.aid);
   / u$ b7 e! u2 c, u4 b# Q! _
5. INSERT INTO pre_forum_attachment(aid,tid,pid, uid,tableid,downloads)SELECT aid,tid,pid, uid,5,'10' FROM pre_forum_attachment_5 d WHERE NOT EXISTS (select tid from pre_forum_attachment where pre_forum_attachment.aid = d.aid);
   : S% O8 W1 q/ y4 \! v' V0 w) T9 n
6. INSERT INTO pre_forum_attachment(aid,tid,pid, uid,tableid,downloads)SELECT aid,tid,pid, uid,6,'10' FROM pre_forum_attachment_6 d WHERE NOT EXISTS (select tid from pre_forum_attachment where pre_forum_attachment.aid = d.aid);
   7 G3 a+ z; }/ t3 B$ E1 Z0 t( y
7. INSERT INTO pre_forum_attachment(aid,tid,pid, uid,tableid,downloads)SELECT aid,tid,pid, uid,7,'10' FROM pre_forum_attachment_7 d WHERE NOT EXISTS (select tid from pre_forum_attachment where pre_forum_attachment.aid = d.aid);
   
8. INSERT INTO pre_forum_attachment(aid,tid,pid, uid,tableid,downloads)SELECT aid,tid,pid, uid,8,'10' FROM pre_forum_attachment_8 d WHERE NOT EXISTS (select tid from pre_forum_attachment where pre_forum_attachment.aid = d.aid);
   ) z4 d4 z9 ?; Q: [; I% e% H8 V( ^
9. INSERT INTO pre_forum_attachment(aid,tid,pid, uid,tableid,downloads)SELECT aid,tid,pid, uid,9,'10' FROM pre_forum_attachment_9 d WHERE NOT EXISTS (select tid from pre_forum_attachment where pre_forum_attachment.aid = d.aid);

复制代码