NoName Mobile

NoName » Project Parasy » sai 你好,我的为什么不能升级数据库?出错了.

sai 你好,我的为什么不能升级数据库?出错了.

by 怪鱼 at 2007-7-30 11:50

sql.txt 在后台升级,出现错误 Duplicate column name 'board_name'

我删了 'board_name' 还有最后一句 ENGINE=MyISAM DEFAULT CHARSET=gbk;

又出现:升级错误，MySQL 提示: 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 'char(50) NOT NULL AFTER `simple`' at line 1 ，请返回。

能告诉我怎么解决吗??

# 1 - Sai at 2007-7-30 12:13

使用下面这段sql语句试一试

[Copy to clipboard]

CODE:

ALTER TABLE `cdb_forums` ADD `board_name` char(50) NOT NULL ;
ALTER TABLE `cdb_forums` ADD `idx_push` tinyint(1) NOT NULL default '0' ;
ALTER TABLE `cdb_favorites` ADD `dateline` int(10) NOT NULL;

CREATE TABLE `cdb_savepoint` (
  `svp_id` int(10) unsigned NOT NULL auto_increment,
  `svp_uid` int(10) unsigned NOT NULL default '0',
  `svp_url` varchar(255) NOT NULL default '',
  `svp_rank` int(10) unsigned NOT NULL default '0',
  `svp_created` int(10) unsigned NOT NULL default '0',
  `svp_lastupdated` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`svp_id`),
  KEY `INDEX_UID` (`svp_uid`),
  KEY `INDEX_URL` (`svp_url`)
) ENGINE=MyISAM;

# 2 - 怪鱼 at 2007-7-30 12:17

升级错误，MySQL 提示: Duplicate column name 'board_name' ，请返回。

我是在本地测试的,这跟本地服务器没关系吧?是不是我机子不支持?

# 3 - Sai at 2007-7-30 12:23

跳过前面三段(已经执行过了)，直接执行

[Copy to clipboard]

CODE:

CREATE TABLE `cdb_savepoint` (
  `svp_id` int(10) unsigned NOT NULL auto_increment,
  `svp_uid` int(10) unsigned NOT NULL default '0',
  `svp_url` varchar(255) NOT NULL default '',
  `svp_rank` int(10) unsigned NOT NULL default '0',
  `svp_created` int(10) unsigned NOT NULL default '0',
  `svp_lastupdated` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`svp_id`),
  KEY `INDEX_UID` (`svp_uid`),
  KEY `INDEX_URL` (`svp_url`)
) ENGINE=MyISAM;

# 4 - 怪鱼 at 2007-7-30 12:53

升级错误，MySQL 提示: 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 'ENGINE=MyISAM' at line 1 ，请返回。

按你说!

# 5 - Sai at 2007-7-30 12:59

你的mysql版本是？

# 6 - 怪鱼 at 2007-7-30 13:01

本套件使用程序版本：

Apache v1.3.29 (Win32)

PHP v4.3.4 (Win32)

Zend Optimizer v2.1.0 (Win32)

MySQL v4.0.17(Win32)