URL to your eFiction: http://nanashifics.com
Version of eFiction: 3.5
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.8
Version of MySQL: 4.1.22
Have you searched for your problem: Yes
If so, what terms did you try: add story, MySQL
State the nature of your problem: When I try to add a new story with multiple authors I keep getting the following message error:
A fatal MySQL error was encountered.
Query: SELECT PENNAMEFIELD AS penname FROM DBPREFIXfanfiction_coauthors AS c WHERE sid = '89' LEFT JOIN nanashifanfiction_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 nanashifanfiction_authors as author AS a ON a.UIDFIELD = c.uid' at line 1
The story will add with a single author only and I can then, edit the story to add the co-authors. It just comes up when initially adding the story with co-authors.
Do you have a test account for us? no
This particular problem only started after I upgraded to v. 3.5.1. I was having a completely different problem with the subcatagories dissappearing. Since I couldn't figure that one out, I reverted to 3.5 and uploaded my database backup to MySQL. That's when the story add started giving this message. I was just trying to revert everything so I could try a fresh update to see if the other problem would get fixed. Single author stories add just fine.
When I try upolading the backup of MySQL I keep getting this message:
SQL query:
# Dump of nanashifanfiction_authorfields
# Dump DATE : 04-Oct-2009
INSERT INTO nanashifanfiction_authorfields
VALUES (
"1", "4", "lj", "Live Journal", " http://{info}.livejournal.com", "", "", "1"
)
Thank you in advance for any help you can give me.
Upgrade.
As Tammy said, upgrade to the latest version (3.5.1). That should solve the issue you mentioned with the MySQL message you copied in.
For the disappearing subcategories, that fix can be found in the SVN (see here for info: https://efiction.org/wiki/index.php5?title=SVN). You need the most recent includes/categorylist.php. ( http://efiction.svn.sourceforge.net/viewvc/efiction/includes/)
As for the SQL you posted from the database backup process, it doesn't look like that's saying anything failed, but I'm not a MySQL expert.
That did fix those problems, but it's still being a bit squiffy. Characters aren't showing up after a subcatagory is chosen unless you hit preview. Is there a way to fix that or is it a problem with IE8?
I can deal with this little glitch at this point in time since no one else actually adds stories to my site but me, though I would like to try to fix it in the event that I do get an active user.
If it's related to the same thing as the disappearing categories, then it most likely wouldn't happen in Firefox or in IE7. I think the problem cropped up in IE8 and Chrome (and maybe Safari?). I think the SVN also has an updated includes/characterlist.php which might fix the issue.
Thank you! That also worked!
Thank you all for everything!
