URL to your eFiction: http://www.limit-break.org/library/library
Version of eFiction: 3.4.3
Have you bridged eFiction, if so with what? No
Version of PHP: 4.4.4
Version of MySQL: 4.1.20
Have you searched for your problem: Yes
If so, what terms did you try: empty, stories disappearing
State the nature of your problem: After upgrading to 3.5, errors emerge when i attempt to access categories
Do you have a test account for us? No
Whenever we clicked "add story" we were taken to a 404 error. I researched here and figured out that I needed to upgrade to the newest version. I did so, but now when I click on categories and stories, i receive this error:
A fatal MySQL error was encountered.
Query: SELECT author.penname as penname, co.uid FROM fanfiction_coauthors AS co LEFT JOIN fanfiction_authors as author ON co.uid = author.uid WHERE co.sid = '13'
Error: (1146) Table 'tayeko_library.fanfiction_coauthors' doesn't exist
I have no idea how to fix this, and no searches I do help. I backed up my database before upgrading, but when I restore the database, it doesn't seem to help. I also downloaded the Stories folder to my computer for backup before I upgraded, this didn't help either.
Any help would REALLY be appreciated, I'm in the middle of a fic contest and it would be devastating to lose members work before the close of it.
Also, upgrading did not solve the oringial 404 error that we recieve when adding or modifying a story... so I made my problems double, essentially.
Thanks
This is a very common problem with eFiction 3.5. See this thread: https://efiction.org/forums/index.php?topic=6674 It's the most cohesive. There are other threads that discuss it if you browse the most recent ones, but I haven't seen a good solution.
For the 404, I'd check that everything's chmoded properly, maybe?
Was looking for an old post I'd made on something and I found this again. I definitely skipped over the last part of the error message because I was so used to seeing the first part (it was Christmas Eve and I was in a rush, sorry!). What that's telling you is that your fanfiction_coauthors table doesn't exist; it wasn't created by the upgrade script. If you look in the file update.php, you'll see the structure for the table and can create it in PHPMyAdmin (which most hosts have). I think it may also be in the tables.sql file in the docs folder, but I think that's actually missing a couple of changes to tables last I looked, so be wary.
What you should do is look over the update.php file and make sure that all the changes it specifies have actually been made to your database. It failed to do a couple for me when I upgraded my test site from 3.3.1 to 3.5.
