my site is http://skyhighfic.hostei.com/stories.php?action=newstory
Whenever someone tries to upload a story, in the "characters" option, the only item on the list is "none", even though I've added several characters to that category.
Also, when I click on a category, it won't let me select one of the subcategories to make that story a part of that subcategory.
Also, in the classification section of the "Add Story" thing, it gives me a box/frame/whatever you wanna call it for each one.. is there a way to make a box/frame containing all the classifications (drama, romance, etc) so that then the author can choose?
Thank you for your help, I tried looking for an answer here at the forums but found none
also, not sure what I should do when I got this problem:
A fatal MySQL error was encountered.
Query: SELECT PENNAMEFIELD AS penname FROM DBPREFIXfanfiction_coauthors AS c WHERE sid = '1' LEFT JOIN fanfiction_authors as author AS a ON a.UIDFIELD = c.uid
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN fanfiction_authors as author AS a ON a.UIDFIELD = c.uid' at line 1
Help? 😕 😛
Your hosting company is inserting a broken javascript in your pages which is in turn breaking the rest of the javascript on the page. Also you may not have all the files uploaded. The fatal query in the second message looks like the queries.php file is missing, but I can't see how anything in the site would be working if that were the case. Where exactly did you see that error?
The error appeared right after I tried a "test run" for uploading storieWhen I clicked submit story that's what appeared. The weird thing is that the story WAS actually uploaded, so I don't get why thats happening. Any suggestions about what to do with the javascript thing?
Are you using version 3.5 of the script? That looks like a bug where a query has DBPREFIX instead of TABLEPREFIX that existed in 3.5. If that's the case, you should upgrade to 3.5.2 (the current version). If I remember correctly, there were also some problems with the category/character selections in certain browsers in that version as well.
(PS. If you fill out the Support Request Template like you're meant to, we'll have info like that up front to be better able to help you.)
Lyndsie's right. I didn't notice that in the error. You need to update to the most current version. Your site is currenty down. Looks like your database (or parts of it) is missing.
