2.0.7 to 3.3.1 upgr...
 
Notifications
Clear all

2.0.7 to 3.3.1 upgrade - SQL error 1064 (same problem as simonsflower)

2 Posts
1 Users
0 Likes
1,854 Views
(@gokugirl)
Posts: 60
Trusted Member
Topic starter
 

URL to your eFiction: http://dbfl.gokugirl.com
Version of eFiction: 2.0.7
Have you bridged eFiction, if so with what?: n/a
Version of PHP: 4.4.1
Version of MySQL: 12.22
Have you searched for your problem: yes
If so, what terms did you try: error 1064
State the nature of your problem: When I try to upgrade to 3.3.1 I receive the error below on step #4. This is after rolling back to the old version and trying again (config.php wasn't detected the first time).

A fatal MySQL error was encountered.
Query: CREATE TABLE `genfanfiction_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

Do you have a test account for us? no

I followed the instructions Tammy gave simonsflowers in this post and I received a new error on step 4.

A fatal MySQL error was encountered.
Query: CREATE TABLE `genfanfiction_authorfields` ( `field_id` int(11) NOT NULL AUTO_INCREMENT, `field_type` tinyint(4) NOT NULL default '0', `field_name` varchar(30) NOT NULL default ' ', `field_title` varchar(255) NOT NULL default ' ', `field_options` text, `field_code_in` text, `field_code_out` text, `field_on` tinyint(1) NOT NULL default '0', PRIMARY KEY (`field_id`) ) TYPE=MyISAM;
Error: (1050) Table 'genfanfiction_authorfields' already exists

- My eFiction Skins: http://www.gokugirl.com/efiction.php
- The Otaku Institute: http://oi.gokugirl.com
- The OI Same-Sex Archive: http://oisa.gokugirl.com
- The Dragon Ball Fanfiction Library: http://dbfl.gokugirl.com

 
Posted : 26/11/2007 2:43 am
(@gokugirl)
Posts: 60
Trusted Member
Topic starter
 

πŸ™„ I figured everything out on my own (it took a little while to get around to it, though). For those who come after me who need help as well, you have to create the tables manually on step #4 by copying and pasting each block of code in docs/upgrade20_step4.sql into the SQL query box in your database. You can also import the entire file, but I figured it was better to run queries table by table so that I could fix problems as they cropped up. After you complete the upgrade there might be fields and/or data missing from a few tables. Luckily I have a few eFiction 3 archives that are fine so I could figure out what to add from examining their databases and paying attention to the info I got by activating debug mode.

I didn't get any errors after step #4. Another upgrade of mine had similar problems on this step so I guess it's very tricky.

I have very minimal knowledge of SQL (and PHP) so I probably can't help anyone if there are any other problems. Sorry about that.

- My eFiction Skins: http://www.gokugirl.com/efiction.php
- The Otaku Institute: http://oi.gokugirl.com
- The OI Same-Sex Archive: http://oisa.gokugirl.com
- The Dragon Ball Fanfiction Library: http://dbfl.gokugirl.com

 
Posted : 25/12/2007 2:02 pm
Share: