I just upgraded to 2.1.2, which uses CatLinks as the basis of the total link count. This has revealed that I have a bunch of links (187) in the CatLinks table that are no longer in the Links table (I don't know how or why... maybe I once deleted a bunch using phpMyAdmin or something...). So, my total count is off (and it's a bit of wasted space in the db).
So, can anyone provide a MySQL statement that would check each LinkID in the CatLinks table for a matching ID in the Links table, and delete any that don't exist in the Links table?
(Suggestion to GT: It would be handy if the "Repair Tables" function did this automatically. I can't be the first person to have gotten the tables out of sync.)
Thanks,
~~~~~~~~~~~~~~~~~~~~~~
Jamie Marie
BuffyGuide.com
So, can anyone provide a MySQL statement that would check each LinkID in the CatLinks table for a matching ID in the Links table, and delete any that don't exist in the Links table?
(Suggestion to GT: It would be handy if the "Repair Tables" function did this automatically. I can't be the first person to have gotten the tables out of sync.)
Thanks,
~~~~~~~~~~~~~~~~~~~~~~
Jamie Marie
BuffyGuide.com