The MU forums have moved to WordPress.org

Error with Most Active Blogs (1 post)

  1. sskhalsa
    Member
    Posted 17 years ago #

    I have an error with my Most Active Blogs.

    The root cause of the error is some mess up in the blog ids. Somehow the User Ids and Blog Ids are off by one number. I can fix it temporarily, but whenver a new blog appears I get the following errors on my homepage:

    WordPress database error: [Table 'sskhalsa_wpmu.wpmu_337_posts' doesn't exist]
    SELECT count(*) FROM wpmu_337_posts WHERE post_status='publish'

    WordPress database error: [Table 'sskhalsa_wpmu.wpmu_336_posts' doesn't exist]
    SELECT count(*) FROM wpmu_336_posts WHERE post_status='publish'

    WordPress database error: [Table 'sskhalsa_wpmu.wpmu_337_posts' doesn't exist]
    SELECT count(*) FROM wpmu_337_posts WHERE post_status='publish'

    WordPress database error: [Table 'sskhalsa_wpmu.wpmu_336_posts' doesn't exist]
    SELECT count(*) FROM wpmu_336_posts WHERE post_status='publish'

    Is there anyway to clean up these tables? I tried searching through it
    but the numbers won't align even when I find offending usernames or blogs.

About this Topic

  • Started 17 years ago by sskhalsa