Thread

I am getting the following on install.  Any help is appreciated.

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: C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\ee213\metsys\codeigniter\system\database\DB_driver.php

Line Number: 330

Help with this would be much appreciated.  It seems that the error is due to the TYPE= being depreciated in the latest MySQL release.  i would prefer to not have to roll back to an old version of MySQL.

What versions of PHP, MySQL and EE are you using?

Using php 5.3 EE 2.1.3 and MySQL 5.5.

Same problem over here, im tring to install ee for the first time and ive got

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: C:\wamp\www\system\codeigniter\system\database\DB_driver.php

Line Number: 330

I’m using
php 5.3
EE 2.1.3
MySQL 5.5

Also tryed a fresh install on my other laptop same software but a fresh download of ee 2.1.3 and it kicked back the same error!
Any help would be very helpful

I think TYPE= was removed in the most recent MySQL version, yes. For a quick fix, can you try to replace

TYPE=MyISAM

with

ENGINE=MyISAM

?

Perfect done the job!

So where would that change be made?

codeigniter\system\database\DB_driver.php does not contain the TYPE= code

I changed it in two places i’m gessing the code on db_driver.php calls that snippet from another file
any way the places i changed it were

1. “system/installer/updates/ud_200.php”
2. “system/installer/schema/mysql_schema.php”

hope it helps

Thanks for the assist, beardsell.

CanfieldSci - were you able to get things working?

We had to roll back to MySQL 5.1.  Maybe when we go live we will be able to build out with 5.5.

Glad you are up and running again.Feel free to start a new thread if you have any more questions.