我的系统环境是 win7 64位旗舰版 + IIS +PHP + MYSQL ,安装到第三步就会出现以下提示,不知道是啥原因,谁能够帮忙看下,怎样解决这个问题!
PHP Notice: 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 '\'0\',
`zone_id` int(11) NOT NULL DEFAULT \'0\',
PRIMARY KEY (`address_id`),' at line 13<br />Error No: 1064<br />CREATE TABLE `cl_address` (
`address_id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NOT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`company` varchar(32) NOT NULL,
`company_id` varchar(32) NOT NULL,
`tax_id` varchar(32) NOT NULL,
`address_1` varchar(128) NOT NULL,
`address_2` varchar(128) NOT NULL,
`city` varchar(128) NOT NULL,
`postcode` varchar(10) NOT NULL,
`country_id` int(11) NOT NULL DEFAULT \'0\',
`zone_id` int(11) NOT NULL DEFAULT \'0\',
PRIMARY KEY (`address_id`),
KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
in D:\WwwRoot\PHPDevelopment\system\database\mysql.php on line 50作者: sunboy 时间: 2013-9-26 18:49
你这个opencart是哪里来的? 原版本不是这样子的,
`zone_id` int(11) NOT NULL DEFAULT '0', 是这样写的,
你的是
`zone_id` int(11) NOT NULL DEFAULT \'0\',