[solved] Multiple s...
 
Notifications
Clear all

[solved] Multiple submissions number incorrect

3 Posts
2 Users
0 Reactions
1,043 Views
(@inthemoonlight)
Posts: 76
Trusted Member
Topic starter
 

My Site: www.inthemoonlightfiction.com
eFiction: v3.4.1
PHP: 5.2.4
MySQL: 5.0.27-standard
Mods: Challenges, Submit Time and Word Count
Have you searched and if so what terms?: extra submission

This problem hasn't occurred before and I think it may be related to the submittime mod I just installed (which works!).  The problem is it says that there is 1 more submission in the queue than there is.  So there are none right now and it still says there is 1 (when I tested the mod it said I had 2 and there was only 1).  I was looking at the recalc functions but those tend to be already existing/validated submissions or so I would assume.  I may go look around PHPMyAdmin to see if I can see anything.


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

 
Posted : 31/03/2008 8:43 pm
(@marauder-by-midnight)
Posts: 56
Trusted Member
 

The way you can find how many stories are in queue according to your phpmyadmin would be:

1. Go to fanfiction_chapters

2. Go to "Search"

3. Search for

validated = 0

There may be a story that was never "deleted". I had quite a few left-over stories in my queue too.


 
Posted : 31/03/2008 8:48 pm
(@inthemoonlight)
Posts: 76
Trusted Member
Topic starter
 

ok.  so...um.. i do that and it tells me:

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0006 sec)

Then i went into fanfiction_chapters and looked through and found the one that hadn't been validated and it was empty. So I delieted it and everything is fine now.  Thanks so much!


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

 
Posted : 31/03/2008 9:00 pm
Share: