URL to your eFiction:: http://writing.morbid-romantic.net/
Version of eFiction: 3.5
Have you bridged eFiction, if so with what?: No
Version of PHP: 5.2
Version of MySQL: 5
Have you searched for your problem: Yes
If so, what terms did you try: I've searched "array text" "array" "Query: SELECT count(author.uid) FROM fanfiction_authors as author LEFT JOIN" "Error (1054)" "Error: (1054) Unknown column 'ap.stories' in 'where clause'" and "Error: (1054) Unknown column 'stories' in 'field list'"
State the nature of your problem: I have a few errors, so I will post them all here... These errors didn't pop up until after I upgraded to the newest version.
When you click the Authors page ( http://writing.morbid-romantic.net/authors.php?list=authors), you get this error:
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'
When you click on an Authors name from a story ( http://writing.morbid-romantic.net/viewuser.php?uid=1), you get this error:
A fatal MySQL error was encountered.
Query: SELECT stories FROM fanfiction_authorprefs WHERE uid = '1'
Error: (1054) Unknown column 'stories' in 'field list'
I also have a problem with stories that are part of a series. When I go to view a chapter of a story in a series, instead of the story text being there, there's only the word 'Array.' Everything else shows up fine. Since there's no error to paste, I'll copy and paste a small screen shot:
See how everything shows up fine but the actual story itself?
It began with an error in the storyend module. I fixed the error by removing the _ between strip slashes (.strip_slashes) on line 64. After making this change and refreshing the page, it displayed fine, save what is happening above.
Should I make a test account?
I'm not seeing these errors that you're having. Is debug turned on? If so, turn it off.
I totally don't make a big stink about this normally, but did you make a huge deal about copyright on your essays and then remove all my credit links from my skins? I hope I'm just being blind this morning (haven't had my caffeine) because that would be ridiculous. My skins are "Creative Commons Attribution-Noncommercial 3.0 License" which means even if you edit them, the credit needs to stay where I put it.
Skins made by Kali are no longer supported!
