FreeDiscuz! » Discuz! 深入开发 » 無法由Discuz 6.0L轉回Discuz 6.0 [急]

lyfhk 发表于 2008-5-31 12:39

無法由Discuz 6.0L轉回Discuz 6.0 [急]

去到第4步   論壇道具功能相關數據結構恢復 時
Discuz! info: MySQL Query Error

Time: 2008-5-31 4:36am
Script:

SQL: CREATE TABLE [Table]magiclog (
uid mediumint(8) unsigned NOT NULL DEFAULT '0',
magicid smallint(6) unsigned NOT NULL DEFAULT '0',
`action` tinyint(1) NOT NULL DEFAULT '0',
dateline int(10) unsigned NOT NULL DEFAULT '0',
amount smallint(6) unsigned NOT NULL DEFAULT '0',
price mediumint(8) unsigned NOT NULL DEFAULT '0',
targettid mediumint(8) unsigned NOT NULL DEFAULT '0',
targetpid int(10) unsigned NOT NULL DEFAULT '0',
targetuid mediumint(8) unsigned NOT NULL DEFAULT '0',
KEY uid (uid,dateline),
KEY targetuid (targetuid,dateline)
) ENGINE=MYISAM default CHARSET=big5
Error: Table '[Table]magiclog' already exists
Errno.: 1050

怎處理
求救!!

御剑江湖 发表于 2008-5-31 12:55

Error: Table '[Table]magiclog' already exists

magiclog表已经存在...........你之前是不是由D60转换到D6Lite的?

lyfhk 发表于 2008-5-31 12:56

是,現在怎辦?

御剑江湖 发表于 2008-5-31 12:56

之前是否使用过D6->D6L的转换程序?

lyfhk 发表于 2008-5-31 12:57

使用過

御剑江湖 发表于 2008-5-31 12:59

用PMA进数据库看看magiclog是否存在
如果存在的话

把转换程序里的这段[code]
CREATE TABLE cdb_magiclog (
  uid mediumint(8) unsigned NOT NULL DEFAULT '0',
  magicid smallint(6) unsigned NOT NULL DEFAULT '0',
  `action` tinyint(1) NOT NULL DEFAULT '0',
  dateline int(10) unsigned NOT NULL DEFAULT '0',
  amount smallint(6) unsigned NOT NULL DEFAULT '0',
  price mediumint(8) unsigned NOT NULL DEFAULT '0',
  targettid mediumint(8) unsigned NOT NULL DEFAULT '0',
  targetpid int(10) unsigned NOT NULL DEFAULT '0',
  targetuid mediumint(8) unsigned NOT NULL DEFAULT '0',
  KEY uid (uid,dateline),
  KEY targetuid (targetuid,dateline)
) TYPE=MyISAM;
[/code]前后加上 /* */注释掉

lyfhk 发表于 2008-5-31 13:02

[code]
/*CREATE TABLE cdb_magiclog (
  uid mediumint(8) unsigned NOT NULL DEFAULT '0',
  magicid smallint(6) unsigned NOT NULL DEFAULT '0',
  `action` tinyint(1) NOT NULL DEFAULT '0',
  dateline int(10) unsigned NOT NULL DEFAULT '0',
  amount smallint(6) unsigned NOT NULL DEFAULT '0',
  price mediumint(8) unsigned NOT NULL DEFAULT '0',
  targettid mediumint(8) unsigned NOT NULL DEFAULT '0',
  targetpid int(10) unsigned NOT NULL DEFAULT '0',
  targetuid mediumint(8) unsigned NOT NULL DEFAULT '0',
  KEY uid (uid,dateline),
  KEY targetuid (targetuid,dateline)
) TYPE=MyISAM;*/
[/code]這樣?

御剑江湖 发表于 2008-5-31 13:04

是的~~~~~~~~~

[[i] 本帖最后由 御剑江湖 于 2008-5-31 16:44 编辑 [/i]]

044003 发表于 2008-8-31 11:08

用DROP TABLE IF EXISTS `cdb_magiclog`

查看完整版本: 無法由Discuz 6.0L轉回Discuz 6.0 [急]