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

古城技术联盟

报错信息：

抱歉，该附件无法读取

经排查，权限之类的完全正确。排查了数据库，发现数据升级时候丢掉了一些数据。
主要是这个表：pre_forum_attachment，丢掉了大部分附件所有数据。
; U% `0 [  p( `$ v+ e
解决办法：sql执行以下命令（有一个缺点，附件下载次数没有了）。如果想完全的恢复，只能恢复备份数据重新执行。
) Z1 z1 h+ q+ ?- q* H再次郑重说明，删除数据一定要谨慎，数据无价，谨慎操作。

; u9 r6 H6 _3 Z" `1 V& G

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);
   ! o! V* j, P& j5 Q7 |, F. ]
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);
   " T, L0 N9 {/ {9 i+ s& Q) H( O1 g3 @
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 i+ y; w7 U- M5 D( v( i( x+ P
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);
   
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);
   2 T4 C& P% S1 M; p$ Q/ ]8 c: b
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. 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);
   
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);

复制代码