Enthusiast script issues/fixes

Everything related to the visual and coding aspects of websites.
User avatar
Bobbi
Posts: 43
Joined: Mon Jul 16, 2012 10:00 pm

Re: Enthusiast script issues/fixes

Post 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
Post Reply