(FIXED) MySQL Error...
 
Notifications
Clear all

(FIXED) MySQL Errors in 2.0 - 3.0 Upgrade - Fatal MySQL Errors

2 Posts
2 Users
0 Reactions
2,018 Views
(@mattw)
Posts: 5
Active Member
Topic starter
 

I get to the part where I need to add the site key, the one with the intructions:

Each eFiction site requires a sitekey under which the site's settings will be stored. The sitekey also prevents data from two eFiction sites on the same domain from getting crossed. You may use the randomly generated key or choose one of your own.

I place a sitekey in or use the automatically generated one, and press submit, and I get an error message:

A fatal MySQL error was encountered.
Query: INSERT INTO afcfanfiction_settings( `sitekey`, `sitename`, `slogan`, `url`, `siteemail`, `tableprefix`, `skin`, `language`, `submissionsoff`, `storiespath`, `store`, `autovalidate`, `maxwords`, `minwords`, `imageupload`, `imageheight`, `imagewidth`, `roundrobins`, `tinyMCE`, `allowed_tags`, `favorites`, `multiplecats`, `newscomments`, `recentdays`, `displaycolumns`, `itemsperpage`, `displayindex`, `defaultsort`, `reviewsallowed`, `ratings`, `anonreviews`, `revdelete`, `rateonly`, `pwdsetting`, `alertson`, `disablepopups`, `agestatement`, `words`, `smtp_host`, `smtp_username`, `smtp_password`) VALUES( 'afc', '', '', '', '', '', '', '', , '', '', , 0, 0, , 0, 0, , , '', , 1, , 0, 1, 10, 0 , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '');
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 ' '', '', , 0, 0, , 0, 0, , , '', , 1, , 0, 1, 10, 0 , 0, ' at line 10


 
Posted : 20/01/2007 5:53 am
(@tammy)
Posts: 2577
Member Moderator
 

Did you delete you config.php file or something?  There's not data from your 2.0 site.  No sitename, slogan, skin...nothing.  You need to restore your 2.0 config file.  Make sure it's CHMOD'd to 666 and then continue on from step 2.


 
Posted : 20/01/2007 1:10 pm
Share: