Question

ecshop2.7.3安装数据失败SQL Error: ERROR NO: 1064 ERROR MSG: You have an error in your SQL syntax;

MySQL版本 5.1.61，安装ecshop
安装数据............失败
SQL Error: ERROR NO: 1064 ERROR MSG: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 18 Query String: CREATE TABLE `ecs_ad` ( `ad_id` smallint(5) unsigned NOT NULL auto_increment, `position_id` smallint unsigned NOT NULL default '0', `media_type` tinyint(3) unsigned NOT NULL default '0', `ad_name` varchar(60) NOT NULL default '', `ad_link` varchar(255) NOT NULL default '', `ad_code` text NOT NULL, `start_time` int(11) NOT NULL default '0', `end_time` int(11) NOT NULL default '0', `link_man` varchar(60) NOT NULL default '', `link_email` varchar(60) NOT NULL default '', `link_phone` varchar(60) NOT NULL default '', `click_count` mediumint(8) unsigned NOT NULL default '0', `enabled` tinyint(3) unsigned NOT NULL default '1', PRIMARY KEY (`ad_id`), KEY `position_id` (`position_id`), KEY `enabled` (`enabled`) ) TYPE=MyISAM File Path: /home/u99xxxx806/public_html/install/data/structure.sql
我的QQ3116982922

Answer 1

你在18行的查询字符串 TYPE=MyISAM 附近有语法错误；你这里体现不出行数来。
希望能够帮到你

追问

谢谢帮助！我是小白，不知道 从哪儿去查看那个文件的18号呀？请你多多指导！再次谢谢！

追答

CREATE TABLE `ecs_ad` ( `ad_id` smallint(5) unsigned NOT NULL auto_increment, `position_id` smallint unsigned NOT NULL default '0', `media_type` tinyint(3) unsigned NOT NULL default '0', `ad_name` varchar(60) NOT NULL default '', `ad_link` varchar(255) NOT NULL default '', `ad_code` text NOT NULL, `start_time` int(11) NOT NULL default '0', `end_time` int(11) NOT NULL default '0', `link_man` varchar(60) NOT NULL default '', `link_email` varchar(60) NOT NULL default '', `link_phone` varchar(60) NOT NULL default '', `click_count` mediumint(8) unsigned NOT NULL default '0', `enabled` tinyint(3) unsigned NOT NULL default '1', PRIMARY KEY (`ad_id`), KEY `position_id` (`position_id`), KEY `enabled` (`enabled`) ) TYPE=MyISAM File Path: /home/u99xxxx806/public_html/install/data/structure.sql

就在上面你含有sql语句的文件里，那里会将行数体现出来，你18行的语法错误。
错误提示是这么说的，ecshop 我没安过。希望能帮到你。文件路径在最后一行：File Path: /home/u99xxxx806/public_html/install/data/structure.sql就是这个structure.sql文件里