URL to your eFiction: http://fiction.simonsflower.net
Version of eFiction: 2.0.5, but it didn't reinstall correctly and now doesn't work at all
Have you bridged eFiction, if so with what?: no
Version of PHP: probably 4.3 (I'm not sure and my host runs 4.x and 5.1)
Version of MySQL: 4.0
Have you searched for your problem: yes
If so, what terms did you try: error 1064, create table module (those searches yielded these links: Fatal MySQL error and How do I create the modules table?, neither of which addressed my problem)
State the nature of your problem: attempted to upgrade from 2.0.5 and received the following error at step 4:
A fatal MySQL error was encountered.
Query: CREATE TABLE `rpfanfiction_modules` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) collate latin1_general_ci NOT NULL default 'Test Module', `version` varchar(10) collate latin1_general_ci NOT NULL default '1.0', PRIMARY KEY (`id`), KEY `name_version` (`name`,`version`) )
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 'Test Module', `ve
At this point, I ran a search of the forums and found the "Fatal MySQL error" link above. The solution didn't help me because there were no instances of "collate latin1_general_ci" in the files. I attempted to reinstall 2.0.5 and now it's completely screwed with the following error on the home page:
Parse error: parse error, unexpected '.' in /home/content/t/m/a/tmasen/html/fiction/lib/class.TemplatePower.inc.php on line 207
Do you have a test account for us? I don't remember and, since the site is currently inaccessible, it's a moot point. I believe there is a test account, if I could get it working again.
Please let me know if I have to reinstall from scratch. Since eFiction hates me, this might be the best bet but I'd like advice first.
Do you have a backup? If so restore your back then do a search in install/upgrade20.php and remove all instances of "collate latin1_general_ci" Then run the update.
Do you have a backup? If so restore your back then do a search in install/upgrade20.php and remove all instances of "collate latin1_general_ci" Then run the update.
I had attempted to reinstall from the backup and that's when things got really messed up.
It finally worked, but only because I reinstalled eFic 3.3.1 in a completely new directory with new database, then manually copied all the settings, characters, stories, etc. from the old database. Incredibly tedious but it worked.
