Ugh I wanted to reply to my other topic, but I guess I deleted it (it was the one about http://backstreetheaven.com )
I wanted to post that I think the previous error is fixed, but now when I click "authors" I see:
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'
I also tried to check the update.php file to see which part that is about (cause I "fixed" the other error by inserting the coauther tables manually), but I have no idea which part in the update file I would need for this.
Ok I got that above fixed aswell, only the thing is there are no "no authors" meaning sure people have stories and if you click someone's name it'll show there stories, but no one will show up as an auther and everyone has [0] behind there names, anyone know why that could be?
Please let me know if you require to fill in the support template again, which got lost (check the first post), to be able to help
How did you fix the problem in your first post here? Someone else posted that they had the same problem, and they might still need a solution: https://efiction.org/forums/index.php?topic=6725
Everyone has what behind their names? A space and a degree sign, or was it something else that got changed in the post? Nothing looks bad when I check your site.
I think something to changed there, I think it was meant to show zero. There's one person who posted a new story after the update, she has 1 behind her name now, meaning she has one story, all the other people have zero behind there names even if they do have stories... and I noticed other things today, not sure what exactly I think ratings, where it looked as if the counting had been "reset" though the data itself isn't lost
As for the othe rthing... I manually inserted one of the sql things from the update file, not sure which one, could've been this one:
CREATE TABLE `".TABLEPREFIX."fanfiction_coauthors` (
`sid` int(11) NOT NULL default '0',
`uid` int(11) NOT NULL default '0',
PRIMARY KEY (`sid`,`uid`)
) TYPE=MyISAM;
I think I also had her author error later which I also fixed with manually inserting one of those sql commands, but I'm not sure which one that was either
So I wondered why no one was updating, now I found out I got ANOTHER error after updating, when people try to update they get
A fatal MySQL error was encountered. Query: SELECT PENNAMEFIELD AS penname FROM ors AS c WHERE sid = '26' LEFT JOIN fanfictio
Probably something behind it, but that's all the person told me...
I'm really annoyed be this wishing I never updated 🙁
this error clearly has to do with the above thing, cause seh's not listed as an author anymore (nor is ANYONE who had a story before the upgrade)...
*Well I put some of the files back to the pre-upgrade files, everyone i s listed as an author again now (though on the main page it only lists the number of authors as 1, being one who registered and posted after I tried to upgrade), I will reply if I know if it fixed the problem, but since more people got errors like this after upgrading it might be nice to ahve a look into it...
woops, quoted instead of edited
You don't have the support information here so I'm not really sure what version you upgraded from and all that, but it looks like the upgrade script didn't make the modifications it was meant to. This happened to me as well and caused some story count issues and a few other errors. Look in update.php to see what other changes you might need to verify or do manually.
That error might be the stories.php issue that was discussed here: https://efiction.org/forums/index.php?topic=6674
