URL to your eFiction: http://fanfic.kaz-2y5.com
Version of eFiction: 2.0, upgrading to 3.3
Have you bridged eFiction, if so with what?: nothing
Version of PHP: 4.something, host doesn't have it listed
Version of MySQL: 4.1
Have you searched for your problem: yes
If so, what terms did you try:
State the nature of your problem: listed below
Do you have a test account for us? no
Upgrade was going fine, and then . . .
A fatal MySQL error was encountered.
Query: INSERT INTO ficfanfiction_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( 'p6cWipHeCq', '', '', '', '', '', '', '', , '', '', , 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,
I CHMOD'd the config.php to 666, it's still there, I didn't remove it. I have no idea what the problem is.
EDIT: I'm rolling back to 2.0 for now, gonna give upgrading another shot in the morning.
Looks like it has something to do with an expected value to be inserted in your submissionsoff column. When you get an error like that, the syntax for the statement's incorrect. What does your 2.0 site have for submissions settings...are you accepting submissions?
What happened to your config file? It's empty.
Yes, we're accepting submissions.
I don't have any idea what happened to the config file, because I didn't change anything. I've gone back to the previous 2.0 for now, which is working fine. I'm not sure right now if I'm going to attempt the upgrade again, because it's twice now I've tried and run into problems.
Dana
What exactly are the problems you're running into. And if you know, at what step(s) is it that they're occurring. That can help alot with determining why the upgrade isn't going smoothly.
Both times, it's been exactly the same problem, as described in the first post. I CHMOD the config.php to 666, start the upgrade, and get that. Can't get past it.
Dana
I honestly don't know what might be happening just from looking at the update and install files, since it's not trying to insert default values into the settings table, it's found your config file, however it's putting in blank values for it and from viewing your site, the config isn't empty. Never ran into that error before.
You could try this since you have a back up of your live site: make sure you have a copy of your 2.0 site's config file. Delete it from your efic directory and overwrite the files with the 3.3 files. Go to your site, run the upgrade. I ended up upgrading in a similar fashion with my 2.0 sites because I had my config file outside the webroot for security, so the upgrade script assumed I didn't have one. Everything else upgraded fine, existing stories, authors, members and I even successfully bridged it.
Just something for you to think about if no one else can offer up a solution to try
One workaround although it's a bit fiddly:
1. Run the upgrade until the error occurs
2. Copy the INSERT statement from the error message into a text editor, and manually copy the correct value for each of the settings listed after "INSERT INTO ficfanfiction_settings(" into the list of fields after "VALUES( '" using your old config.php as a reference for what the correct values should be.
3. Run your modified INSERT statement against the database manually using php mysqladmin or whatever tools your host provides to manage the database
4. Manually replace config.php with a version 3 one (replacing the values in " " with your settings):
<?php
$dbhost = "HOST";
$dbname = "DATABASE";
$dbuser= "USERNAME";
$dbpass = "PASSWORD";
$sitekey = "SITEKEY";
$settingsprefix = "SETTINGSPREFIX";
include_once("includes/dbfunctions.php");
if(!empty($sitekey)) $dbconnect = dbconnect($dbhost, $dbuser,$dbpass, $dbname);
?>
5.Browse to /install/upgrade20.php?step=3 to pickup the upgrade process from the next step.
