URL to your eFiction: http://inuyasha-fanfiction.com
Version of eFiction: 3.5.1
Have you bridged eFiction, if so with what?: No
Version of PHP: PHP Version 5.2.5
Version of MySQL: 5.0.67-community
Have you searched for your problem: yes
If so, what terms did you try: fanfiction_authorprefs , error 1054 ,
State the nature of your problem: I have listed them below.
Do you have a test account for us? Yes, but I would like to know who I can PM the information. I need to know if you need admin capabilities. One of my co-mods volunteered her account to be used as a test. She only manages to ftp and update the main page for our Caption of the Week and has a few fanfictions posted, but she said she has all of them saved so it is okay to use it.
Okay, first I decided to upgrade from 3.4 to 3.5.1. Then after I got all the errors below, I tried to go back and downgrade...so I just said what the hell and put it back to 3.5.1. I went through the forms and did what was said. I am just very close to the project and my other 5 mods have no php or script experience.
If I go to http://www.inuyasha-fanfiction.com/admin.php?action=members
A fatal MySQL error was encountered.
Query: SELECT author.penname as penname, author.uid as uid, ap.stories FROM fanfiction_authors as author LEFT JOIN fanfiction_authorprefs AS ap ON author.uid = ap.uid GROUP BY author.uid ORDER BY author.penname LIMIT 0,25
Error: (1054) Unknown column 'ap.stories' in 'field list'
http://www.inuyasha-fanfiction.com/authors.php?list=authors
A fatal MySQL error was encountered.
Query: SELECT count(author.uid) FROM fanfiction_authors as author LEFT JOIN fanfiction_authorprefs as ap ON author.uid = ap.uid WHERE ap.stories > 0
Error: (1054) Unknown column 'ap.stories' in 'where clause'
http://www.inuyasha-fanfiction.com/admin.php?action=maintenance&maint=stories
A fatal MySQL error was encountered.
Query: UPDATE fanfiction_authorprefs SET stories = '32' WHERE uid = '1' LIMIT 1
Error: (1054) Unknown column 'stories' in 'field list'
If you click on a user to view profile
Example: http://www.inuyasha-fanfiction.com/viewuser.php?uid=607
A fatal MySQL error was encountered.
Query: SELECT stories FROM fanfiction_authorprefs WHERE uid = '607'
Error: (1054) Unknown column 'stories' in 'field list'
I have gone through some of the forum message here on the subjects and done things like replacing stuff or creating things, but after a while and being tired, it all tends to end up like goo. Please help!!! I am desperate!
By the way, if you would be able to make sense of this mess, I will pop some money over through donations. I really need this badly and right now my eyes are hurting and being dyslexic is not fun at all when you are tired. Nothing seems to look right or read right. *sighs* Thank you!
There are two things that you should do right off the bat, and one is easier than the other. #1 is to reupload all of the files for 3.5.1 to make sure you've got all the right versions. Since you upgraded and downgraded and then upgraded again, I'd do it just to be sure.
The second thing revolves around this question: when you attempted to go back down a version, did you upload a database backup? What it looks like to me is that you've got 3.5.1 files, but a 3.4.x database. Particularly for that 3rd message you've posted; the stories field was something that was added to the authorprefs table sometimes between 3.4 and 3.5. When I upgraded my site, it failed to add it and make some other changes. I had to look through the script in update.php basically line by line (starting after the changes for 3.4.3, which is what version my site was at) and make sure that all the changes in there had actually been made to the database. There were three or four (maybe more, I don't remember) that hadn't been done.
So, when you look in the admin control panel, what version does it say your site is at? This will tell you if the script partly ran or not. If it says 3.4.x, then you're probably safe running update.php again, under Admin > Archive Maintenance > Run Update, especially if you uploaded a database backup at some point. If it says 3.5.1, it might not let you run the update, or the update will fail if parts of it have been done. So in that case you can either a) upload a backup, if you've got a recent one, and then run update.php or b) go through update.php and make the changes manually.
Hi Lyndsie!
Seems for the most part, the manual inputting of the sql worked. Sleep and fresh eyes, plus some helpful direction does do work. Now, I believe I remember seeing something about the images feature which I had issues with. I hope that will also work.
I know it is not much, but I clicked the efiction donation and sent $10 for now. I do however believe this would be a great suggestion to mention... as a blogger, that a separate 'blog' would do wonders on topics such as this. The forum is great, but the more places for references, I believe, the merrier as this is practically the ONLY place even googling gives this type of support. I develop scripts myself and I understand the time and such into it.
Thank you to the creators of efiction.
I do have a challenge though:
Perhaps a "bridge" for WordPress? A guy I know who does plugins did a chapter type one, but because of WordPress's now flexibility in versions 2.7 and above, and the fact it can be used as a CMS... perhaps some of the hooks on efiction and WordPress can be either done for a bridge OR an actual plugin. wp efic??? Sounds like something that can raise efiction even higher.
Again thanks and I will definitely come again if I need help, especially on nights like I had last night....lol
I think what might be pretty simple would be to make a widget or something for Wordpress that could show most recently updated stories and the like. Actually, I know there is at least one already for RSS feeds, and the Most Recent stories is what generates the RSS feed for eFiction sites, so that could already be done quite easily. (Just pop in the location of the feed to the widget.)
Also, you may want to take a look at this thread because I think your site is a candidate.
And did you know? There's a wiki, which covers a lot of general basic stuff. It's efiction.org/wiki, or click above. : )
