URL to your eFiction: http://dev.fieryspiritmedia.com/efiction/
http://dev.fieryspiritmedia.com/efiction/eFiction353/install/install.php?step=2§=submissions
NB: Because its on my dev sub-domain you will need username 'temp' and password 'assist123' Thanks. 🙂
Version of eFiction:Latest build 3.5.3
Have you bridged eFiction, if so with what?:No
Version of PHP:5.2.17
Version of MySQL:5.5.28-log
Have you searched for your problem:Yes have had to search to correct other problems in install also but this one doesnt seemto have an answer unless I have missed it.
If so, what terms did you try:Fatal Error at step 2, SQL Fatal Error, Error()
State the nature of your problem:
HI all, I Wondered if someone could help me. I've had a lot of problems installing this software.
Firstly, I had issues installing the database and had to manually install each table because of the outdated SQL code in the install files. Once I had done that I managed to get the install to go as far as step 2. At step 2 the stage where you are asked to make different settings selections I get the following error message:
A fatal MySQL error was encountered.
Query: UPDATE fanfiction_settings SET submissionsoff = '0', autovalidate = '0', coauthallowed = '1', store = 'files', storiespath = 'stories', minwords = '0', maxwords = '0', imageupload = '1', imageheight = '200', imagewidth = '200', roundrobins = '1', allowseries = '1' WHERE sitekey ='z7mRvfK97w'
Error: ()
Unless I'm reading this wrong, it seems to me that the installation process cant update the fanfiction_settings tables. Ive checked with PHP myadmin and the table seems to be correct. To make sure i dropped it and rebuilt this table.
There doesn't seem to be an error stated in the message to I'm finding it hard to debug.
Please also see my config.php
$dbname = "fierysp1_efiction_dev";
$dbuser= "fierysp1_eficdev";
$dbpass = "*********";
$sitekey = "*********";
$settingsprefix = "";
include_once("includes/dbfunctions.php");
if(!empty($sitekey)) $dbconnect = dbconnect($dbhost, $dbuser,$dbpass, $dbname);
Do you have a test account for us?No not got that far yet.
Its now 2:30 in the morning and I'm tearing my hair out a bit with this install. Software looks really nice and I can't find anything similar and it fits my requirements perfectly. I have to say though that a little bit of work does need to go into the installation process judging by the amount of errors encountered on the forum. I've hit three different errors during install that I've had to solve and I don't have an unusual setup, its a straight forward LAMP stack hosted with a reliable host. I appreciate its free and someone has put a lot of hard work into this so I'm not trying to be horrible but if it had a slicker install process more people would probably use it.
I would really appreciate any assistance you can give me.
Kindest regards.
Are you using a prefix for your other tables? If so note that there is a separate prefix for settings table than the others; maybe that's the issue? In this case it should be called just fanfiction_settings, no prefix when it's in the DB. Just a random guess. Also make sure the sitekeys match.
What I would do is just update the data manually to get it operational.
