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.