URL to your eFiction: http://writ.sansdreamscape.net/index.php
Version of eFiction: was 3.3.1, trying to upgrade to 3.5
Have you bridged eFiction, if so with what?: No bridging
Version of PHP: 4.4.9
Version of MySQL: 5.0.51a-community
Have you searched for your problem: Yes, it appears the upgrade script didn't run all the needed queries
If so, what terms did you try: used the error codes received.
State the nature of your problem: Upgrade didn't 'take'
Do you have a test account for us? No, but one can be made
A fatal MySQL error was encountered.
Query: SELECT author.penname as penname, co.uid FROM writ_fanfiction_coauthors AS co LEFT JOIN -prefix-_fanfiction_authors as author ON co.uid = author.uid WHERE co.sid = '43'
Error: (1146) Table '-edited for security-.-prefix-_fanfiction_coauthors' doesn't exist
I took a look at the upgrade script and it looks like a lot of db queries weren't executed. I pulled this from the downlaods for the newly released 3.5 version. In the searches I did, there were some issues with this happens a few version prior where there was an issue with the install script.
Can the download be verified that there's not an error with running it
Also, if that's the case, it looks like I have to run these all manually, which I'm not opposed to doing, I just want to be sure nothing else gets skipped- it doesn't appear to be, but I could easily missed something.
As an update and as can be seen if you go to my efic install..I got the errors resolved [thus far it appears that way]. I had to make another php file, name it update.php and run it to ensure the db queries that didn't run initially ran.
My original question remains if there is an error with the update.php in the 3.5 version of the download package, because I have two other efic installs that I want to upgrade. While I make a backup of the installations and their databases to rollback easily, I want to hold off and make sure I got the install at writ.sansdreamscape.net upgraded properly.
I noticed that even the _fanfiction_modules table wasn't created from a previous update prior to 3.5
It's not in the update. I think you need to disable your blocks or switch your skin to one where the blocks are only on the index page. It looks like one of the updated blocks is trying to run before the update has taken place.
Thanks Tammy, I'll give that a try on a test site and see how that turns out. 😀
