Thread

Hello Everyone

I’m having this issue when installing EE2.1.3, i’m using xampp

A Database Error Occurred

Error Number: 1064

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 ‘TYPE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci’ at line 10

CREATE TABLE `exp_cp_search_index` ( `search_id` int(10) UNSIGNED NOT NULL auto_increment, `controller` varchar(20) default NULL, `method` varchar(50) default NULL, `language` varchar(20) default NULL, `access` varchar(50) default NULL, `keywords` text, PRIMARY KEY `search_id` (`search_id`), FULLTEXT(`keywords`) ) TYPE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Filename: D:\live_websites\winewalk\system\codeigniter\system\database\DB_driver.php

Line Number: 330

can Anyone Help please..

Thank you

Hi Anthony,

Have you run our Server Wizard on this setup? You might be using an older version of MySQL

Take a look at this thread where I believe a solution was found

Thanks that helped I just had to replace “TYPE=MyISAM” with “ENGINE=MyISAM”

Awesome, glad John’s advice took care of it! Feel free to post again the next time you need some help.