- 工作时间:周一至周六 8:30-17:00 值班18:00-22:00
-
鸿茂传媒经营理念
以客户的需求为出发点
-
腾讯云/阿里云/华为云机房
提供安全稳定的云服务器空间
-
16年运维技术经验
提供专业的1V1人工技术服务
Discuz! X版本地附件与远程附件的转换教程
进行操作前,请备份数据库
1、本地转到远程
论坛后台--全局--上传设置--启用远程附件
将本地附件目录data/attachment里面的文件夹移动到远程服务器上
数据库执行sql语句
论坛的(0表示本地,1表示远程)
update pre_forum_attachment_0 set remote=1 where remote=0;
update pre_forum_attachment_1 set remote=1 where remote=0;
update pre_forum_attachment_2 set remote=1 where remote=0;
update pre_forum_attachment_3 set remote=1 where remote=0;
update pre_forum_attachment_4 set remote=1 where remote=0;
update pre_forum_attachment_5 set remote=1 where remote=0;
update pre_forum_attachment_6 set remote=1 where remote=0;
update pre_forum_attachment_7 set remote=1 where remote=0;
update pre_forum_attachment_8 set remote=1 where remote=0;
update pre_forum_attachment_9 set remote=1 where remote=0;
门户的
update pre_portal_article_title set remote=1 where remote=0;
update pre_portal_attachment set remote=1 where remote=0;
update pre_portal_topic_pic set remote=1 where remote=0;
相册的{相册表中的remote取值还有一种情况为remote=2(论坛附件图片保存到相册)}
update pre_home_pic set remote=remote+1;
二、远程转到本地
后台关闭远程附件设置,将附件移动到本地服务器的 data/attachment目录后执行sql即可
0表示本地,1表示远程
论坛
update pre_forum_attachment_0 set remote=0 where remote=1;
update pre_forum_attachment_1 set remote=0 where remote=1;
update pre_forum_attachment_2 set remote=0 where remote=1;
update pre_forum_attachment_3 set remote=0 where remote=1;
update pre_forum_attachment_4 set remote=0 where remote=1;
update pre_forum_attachment_5 set remote=0 where remote=1;
update pre_forum_attachment_6 set remote=0 where remote=1;
update pre_forum_attachment_7 set remote=0 where remote=1;
update pre_forum_attachment_8 set remote=0 where remote=1;
update pre_forum_attachment_9 set remote=0 where remote=1;
门户
update pre_portal_article_title set remote=0 where remote=1;
update pre_portal_attachment set remote=0 where remote=1;
update pre_portal_topic_pic set remote=0 where remote=1;
update pre_home_pic set remote=remote-1
© 网站版权与免责声明
1、【鸿茂传媒】独立拥有本网站相关网页内所有资料的版权;
2、未经【鸿茂传媒】的明确书面许可,任何人不得对其进行复制;
3、本网站未注明【鸿茂传媒】的文章,均来源于网络,仅供大家学习与参考;
4、如有侵权/违规/不妥请联系客服QQ或邮箱删除,敬请谅解;
5、【鸿茂传媒】保留随时更正、修改、更新本声明的权利。法律申明