2013-04-26 08:58
浏览 44


I am trying to install opencart- on my localhost. But i am getting an error after STEP3-CONFIGURATION. The error is

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 Error No: 1064

CREATE TABLE `oc_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:\wamp\www\vogue\system\database\mysql.php on line 50

图片转代码服务由CSDN问答提供 功能建议

我正在尝试在我的localhost上安装 opencart- 。 但是在STEP3-CONFIGURATION之后我收到了一个错误。 错误是

注意:错误:您的SQL语法中有错误; 查看与您的MySQL服务器版本对应的手册 ,使用正确的语法 ' '使用'\'0 \', zone_id int(11)NOT NULL DEFAULT \'0 \',PRIMARY KEY (第13行的 address_id '错误号:1064

  CREATE TABLE`oc_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;在第50行的D:\ wamp \ www \ vogue \ system \ database \ mysql.php 
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • drsrq26482 2013-04-26 09:04

    Because probably You have magic_quotes_gpc directive turned On, thus all quotes and apostrophes gets escaped by auto adding of slashes...

    In Your php.ini find the directive magic_quotes_gpc and set to Off.

    打赏 评论

相关推荐 更多相似问题