ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Database Error When Installing

June 10, 2013 9:49pm

Subscribe [1]
  • #1 / Jun 10, 2013 9:49pm

    davebush

    42 posts

    I’m getting this error when installing EE:

    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: schema/mysql_schema.php

    Line Number: 1336

    I’ve installed EE on this same server without any trouble in the past, but I’m getting this error now. Any suggestions will be much appreciated.

    Thanks
    Dave

  • #2 / Jun 10, 2013 10:06pm

    davebush

    42 posts

    Case closed - I found the answer in a previous thread.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases