Multiple Listings

Does it appear in fanfiction_stories five separate times?  I'm not sure if it's possible, but that could explain it if it does, because it would have the same sid, so deleting one of the multiples through the admin links is telling it to delete by the sid, which would be all five copies.

Am I making any sense?  It's early.

If that's the case you should be able to delete four of the five entries in PHPmyAdmin.

Thanks Lydsie, I have tried to delete via the tables, but as far as i can tell, there is only one entry for that particular sid. it is listed once and all seems to be in order. it just shows up mulitple times in the authors listings.

I have aslo found that this is happening with at least one other story too, another co-authored. Each has only one listing in the database, but multiple on the authors pages.
another example can be found here:
http://www.pretendercentre.com/missingpieces/viewuser.php?uid=8

two listings by the grace of god

I have tried the usual suspects such as recaclutate stats, optimise tables etc... just in case, but no go

it is not actually causing problems beyond aesethics at the moemtn, as all the reveiws end up in the right place, and the story is complete so there is no more updating to be done, it is puzzling though..

ps. dont know how this thread managed to get above the sticky ones

It's odd that it seems to be always appearing the same number of times as there are coauthors.  My last guess for it being in the database would be to look in fanfiction_coauthors and see if there are any duplicates in there.  If not, then it's probably in stories.php.  I would check over any mods you've made there.

Hmm it is quite bizzare, i think (but am not 100% certain) this happened after the upgrade to 3.4.3... maybe. I can't recall the duplicate problem before, but that does not necessarliy mean it wasnt there.

The co-author tables are fine, everyhting seems to be as it should be, no duplicates anywhere (only have a few co-authored stories on the site so easy to keep track of.

As for the stories.php, i do not think i have touched that file.

it is a strange thing, and i cant find any duplicates in the database anywhere to account for it

Well, since you don't think you modded it, there's little chance of screwing anything up if you overwrite stories.php.  If you've got a copy of the original 3.4.3 files I'd re-upload stories.php from there and see what happens (after backing up what you've got, on the off chance there is a mod you forgot about).  Since it's not in the database, it must mean that something's telling it to display it that way, and the skin files don't seem as likely a culprit on this one.

I'm curious as to what the author/coauthors might see if they looked in "manage stories" in their account info.  Do duplicates appear there as well, or only when viewing profiles?

Hi Lyndsie,
replaced stories.php, no change (i checked it too, and no mods at all on that file. i usually keep a record of file changes i make for upgrades and couldnt find anything in relation to stories.php)  And in mannage stories, there are also multiple listings (but only for some of the co-authored... i think it depends on who is primary author)

this is my manage stories:
Aftermath 
At What Price?      co-author:uploaded by me as first listed author
At What Price?      co-author:uploaded by me as first listed author
Broots Outlived Them All 
By The Grace Of God      co-author:uploaded by me as first listed author
By The Grace Of God        co-author:uploaded by me as first listed author
Eight 
Entropy 
Here Be Dragons            co-author:uploaded by another as first listed author, no duplicate for me but 2 duplicates for primary author
It Ends Now
Nothing Means Something    co-author:uploaded by another as first listed author, no duplicate for me, but 5 duplicates for primary author
Once 
Once.... Again
Redemption - The Beginning      co-author:uploaded by me as first listed author
Redemption - The Beginning        co-author:uploaded by me as first listed author
Reflections 
Sleepyhead
Timmy

It appears that it is only duplicated in the primary authors account, and equal to the numbers of co-authors. I am reasonably sure this was not an issue with 3.3.1, so i am thinking it might have occured during the upgrade.
the duplicates do not seem to interfere with reveiw counts or read counts, everythign is perfectly duplicated, but the mystery of how to fix it is driving me bug, and it seems to be skin independent too.

Hmmm.  I don't know what it could be, but I'll keep my mind on it as I'm poking around.  I looked at my test site which is currently on 3.5 and none of the coauthors are duplicated like that.  I wonder if it might have to do with your version of PHP or MySQL.