Error executing query:

[KCherieParticipant]

Hi! I’m not sure what I’m not doing right, or how to fix this.

Whenever I try to install Enthusiast I get this error:

Error executing query: 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 AUTO_INCREMENT=1′ at line 1; CREATE TABLE affiliates (affiliateid int(5) NOT NULL auto_increment,url varchar(254) NOT NULL default ”,title varchar(254) NOT NULL default ”,imagefile varchar(254) default NULL,email varchar(255) NOT NULL default ”,added date default NULL,PRIMARY KEY (affiliateid)) TYPE=MyISAM AUTO_INCREMENT=1

[AmelieKeymaster]

New versions of MySQL don’t require the ‘TYPE=MyISAM’ bit that Enth puts in the install script.

To fix it, you’ll need to remove any half-created tables (if any) and then modify install.php as follows:

On lines 138, 151, 166, 198 and 246 (or around those lines depending on your editor), change this:

') TYPE=MyISAM AUTO_INCREMENT=1';

To:

') AUTO_INCREMENT=1';

On line 271, change this:

') TYPE=MyISAM';

To:

')';

That will fix the initial install. You will also need to modify a couple of other files so that creating new fanlistings does not cause the same problem. Open mod_owned.php and go to line 905. Change this:

") TYPE=MyISAM AUTO_INCREMENT=1";

To:

") AUTO_INCREMENT=1";

Then open mod_setup.php and go to line 278. Change this:

') TYPE=MyISAM;';

To:

')';

Save all the files and reupload. Everything should then work.

[KCherieParticipant]

Thanks for the response!!

It’s now saying:

Error executing query: 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 AUTO_INCREMENT=2′ at line 1; CREATE TABLE faaemailtemplate (templateid int(3) NOT NULL auto_increment,templatename varchar(255) NOT NULL default ”,subject varchar(255) NOT NULL default ”,content text NOT NULL,deletable tinyint(1) NOT NULL default ’1′,PRIMARY KEY (templateid)) TYPE=MyISAM AUTO_INCREMENT=2

[endrohatParticipant]

remove TYPE=MyISAM

[KCherieParticipant]

Thank you, it worked!

[Author]

Posts