http://wordpress.org/support/ WordPress › Support Topic: Category ID's en Thu, 26 Nov 2009 15:45:49 +0000 http://wordpress.org/support/topic/286212#post-1124827 Fri, 03 Jul 2009 13:58:17 +0000 MichaelH 1124827@http://wordpress.org/support/ <p>It is probably a fruitless to get your category IDs to be sequential. The post category IDs are shared with tags, link categories, and any other taxonomies so typically they will "be all over the place". </p> http://wordpress.org/support/topic/286212#post-1124626 Fri, 03 Jul 2009 07:59:49 +0000 aruffell 1124626@http://wordpress.org/support/ <p>Done it, wp_term and wp_term_taxonomy</p> <p>Andy </p> http://wordpress.org/support/topic/286212#post-1124622 Fri, 03 Jul 2009 07:52:47 +0000 aruffell 1124622@http://wordpress.org/support/ <p>What table is this in?</p> <p>My tables are:</p> <p> * Browse wpau_active_plugins_info<br /> * Browse wpau_upgrade_log<br /> * Browse wp_adrotate<br /> * Browse wp_adrotate_groups<br /> * Browse wp_adrotate_tracker<br /> * Browse wp_comments<br /> * Browse wp_email<br /> * Browse wp_links<br /> * Browse wp_options<br /> * Browse wp_pollsa<br /> * Browse wp_pollsip<br /> * Browse wp_pollsq<br /> * Browse wp_postmeta<br /> * Browse wp_posts<br /> * Browse wp_ratings<br /> * Browse wp_shashin_album<br /> * Browse wp_shashin_photo<br /> * Browse wp_statpress<br /> * Browse wp_terms<br /> * Browse wp_term_relationships<br /> * Browse wp_term_taxonomy<br /> * Browse wp_usermeta<br /> * Browse wp_users</p> <p>Andy </p> http://wordpress.org/support/topic/286212#post-1124618 Fri, 03 Jul 2009 07:46:06 +0000 Shane G 1124618@http://wordpress.org/support/ <p>Hi,</p> <p>You can change the category ID from the database table wp_category..you just need to edit the details from the table and save it..</p> <p>Thanks,</p> <p>Shane G. </p> http://wordpress.org/support/topic/286212#post-1124612 Fri, 03 Jul 2009 07:41:08 +0000 aruffell 1124612@http://wordpress.org/support/ <p>For some reason, my category ID's are all over the place.</p> <p>My categories with their respective ID's are:</p> <p>Interviews - 1067<br /> News - 4<br /> Press Releases -7<br /> Reviews - 10<br /> Tech Explained - 1290</p> <p>If i create a new category, it gets a number like 3742.</p> <p>Any ideas?</p> <p>I had a look in wp_terms and term ID and there are a lot of fields in there. So i'm guessing i would need to delete some of these? But i don't want to mess up my database, only just backed up and reinstalled to fix another issue i had.</p> <p>I don't want to create any more categories but i want to change the 2 categories that are such high numbers.</p> <p>Thanks,</p> <p>Andy </p>