Error: (1054)s all ...
 
Notifications
Clear all

Error: (1054)s all over

3 Posts
3 Users
0 Reactions
2,448 Views
(@guest2547)
Posts: 0
 

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?


 
Posted : 13/11/2008 1:10 am
(@becca)
Posts: 553
Honorable Member
 

I'm not seeing these errors that you're having. Is debug turned on? If so, turn it off.


 
Posted : 17/11/2008 9:35 am
 kali
(@kali)
Posts: 307
Reputable Member
 

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!

 
Posted : 17/11/2008 10:09 am
Share: