1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

帝国CMS 5.0升级5.1错误解决办法!

Discussion in '源码讨论' started by qingshu123, Jul 8, 2009.

  1. qingshu123

    qingshu123 New Member

    Joined:
    Nov 1, 2008
    Messages:
    9
    Likes Received:
    0
    前几天我把帝国CMS从5.0升级到5.1出现了如下错误提示:
    Table ‘phome_enewsloginfail’ already exists
    CREATE TABLE `***_enewsloginfail` ( `ip` varchar(20) NOT NULL default ”, `num` tinyint(4) NOT NULL default ‘0′, `lasttime` int(11) NOT NULL default ‘0′, PRIMARY KEY (`ip`) ) ENGINE=MYISAM DEFAULT CHARSET=gbk

    开始以为是编码问题,在论坛也搜索了一下,出现这个问题的还真不少,真正解决的却没有几个,经过反复琢磨,这个错误提示是说明这个表已经在数据库里,所以没法升级!那么我们就删除它,经过观察我发现,需要删除的表一共4个!

    phome_enewsloginfail

    phome_enewswapstyle

    phome_enewsplayer

    phome_enewspl

    找到这4个表把他们删除在升级就可以了,我测试是成功的!大家不防试试,要先备份哦!

    原文地址:http://www.mclog.cn/?p=179
     
  2. wm_chief

    wm_chief New Member

    Joined:
    Sep 5, 2005
    Messages:
    17,890
    Likes Received:
    46
    你原先是不是装了5.1测试版然后再装5.0,因为5.1测试版没有表没有删除就直接安装5.0所致
     
  3. znier

    znier New Member

    Joined:
    May 7, 2009
    Messages:
    45
    Likes Received:
    0
    其实这个还没以前的好用