Hi :-).
URL to your eFiction: http://www.cafeotaku.org/fanfiction
Version of eFiction: 2.0
Version of PHP: Not sure, sorry.
Version of MySQL: Not sure either.
Have you searched for your problem: Yes
If so, what terms did you try: fatal MySQL error, error step 11. All under 3.0 upgrade support.
Have you looked at the FAQs: Couldn't find a FAQ.
State the nature of your problem:
I was upgrading from version 2.0 to the most recent and everything was going fine, I believe x'D. When I reached step 11 I got the following error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/.paprika/cafeotak/cafeotaku.org/fanfiction/install/upgrade20.php on line 388
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.paprika/cafeotak/cafeotaku.org/fanfiction/includes/dbfunctions.php on line 23
A fatal MySQL error was encountered.
Query: ALTER TABLE fanficfanfiction_stories drop `gid`, drop `wid`;
Error: (1091) Can't DROP 'gid'; check that column/key exists
x__X I don't know what that means, but I guess it can't be good. Well, after that I couldn't do anything to continue upgrading so I went to the front page and everything looked fine, but when I tried to log-in I couldn't. I got a new password sent to my mail and tried to log-in again but nothing.
Should I restore my database and start again? I'm really clueless when it comes to things like this. Any help will be appreaciated.
Thank you in advance!
Put the install folder back up. There's 18 steps to the upgrade. You're barely through half. I can't attempt to figure it out without the install folder in place.
Put the install folder back up. There's 18 steps to the upgrade. You're barely through half. I can't attempt to figure it out without the install folder in place.
x__x Sorry. The folder it's up again.
Okay, I'm going to need you to do something for me. Open up the install/upgrade20.php file in a text editor, and add this line:
@ error_reporting(E_ALL);
directly above this line:
function isNumber($num) {
It should be line 22. When you've done that let me know.
For some reason the script doesn't seem to be able to read your stories table to make some necessary changes. This will turn on some extra error output that should tell us what the exact problem is.
Ok, it's done 🙂
Thank you so much for taking the time to help me out ;__;.
Hmm..that still didn't give me what I need. Do you know how to use phpMyAdmin? Or at least know how to access it on your site?
Hmm..that still didn't give me what I need. Do you know how to use phpMyAdmin? Or at least know how to access it on your site?
Yes, I have access to phpMyAdmin and I've used it before to do simple tasks.
Okay. Go into phpmyadmin and select one of the "SQL" tabs. Doesn't matter which one. Put this in the query box:
SELECT sid, gid, wid, charid, rid FROM PREFIXanfiction_stories LIMIT 0, 200
Replace PREFIX with your table prefix if you have one. If I'm right, that should be the query that is throwing the first real error. Paste the error that it displays.
I got this:
Error
consulta SQL:
SELECT sid, gid, wid, charid, rid
FROM fanficfanfiction_stories
LIMIT 0 , 200
MySQL ha dicho:
#1054 - Unknown column 'gid' in 'field list'
Okay totally confused now. gid is one of the default columns in 1.1 and 2.0. Is your site very heavily modified or something? List for me the columns you have in your fanfiction_stories table. We may have to do some temporary additions to get you through this step.
The columns on that table are:
sid, tittle, summary, storynotes, catid, classes, charid, rid, date, updated, uid, coauthors, featured, validated, completed, rr, wordcount, reviews, count, rating, challenges.
Is your site very heavily modified or something?
Not that I know. Maybe I did something wrong in the past but didn't have problems until now? This is so weird 😳
Okay. Woo! Looks like we may have been worrying for nothing. You must have hit the back button or something. It looks like step 11 completed successfully and you somehow went back to it. I was worried there for a second because your default skin doesn't seem to show warnings, genres, etc in the listbox. But going to the default_tpls skin does show that the data is there. So I'd just go ahead to step 12 and finish the upgrade.
http://www.cafeotaku.org/fanfiction/install/upgrade20.php?step=12
You can take this out of the upgrade to get rid of the Notice warnings.
@ error_reporting(E_ALL);
Just reverse what we did there.
Thank you so much for all the help and patience, you're awesome. I'm just... so sorry for being such a nuisance :oops:.
I feel so embarrassed right now but I have yet another error. When I go to the Series page I get the following lines at the top of the page:
Warning: implode() [function.implode]: Bad arguments. in /home/.paprika/cafeotak/cafeotaku.org/fanfiction/includes/corefunctions.php on line 449
Warning: implode() [function.implode]: Bad arguments. in /home/.paprika/cafeotak/cafeotaku.org/fanfiction/includes/corefunctions.php on line 449
Could you please help me with that? And thank you so much again.
The series Hikari Amai has a missing category. The category may have been deleted or bad info got in there somehow at some point. Just edit the series to clear the bad data. I scrolled quickly through the list, but didn't see any others that had that error.
Ok, I'll check on that series. Thank you, Tammy, you're the best :-D.
I'll try to not cause you any more problems in the future :oops:.
