Page 2 of 2

Re: Enthusiast script issues/fixes

Posted: Fri Jun 30, 2017 6:52 pm
by Bobbi
Info for anyone trying to install Enth.

I'm trying to do a clean install of Enthusiast 3.1.5 and after running the install script, I get this:
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
I'm using mysql version 5.5.52-cll
Enth was written with 5.3 in mind, I believe.

So if you get this problem:

Code: Select all

Find: TYPE=MyISAM
Replace with: ENGINE=MyISAM
And that should fix the problem! :D