URL to your eFiction: http://www.panbox.com.br/index.php
Version of eFiction: 1.1
Version of PHP: 4.4.4
Version of MySQL: 4.1.21-standard-log
Have you searched for your problem: Yes
State the nature of your problem:
I uploaded all the 3.2.1 files to the server except config.php, run the install.php and the upgrade was all done without any problems. But when it finished, I clicked the "Return to your site" link, my index was full of these errors, and although I chose CSSZEN as a new skin during the upgrade, it still loads the older skin.
Sorry for the bad english, it's not my native language.
Looks like it is still looking for the dbconfig.php file, judging from the error
Warning: main(/dbconfig.php) [function.main]: failed to open stream: No such file or directory in /home/panboxss/public_html/header.php on line 43
Warning: main(/dbconfig.php) [function.main]: failed to open stream: No such file or directory in /home/panboxss/public_html/header.php on line 43
I am no expert in this area, but if you are going from version 1 to 3 i think you need to dump the dbconfig file and load the config.php into your main directory with the information in it from the dbconfig. (it was a different system).
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
Thanks for the reply.
I deleted the dbconfig.php and I'm still getting the same errors. But the config.php is there, and it has the correct info about the database and the sitekey. Somehow it's not connecting to the database and I have no clue of what to do. =(
Sorry you have exhausted my knowlegde at this point, that was just a shot in the dark really.
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
Ok, I re-uploaded some files.
Now it loads the CSSZEN skin, and shows the maintenance page. But when I try to login, it reverts back to my old skin, and there's the message:
"This update will perform some tasks on the database to better your site's performance. You are advised to back up your database before starting!Are you ready to update? Yes or No"
If I click yes, it gives me the errors...
A fatal MySQL error was encountered.
Query: CREATE TABLE `eficfanfiction_stats` ( `sitekey` varchar(50) NOT NULL default '0', `stories` int(11) NOT NULL default '0', `chapters` int(11) NOT NULL default '0', `series` int(11) NOT NULL default '0', `reviews` int(11) NOT NULL default '0', `wordcount` int(11) NOT NULL default '0', `authors` int(11) NOT NULL default '0', `members` int(11) NOT NULL default '0', `reviewers` int(11) NOT NULL default '0', `newestmember` int(11) NOT NULL default '0' ) ENGINE=MyISAM
Error: (1050) Table 'eficfanfiction_stats' already exists
Look at your database and look at the stat table and the site settings table and make sure they exist and have the corect structure. Maybe those weren't created correctly or have the wrong data in them. There should be some creating tables readme's in the /docs folder that came with eFiction 3.0 download. Try those.
settingstable.txt maybe.
Sorry, I don't really know much more than that. You'll have to wait for someone more knowledgable to help you if this doesn't work.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
You still have your preferences to use the old skin. The upgrade does not change that, for some reason, even though the skins aren't compatible. Delete the old skins from the skins folder and when you log in, you will be taken to the default skin, which isn't very pretty but still allows your site to function so you can change it.
You might also want to run some queries in your database to change users using the 1.1 skins to a 3.0 skin.
The tables are there, and the info seems to be ok too!!
I deleted the old skin folder! Now the script loads only the CSSZEN skin. But still, when I try to login I get the "Are you ready to update? Yes or No" and the errors. When I was looking at the fanfiction_settings table, I saw the field "version" and it says "3.1.1" there, although I uploaded the 3.2.1 files. I just seems weird, could this be the update problem here? 😕
You might also want to run some queries in your database to change users using the 1.1 skins to a 3.0 skin.
Sorry, I only know very basic stuff, could you tell me how I can do that? Is this really necessary? 😕
Thanks for the help!!
Use PHPMyAdmin to set the version to 3.2.1
It worked. Thank you!!
