URL to your eFiction: http://www.brangelinaforever.com/EAFanFictions/
Version of eFiction:2.0.7
Have you bridged eFiction, if so with what?:no
Version of PHP: 4.4.7
Version of MySQL: 4.1.22-standard-log
Have you searched for your problem: (yes/no) yes
If so, what terms did you try: installing problems
State the nature of your problem: _FATALERRORQuery: SELECT password,penname,uid,userskin,level,email,categories, ageconsent FROM fanfiction_authors WHERE penname='blumystique'
Error: (1054) Unknown column 'userskin' in 'field list'
Do you have a test account for us?no
ok So I wanted to update to version 3.3. and I had copied my folder and made a new to as a test page. Each time I started the installing it kept giving me mySQL errors and I decided that I was going to ust forget the whole and and deleted the pages folders and went back to 2.0.7
The site is back up except no one can log in or click on anyone's profile
_FATALERRORQuery: SELECT password,penname,uid,userskin,level,email,categories, ageconsent FROM fanfiction_authors WHERE penname='blumystique'
Error: (1054) Unknown column 'userskin' in 'field list'
I also get this when I try to click on the Category Section
A fatal MySQL error was encountered.
Query: SELECT genre,gid FROM fanfiction_genres ORDER BY genre
Error: (1146) Table 'brangeli_ipb.fanfiction_genres' doesn't exist
this is what i get when i try clicking on someone's profile
A fatal MySQL error was encountered.
Query: SELECT count(uid) FROM fanfiction_favstor WHERE uid = '74'
Error: (1146) Table 'brangeli_ipb.fanfiction_favstor' doesn't exist
so what did I do wrong? I did backup my database and files but I just want for myself as well as the other reader to be able to log in read and post their stories.
So, if I follow, you tried upgrading from 2.0.7 to 3.3 and it failed. Then, you deleted some folders or the 3.0 files to try to restore it back to 2.0? Those MySQL errors are looking for tables that exist in 2.0. but not in 3.0, so it looks like you did not restore the 2.0 databases. So what that means is that you have 2.0 files and 3.0 database structure at your site.
i think so. im not sure. i just want my site back up and running properly. i want to upgrade to the 3.3 but i have no clue what i'm doing short of just uninstalling everything and reinstalling the whole thing.
ok So I wanted to update to version 3.3. and I had copied my folder and made a new to as a test page. Each time I started the installing it kept giving me mySQL errors and I decided that I was going to ust forget the whole and and deleted the pages folders and went back to 2.0.7
Well if you can't view any stories, and you don't have the 2.0.7 database backed up, you're probably going to have to go along with upgrading it to 3.3. But I can see your stories:
http://www.brangelinaforever.com/EAFanFictions/viewstory.php?sid=125&chapter=1
it's just that other pages aren't working.
Upload all of the 3.3 files once again, and post the first error msgs you get.
How far in the upgrading process did you get?
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
i did that before and aftewards i couldnt access any of the files because it couldnt connect to the database at all. I never did get far in the upgrading because i would got to as far as having my files 2.0 files being automatically removed and then i got an error about the mysql couldn't connect.
no whenever i try to go the upgrade the 3.3 back up it doesnt even ask for me to put my database user name and address it just takes me straight to the set up of the table prefix and then when i click on automatic i can an error that says function mysql error cannot connect to the database.
I never did get far in the upgrading because i would got to as far as having my files 2.0 files being automatically removed and then i got an error about the mysql couldn't connect.
I'm pretty sure that that is the end pf the upgrade. If I remember correctly, deleting the old 2.0 files is last.
There probably was a mysql error because of the sitekey problem: for some reason it doesn't save the sitekey in one place in your database when you upgrade/install 3.3. If you just put the right sitekey there, the error goes away.
What you do is you copy the site key info from the database table fanfiction_settings and paste it into the database table fanfiction_stats for the sitekey. It will otherwise say SITEKEY.
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
at this point i have absolutely no idea what i'm doing. i cant find that particular folder to get the sitekey. which folder exactly will be it in
It's not a file, it's in the database. Usually people access their database using phpmyadmin. Some access phpmyadmin through their server's control panel.
You need to look at (browse) the tables:
fanfiction_settings
fanfiction_stats
The SITEKEY listed in fanfiction_stats has to be changed to whatever it's listed in the settings table.
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
ok i did that. i realized what i did wrong in the upgrading. i had the upgrade going to the wrong database. since i have 3 database on my server. man i feel like such a duck
k this is what i get from phpmyadmin in both folders
SELECT COUNT(*) AS `Rows`, `sitekey` FROM `fanfiction_settings` GROUP BY `sitekey` ORDER BY `sitekey`
Browse the tables.
When you first look at a table, it lists the structure with the defaults. You have to actually browse the table to see what yours really contains. There should be a tab that says Browse.
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
I did they both have the same sitekey 3G6Ah38Gb9
Then that's not the problem.
Paste the errors you are getting.
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
i get this message when I try to run the upgrade
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dbuser'@'localhost' (using password: YES) in /home/brangeli/public_html/eFiction33/includes/mysql_functions.php on line 8
A fatal MySQL error was encountered.
ERROR: Failed to connect to the database!
Did you overwrite config.php, or is your database username actually dbuser?
If it's not that:
Since you said you were trying to connect to the wrong database originally, are you sure that you have the correct username and password for the database you changed to? (It sounds simple, but I've done stuff like that before when I'm not paying attention.)
Also, with some hosts, you have to include the server name. For example, if your server name is 'fiction', you might have to enter fiction_dbuser (where dbuser is your database name) as the username. (Another thing I sometimes forget.)
