The MU forums have moved to WordPress.org

Category ID STRANGE problem!! (16 posts)

  1. davec53
    Member
    Posted 17 years ago #

    ok, i found someone having a similar problem posted on .org...

    http://wordpress.org/support/topic/29489?replies=23

    ...i was adding new categories to my blog, and the ID was incrementing just fine. i'm not sure what happened, but all of a sudden, when i went to add a new category to the 10 i already had, instead of the next one being "11", it was like 3452 or some strange value like that!

    the next one would go even higher...and the next...and the next...the increment value was just exponential!

    anyways, i thought i had solved it by going into phpmyadmin and selecting my wp_1_categories, choosing "operations" and manually setting the auto_increment value to 11. by the time i got back to my blog and added a new category, that value had already been reset to 3276, and i suspect if i add another category, it will change again (fixing to find out!)

    so what in the WORLD has gone wrong? why is the auto_increment value going nuts like this? has anyone had this problem, and if so, have you solved it??

  2. drmike
    Member
    Posted 17 years ago #

    You don't have other folks creating categories, do you? Those numbers are sitewide.

  3. nolageek
    Member
    Posted 17 years ago #

    I'm having the same problem. ID for 'Uncategory' is 1 and Blogroll is '2'.. then next one is 3486, next is 4432, next is 6051. These were each done right after each other... and no one else is logged in (I only have 3 active blogs anyway.. I doubt each one is creating a thousand categories every second.)

  4. drmike
    Member
    Posted 17 years ago #

    I can't get my db to load in phpMyAdmin from here. Can someone else confirm that this is or isn't occuring for them please?

  5. dsader
    Member
    Posted 17 years ago #

    Look in wp_sitecategories. Are the categories there? I have thousands of categories, but they definitetly increase by 1 till the crack of doom. The cat_id numbers in wp_###categiories come from wp_sitecategories.

    There should be no rhyme or reason why the numbers in wp_1_categories do anything but mymic their counterparts in wp_sitecategories.

    from wpmu-functions.php

    [deleted code - drmike]
  6. nolageek
    Member
    Posted 17 years ago #

    They are not showing up in wp_sitecategories.

    Here's my lists.

    
    ID      Category Name
    
    wp_sitecategories
    1  	Uncategorized
    2 	Blogroll
    3 	test
    4 	adasda
    5 	Random Thoughts
    6 	Personal Thoughts
    7 	links
    8 	Weird
    9 	Don't screw with us...
    10 	New Orleans
    11 	New You Can Use
    12 	Rubbish
    13 	Heroes
    
    wp_3_categories
    1  	New Orleans
    2 	Blogroll
    11 	News You Can Use
    5 	Random Thoughts
    6 	Personal Thoughts
    7 	links
    8 	Weird
    9 	Don't screw with us...
    13 	Heroes 	heroes
    12 	Rubbish
    
    wp_11_categories
    1  	Uncategorized
    2 	Blogroll
    2682 	Lesbian
    3713 	Gay
    4888 	Queer
    7650 	New Orleans
    10421 	Legal
    12586 	Other Places
    14869 	Trans
    16773 	Transition
    17484 	Bars
    18552 	Billiards
    18764 	Skating
    21861 	Food
    23814 	Catz
    
    wp_12_categories
    1  	Uncategorized
    2 	Blogroll
    3151 	Poetry
    5245 	Thoughts
    
    wp_14_categories
    1  	life
    2 	Blogroll
    3486 	gayness
    4432 	celebrity
    6051 	life stuff

    I just added two more categories to wp_3_categories and they're:

    
    ID      Category Name
    1189  	test
    5115 	test2

    I did try to install the site-wide categories mod a while back. Could that have FUBARed something up? Blogs seem to work OK.

  7. drmike
    Member
    Posted 17 years ago #

    I did try to install the site-wide categories mod a while back

    Might have as I (was finally able to) check on my own install and they list fine.

  8. nolageek
    Member
    Posted 17 years ago #

    any ideas on how I can stop this from happening? seems like eventually it's not going to like a category with an id of 19829834893003540093095030

  9. dsader
    Member
    Posted 17 years ago #

    If doom had a number, that might be it.

  10. dsader
    Member
    Posted 17 years ago #

    If doom had a number, that might be it.

    I'll try it in my DVD encoder/decoder and see what happens.

  11. nolageek
    Member
    Posted 17 years ago #

    so like, what would be the correct way to fix this before something blows up. :)

    If I were to reupload the WPMU files that should get rid of any extraneous files left over from the SW tag mod.. but is there anything I should do from a DB perspective? What's causing it to pick these (seemingly) random numbers?

  12. nolageek
    Member
    Posted 17 years ago #

    still cant get rid of this problem. anyone else seeing this?

  13. drmike
    Member
    Posted 17 years ago #

    May want to check out hte *.org link as they discuss a solution over there.

  14. re5et
    Member
    Posted 17 years ago #

    i'm having the same problem, i have not been able to locate the other thread.

  15. re5et
    Member
    Posted 16 years ago #

    is there any news on this, or are people still experiencing the problem?

  16. nolageek
    Member
    Posted 16 years ago #

    Weird. I have this in my wp_11_categories table now, after the 'Catz' category that was previously posted:

    26274  	Transsexual
    27539 	Enemies
    29534 	Strange
    32518 	Events
    138 	Beingness

    Did it just go back to 138 after getting all the way up to 32518? Does that happen?

    I just created a new category in in the main site and it got an ID of 3.

    I just created a new category in blog 3 and it got an id of 163. Created another there and it got an id of 164. So, it fixed itself... but weird?

    Why didn't the category I created in the main site get an id of 162?

About this Topic

  • Started 17 years ago by davec53
  • Latest reply from nolageek