1. 论坛系统升级为Xenforo,欢迎大家测试!
    排除公告

帝国,帮忙啊

本帖由 BoBo2005-10-24 发布。版面名称:源码讨论

  1. BoBo

    BoBo New Member

    注册:
    2005-09-29
    帖子:
    929
    赞:
    0
    我调试时站点地址、系统安装地址、附件存放地址都是用192.168.1.2,请问我放上网后把这些地址改为www.html.com,那文章里的图片会自动改吗?我看里面的都是绝对路径啊。
     
  2. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    不会,只能用批量替换字段值,改回来(不过免费版好像没有此功能。所以建议你直接装到服务器上)
     
  3. BoBo

    BoBo New Member

    注册:
    2005-09-29
    帖子:
    929
    赞:
    0
    那怎么办?现在已经有很多数据了啊,执行SQL语句应该可以吧,帮忙花几秒钟写个语句给我啊,谢谢
     
  4. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    update phome_ecms_news set newstext=REPLACE(newstext,'http://192.168.1.2','http://www.html.com'),titlepic=REPLACE(titlepic,'http://192.168.1.2','http://www.html.com')

    自己备份好数据,然后再运行
     
    #4 wm_chief, 2005-10-24
    最后编辑: 2005-10-24
  5. jcking

    jcking Well-Known Member

    注册:
    2005-08-30
    帖子:
    22,282
    赞:
    70
    :eek:
     
  6. yeshou

    yeshou New Member

    注册:
    2005-09-06
    帖子:
    7,067
    赞:
    34
    建议帝国这部分程序要修改
     
  7. BoBo

    BoBo New Member

    注册:
    2005-09-29
    帖子:
    929
    赞:
    0
    就去测试一下,我还以为你会回复:购买商业版
     
  8. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    啥?
     
  9. jcking

    jcking Well-Known Member

    注册:
    2005-08-30
    帖子:
    22,282
    赞:
    70
    建议帝国以后以灌水为生
     
  10. BoBo

    BoBo New Member

    注册:
    2005-09-29
    帖子:
    929
    赞:
    0
    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '\'http://19.104.116.112\', \'http://www.dglady.com\'),titlepic=
    update phome_ecms_news set newstext=REPLACE(newstext,\'http://19.104.116.112\', \'http://www.dglady.com\'),titlepic=REPLACE(titlepic,\'http://19.104.116.112\', \'http://www.dglady.com\')

    出错了
     
  11. wm_chief

    wm_chief New Member

    注册:
    2005-09-05
    帖子:
    17,890
    赞:
    46
    汗,你用phpmyadmin运行
     
  12. jcking

    jcking Well-Known Member

    注册:
    2005-08-30
    帖子:
    22,282
    赞:
    70
    BD..........
     
  13. kamsang

    kamsang New Member

    注册:
    2005-10-05
    帖子:
    9,080
    赞:
    58
    好难..