URL to your eFiction: www.fiction-place.com/archive
Version of eFiction: 3.2 Upgrading to 3.3
Have you bridged eFiction, if so with what?: no idea what that means
Version of PHP: 444
Version of MySQL: 5.0
Have you searched for your problem: yes
If so, what terms did you try: Searched the forums.
State the nature of your problem: I am receiving the error message shown below when I began the upgrade to 3.3.
Do you have a test account for us?: Yes. It is called Test, and the password is test. I can't access anything though.
Error Message:
A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfictionfanfiction_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', `v
These might help you:
https://efiction.org/forums/index.php?topic=4849.0 (Install 3.0, then upgrade)
https://efiction.org/forums/index.php?topic=4888.0
https://efiction.org/forums/index.php?topic=5269.0 (take the problem out of the file)
According to the last two the zip should be updated with the changes.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
Thank you so much! Those suggestions worked. It was the "collate" one that did it.
