Fatalerror SQL prob...
 
Notifications
Clear all

Fatalerror SQL problem with upgrading from 3.2 to 3.3

5 Posts
3 Users
0 Reactions
2,225 Views
 Saya
(@saya)
Posts: 30
Eminent Member
Topic starter
 

URL to your eFiction: http://www.silverblood.net/MS/index.php
Your version of eFiction: 3.2.1
Latest patch: NO... trying to update...
Mods: translated to Italian, but while upgrading I put back in the english
Version of PHP: 4.3.11
Version of MySQL: 4
Problem: Yes I searched for the problem... but didn't find an answer...

Query: CREATE TABLE `AoDfanfiction_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

I really don't know what to do... I tried really lot of things... ><

Thank you
~Saya


URL to your eFiction: http://kawaii-hito.org/fic/index.php and http://www.silverblood.net/MS
Your version of eFiction: 3.5
Latest patch: YES
Mods: only Challenges and translated to Italian
Version of PHP: 4.3.11
Version of MySQL: 4

 
Posted : 20/06/2007 2:01 pm
(@itanshi)
Posts: 381
Reputable Member
 

hmm latin1? maybe its not all back to english, just a guess

otherwise 'not null' sounds like its butting up against the old values in mysql


I am rebuilding efiction! Join us on irc! #efiction at www.mibbit.com Instructions for irc πŸ˜€ Alpha released!

 
Posted : 20/06/2007 3:23 pm
(@chelle)
Posts: 122
Estimable Member
 

Saya,

Try the solution suggested here: https://efiction.org/forums/index.php?topic=5269.0

Sounds like the same exact problem.  πŸ™‚


 
Posted : 20/06/2007 6:08 pm
 Saya
(@saya)
Posts: 30
Eminent Member
Topic starter
 

Saya,

Try the solution suggested here: https://efiction.org/forums/index.php?topic=5269.0

Sounds like the same exact problem.  πŸ™‚

°° i didn't think of it as a bug °° <- I tought it's me that got it all wrong ><
Thank you, I'll try to do it as it said there... I hope it will work... *runs reuploading the files*

EDIT: Thank you Chelle it was a bug, I had an old zip I think... and didn't even realise it....


URL to your eFiction: http://kawaii-hito.org/fic/index.php and http://www.silverblood.net/MS
Your version of eFiction: 3.5
Latest patch: YES
Mods: only Challenges and translated to Italian
Version of PHP: 4.3.11
Version of MySQL: 4

 
Posted : 20/06/2007 7:20 pm
(@chelle)
Posts: 122
Estimable Member
 

Glad it worked for ya. 


 
Posted : 20/06/2007 11:21 pm
Share: