URL to your eFiction: http://www.flankers-tale.com/eFiction32/
Version of eFiction: 3.2
Have you bridged eFiction, if so with what?: no
Version of PHP: 4.4.4 (apparently actually 5 parsed as 4 according to the FAQ on my host)
Version of MySQL: 4.0.25
Have you searched for your problem: yes
If so, what terms did you try:fatal sql error, install error, step 3 sql error
State the nature of your problem:
I'm trying to install eFiction 3.2 on a new domain. So far I've tried it four times with the same error, the first time I had forgotten to move and chmod the config file, the second time I remembered that and still got the error, the third I gave up the attempt to use the directory "eFiction" and uploaded it "as is" from the zip so the directory would be "eFiction32" and moved and chmod the config file, and the fourth time I downloaded the zip again, unziped and uploaded, moved the chmod the config file, and made as few changes as possible from the default settings.
The error I get is:
A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_stats` ( `sitekey` varchar(50) collate latin1_general_ci NOT NULL default '0', `stories` int(11) NOT NULL default '0', `chapters` int(11) NOT NULL default '0', `series` int(11) NOT NULL default '0', `reviews` int(11) NOT NULL default '0', `wordcount` int(11) NOT NULL default '0', `authors` int(11) NOT NULL default '0', `members` int(11) NOT NULL default '0', `reviewers` int(11) NOT NULL default '0', `newestmember` int(11) NOT NULL default '0' ) ENGINE=MyISAM
Error: (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 'collate latin1_general_ci NOT NULL default '0', `stories` int
I have made each install attempt with a fresh database (the hosting service is probably wondering why I've created and deleted four databases over the last few hours). I've tried a different prefix for the tables each time (no prefix this last time since this database won't be shared).
This is especially frustrating since I was able to install and configure it properly on another domain with the same level hosting package on the same hosting service previously. The main difference between the two is that on the first domain I installed 3.0 and then upgraded to 3.2. Some of the initial configurations maybe be different as well since I can't remember what I had there originally, it was a test install to figure things out before tackling the "real" site.
Is there a way to just copy the database and stuff from the tephras.com site to the flankers-tale.com site? Do you think that would solve the problem? Anyone have 3.0 laying around so I can try installing that and upgrading (I deleted the old version when I finished upgrading)? I'm an extreme newbie with php and sql but I can follow instructions.
Do you have a test account for us? No
[ETA: The "solution" was to install version 3.0 and then immediately upgrade to 3.2]
