It took me all day to get this fixed because I don't know anything about PHP and I didn't get a reply to my post asking about how to solve it (post has already been deleted). So I want to pass this on to anyone who can use it. This worked for me, and hopefully, it will work for you, too, because in my efic travels, I've seen that a lot of people had my very issue.
If you're trying to do an install and keep getting error messages like these:
A fatal MySQL error was encountered.
Query: CREATE TABLE IF NOT EXISTS`settingsfanfiction_settings` ( `sitekey` varchar(50) NOT NULL default '1', `sitename` varchar(200) NOT NULL default 'Your Site', `slogan` varchar(200) NOT NULL default 'It''s a cool site!', `url` varchar(200) NOT NULL default ' http://www.yoursite.com', `siteemail` varchar(200) NOT NULL default 'you@yoursite.com', `tableprefix` varchar(50) NOT NULL default '', `skin` varchar(50) NOT NULL default 'default', `hiddenskins` varchar(255) default '', `language` varchar(10) NOT NULL default 'en', `submissionsoff` tinyint(1) NOT NULL default '0', `storiespath` varchar(20) NOT NULL default 'stories', `store` varchar(5) NOT NULL default 'files', `autovalidate` tinyint(1) NOT NULL default '0', `coauthallowed` int(1) NOT NULL default '0', `maxwords` int(11) NOT NULL default '0', `minwords` int(11) NOT NULL default '0', `imageupload` tinyint(1) NOT NULL default '0', `imageheight` int(11) NOT NULL default '200', `imagewidth` int(11) NOT NULL default '200', `roundrobins` tinyint(1) NOT NULL default '0', `allowseries` tinyint(4) NOT NULL default '2', `tinyMCE` tinyint(1) NOT NULL default '0', `allowed_tags` varchar(200) NOT NULL default '
', `favorites` tinyint(1) NOT NULL default '0', `multiplecats` tinyint(1) NOT NULL default '0', `newscomments` tinyint(1) NOT NULL default '0', `logging` tinyint(1) NOT NULL default '0', `maintenance` tinyint(1) NOT NULL default '0', `debug` tinyint(1) NOT NULL default '0', `captcha` tinyint(1) NOT NULL default '0', `dateformat` varchar(20) NOT NULL default 'd/m/y', `timeformat` varchar(20) NOT NULL default '- h:i a', `recentdays` tinyint(2) NOT NULL default '7', `displaycolumns` tinyint(1) NOT NULL default '1', `itemsperpage` tinyint(2) NOT NULL default '25', `extendcats` tinyint(1) NOT NULL default '0', `displayindex` tinyint(1) NOT NULL default '0', `defaultsort` tinyint(1) NOT NULL default '0', `displayprofile` tinyint(1) NOT NULL default '0', `linkstyle` tinyint(1) NOT NULL default '0', `linkrange` tinyint(2) NOT NULL default '5', `reviewsallowed` tinyint(1) NOT NULL default '0', `ratings` tinyint(1) NOT NULL default '0', `anonreviews` tinyint(1) NOT NULL default '0', `revdelete` tinyint(1) NOT NULL default '0', `rateonly` tinyint(1) NOT NULL default '0', `pwdsetting` tinyint(1) NOT NULL default '0', `alertson` tinyint(1) NOT NULL default '0', `disablepopups` tinyint(1) NOT NULL default '0', `agestatement` tinyint(1) NOT NULL default '0', `words` text, `version` varchar(10) NOT NULL default '3.5.3', `smtp_host` varchar(200) default NULL, `smtp_username` varchar(50) default NULL, `smtp_password` varchar(50) default NULL, PRIMARY KEY (`sitekey`) ) TYPE=MyISAM;
Error: ()
It's because TYPE=MyISAM in PHP is deprecated and needs to be changed to this ENGINE=MyISAM. My server tech told me that you need to do a find/replace in the install.php. He wound up doing it for me, and after fighting with efic for 4.5 days to no avail (I kept re-installing, hoping it would take at some point), I'm finally installed and working.
This is what you do:
Unzip the eFic files, go into the install folder, and replace the install.php with the one I'm linking to in this post. My server tech already made all of the necessary changes, so all you have to do is place it in your efic directory, follow the usual instructions that come with the software, go to http://www.yoursite.com/ and install like usual. This time, the system should create the tables and allow a clean install.
Hope this helps some of you.
install.php (Replaced on 2/7/2013)
Password: efiction
P.S. Save the install.php on your HD somewhere in case you need to use it for a future install.
Cheers!
Thanks for doing this. I discovered the problem a while ago but had ZERO time to post up the corrected file. (I did post about it in several places so I'm sad you didn't see it. : )
It's no problem. I found a lot of posts, but I'm not versed in PHP
at all (I really need my hand held for stuff like that), so while
I did see some posts that spoke about changing the "TYPE=MyISAM",
I really wasn't sure how to exactly go about everything. Once my server
people explained and sent me the fixed doc, I figured I'd share it with
anyone else who was in trouble. 🙂
The install.php link in your post didn't work (Maybe it's just me), but I went through and did it manually and IT WORKED!! I've been trying to get this thing installed for days! Being new to all this, it took quite a while to just figure out what I needed, so when following the instructions didn't work I just about screamed. Thank you thank you thank you! 😀
Ah, that site must have deleted the file. Thanks for the heads up.
I still have the original, so I'll swap out the link. No need for other
users to suffer or have to dig through all these forum posts. 😆
Thanks for the work, I was about to give up :3
I am rebuilding efiction! Join us on irc! #efiction at
No problem. I'm glad to help!
An update, the included challenges block is out of date for the same reason. I tried it and it broke my install. i guess it acted like an injection and a bunch of the tables wont display right. Its kinda funny.
I am rebuilding efiction! Join us on irc! #efiction at
