[SOLVED] Multiple Character listings

Did you add the same characters to different categories in your older version? If you have an Alex for category one and an Alex for category 2, the Browse will now list both. All the number IDs for the characters seem to be different. On the Most Recent, it lists the same character twice, with the same ID number for both...

http://www.pretendercentre.com/missing/eFiction1.1/browse.php?type=recent

Did you have any probles when you were upgrading? Did you perhaps run the characters part more than once?

no the upgrade went in beautifully, all green ticks, and i did everythign automatically because i am not confident enough to do the manual. I pretty much just hit continue when prompted.

I cannot remember if we did that last time or not, i think we had some problems with duplicates as well and so entered a site wide one, i was not in charge of that though and the person who helped has long since jumped ship, my job was the skin...lol

Any idea on how to fix this ??? Thanks
jacci

I think what you had was characters in each category and not sitewide characters.  Unfortunately I can't see a way around deleting them one by one..which will probably delete the characters from a lot of stories. 

Yeah Tammy i think you are right, i deleted all the characters in the mysql table and then will just have to edit the stories as we go (all 2055 of them  😥 which are now characterless) but that is not a critical issue, we have them set up now as sitewide only and that is working nicely  😀

thanks for all help

You should have exported your story info table from the database, and then used a find and replace to replace the character ID numbers to the ones you wanted to use... at least for the categories with the most stories.

Ohh okay thanks

i didnt know you could do that, my knowledge of mysql databases is very limited and I am not at all confident messing around in there. Am learning though, usually the hard way (is there any other) and am making some slow progress.

All these disasters do offer (force) me to learn smt knew each time, so it is live and learn, which is a good thing in the long run.

thanks for all of your responses and help

jacci

You should have exported your story info table from the database, and then used a find and replace to replace the character ID numbers to the ones you wanted to use... at least for the categories with the most stories.

Be careful doing that.  I've really hosed myself in the past doing stuff like that.  You've got to be careful with how you do the search and replace so if you do a search on "5" and replace it with "6" you don't also change "15" to "16" and "54" to "64". 🙂

Ah true, that's why you do a search for " 15;" and not just "15" or "15;". I learned that the hardway too. 🙂

I split this topic. The topic asking for a new feature is here https://efiction.org/forums/index.php?topic=4391.0