ECShop 网上商店系统支持论坛 » 安装使用 » 系统搬家后数据没法恢复

linang99 发表于 2008-8-26 18:21

系统搬家后数据没法恢复

系统搬家后没法恢复了。原来的mysql是5.x现在的是4.x，一点恢复后就出现了这个[b]MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => CREATE TABLE `ecs_cart` ( `rec_id` mediumint(8) unsigned NOT NULL auto_increment, `user_id` mediumint(8) unsigned NOT NULL default '0', `session_id` char(32) character set gbk collate gbk_bin NOT NULL default '', `goods_id` mediumint(8) unsigned NOT NULL default '0', `goods_sn` varchar(60) NOT NULL default '', `goods_name` varchar(120) NOT NULL default '', `market_price` decimal(10,2) unsigned NOT NULL default '0.00', `goods_price` decimal(10,2) NOT NULL default '0.00', `goods_number` smallint(5) unsigned NOT NULL default '0', `goods_attr` text NOT NULL, `is_real` tinyint(1) unsigned NOT NULL default '0', `extension_code` varchar(30) NOT NULL default '', `parent_id` mediumint(8) unsigned NOT NULL default '0', `rec_type` tinyint(1) unsigned NOT NULL default '0', `is_gift` smallint(5) unsigned NOT NULL default '0', `can_handsel` tinyint(3) unsigned NOT NULL default '0', `goods_attr_id` mediumint(8) NOT NULL, PRIMARY KEY (`rec_id`), KEY `session_id` (`session_id`) ) ENGINE=MyISAM ) [2] => Array ( [error] => 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 'collate gbk_bin NOT NULL default '', `goods_id` mediumint(8) ) [3] => Array ( [errno] => 1064 ) ) [/b]
[b]请问这是怎么回事啊？[/b]

wanec 发表于 2008-8-26 21:31

to use near 'collate gbk_bin NOT NULL default '', `goods_id` mediumint(8)
执行这句sql时出现问题

linang99 发表于 2008-8-27 08:02

我对数据库不咋懂，这个该怎么解决啊？

查看完整版本: 系统搬家后数据没法恢复