Fatal MySQL error w...
 
Notifications
Clear all

Fatal MySQL error when adding new chapter

3 Posts
2 Users
0 Reactions
1,204 Views
(@tothejourney)
Posts: 46
Eminent Member
Topic starter
 

My Site: In The Moonlight
eFiction: v3.4.3
PHP: 5.2.4
MySQL: 5.0.27-standard
Mods: Challenges, Submit Time and Word Count

I received an email from one of my memebers and they get the following error when they try to add a new chapter to their story:

*A fatal MySQL error was encountered.
*Query: SELECT uid FROM efiction_coauthors WHERE sid = '35'
Error: (1146) Table 'inthemoo_fiction.efiction_coauthors' doesn't exist

I've looked around but it nothing I've found seems to solve the problem.  The odd thing is I am pretty sure this author isn't trying to update a co-authored story.


My Site: To The Journey
eFiction: v3.4.3
PHP: 5.2.6
MySQL: 5.0.45-community
Mods: Challenges, Submit Time and Word Count

 
Posted : 15/09/2008 2:11 pm
(@tammy)
Posts: 2577
Member Moderator
 

You sure that's the only changes you've made?  Somewhere the where it should read PREFIXfanfiction_coauthors it's reading efiction_coauthors instead.  My files don't show that anywhere though.


 
Posted : 20/09/2008 1:27 am
(@tothejourney)
Posts: 46
Eminent Member
Topic starter
 

So I've looked at my database and all of the tables say "efictionfanfiction_"  But the other efic site I have doesn't.  It has the correct table prefix.  I was not aware that it had done that.  But it appears that the stories are alright (aside from the not being able to update).


My Site: To The Journey
eFiction: v3.4.3
PHP: 5.2.6
MySQL: 5.0.45-community
Mods: Challenges, Submit Time and Word Count

 
Posted : 21/09/2008 1:08 am
Share: