Discuz!X2.0更新到20111010后附件更新导致丢失整个帖子附件的BUG解决

湖中沉

打开/source/function/function_post.php文件，查找：

1. if($attachupdate) {
   
2.                 $query = DB::query("SELECT pid, aid, attachment, thumb, remote FROM ".DB::table(getattachtablebytid($tid))." WHERE aid IN (".dimplode(array_keys($attachupdate)).")");
   
3.                 while($attach = DB::fetch($query)) {
   
4.                         if($attach['pid'] == $pid) {
   
5.                                 dunlink($attach);
   
6.                         }
   
7.                 }
   
8.                 $uaids = dimplode($attachupdate);
   
9.                 $query = DB::query("SELECT aid, width, filename, filesize, attachment, isimage, thumb, remote FROM ".DB::table('forum_attachment_unused')." WHERE aid IN ($uaids)$uidadd");
   
10.                 DB::query("DELETE FROM ".DB::table('forum_attachment_unused')." WHERE aid IN ($uaids)$uidadd");
    
11.                 $attachupdate = array_flip($attachupdate);
    
12.                 while($attach = DB::fetch($query)) {
    
13.                         $update = $attach;
    
14.                         $update['dateline'] = TIMESTAMP;
    
15.                         $update['remote'] = 0;
    
16.                         unset($update['aid']);
    
17.                         if($attach['isimage'] && $_G['setting']['watermarkstatus'] && empty($_G['forum']['disablewatermark'])) {
    
18.                                 $image->Watermark($_G['setting']['attachdir'].'/forum/'.$attach['attachment'], '', 'forum');
    
19.                                 $update['filesize'] = $image->imginfo['size'];
    
20.                         }
    
21.                         DB::update(getattachtablebytid($tid), $update, "aid='".$attachupdate[$attach['aid']]."'");
    
22.                         ftpupload(array($attachupdate[$attach['aid']]), $uid);
    
23.                 }
    
24.         }

复制代码

替换为：

1. if($attachupdate) {
   
2.                 $query = DB::query("SELECT pid, aid, attachment, thumb, remote FROM ".DB::table(getattachtablebytid($tid))." WHERE aid IN (".dimplode(array_keys($attachupdate)).")");
   
3.                 while($attach = DB::fetch($query)) {
   
4.                         if(array_key_exists($attach['aid'], $attachupdate) && $attachupdate[$attach['aid']]) {
   
5.                                 dunlink($attach);
   
6.                         }
   
7.                 }
   
8.                 $uaids = dimplode($attachupdate);
   
9.                 $query = DB::query("SELECT aid, width, filename, filesize, attachment, isimage, thumb, remote FROM ".DB::table('forum_attachment_unused')." WHERE aid IN ($uaids)$uidadd");
   
10.                 DB::query("DELETE FROM ".DB::table('forum_attachment_unused')." WHERE aid IN ($uaids)$uidadd");
    
11.                 $attachupdate = array_flip($attachupdate);
    
12.                 while($attach = DB::fetch($query)) {
    
13.                         $update = $attach;
    
14.                         $update['dateline'] = TIMESTAMP;
    
15.                         $update['remote'] = 0;
    
16.                         unset($update['aid']);
    
17.                         if($attach['isimage'] && $_G['setting']['watermarkstatus'] && empty($_G['forum']['disablewatermark'])) {
    
18.                                 $image->Watermark($_G['setting']['attachdir'].'/forum/'.$attach['attachment'], '', 'forum');
    
19.                                 $update['filesize'] = $image->imginfo['size'];
    
20.                         }
    
21.                         DB::update(getattachtablebytid($tid), $update, "aid='".$attachupdate[$attach['aid']]."'");
    
22.                         ftpupload(array($attachupdate[$attach['aid']]), $uid);
    
23.                 }
    
24.         }
    

复制代码

更新即可

kiument

{:soso_e125:} 这文件一般没人改，直接提供文件方便些

聚聚

湖兄好。这个我尝试修改上传并且更新了重新发帖还是出现同样的问题。不知道你有什么建议吗？

附下错误语句

•[Type] 查询语句错误
•[1054] Unknown column 'width' in 'field list'
•[Query] SELECT aid, width, attachment, isimage, remote FROM forum_attachment WHERE aid='1599'

Program messages:

•[Line: 0060]forum.php(require)
•[Line: 0808]source/module/forum/forum_viewthread.php(include)
•[Line: 0001]data/template/1_diy_forum_viewthread.tpl.php(hookscriptoutput)
•[Line: 1269]source/function/function_core.php(hookscript)
•[Line: 1230]source/function/function_core.php(plugin_wumii_related_posts_forum->viewthread_postbottom_output)
•[Line: 0155]source/plugin/wumii_related_posts/wumii_related_posts.class.php(w_get_viewthread_image_src)
•[Line: 0091]source/plugin/wumii_related_posts/require.func.php(DB::query)