The MU forums have moved to WordPress.org

DB error help (5 posts)

  1. kahless
    Member
    Posted 18 years ago #

    Any idea what this is about?

    WordPress database error: [Unknown column 'spam' in 'field list']
    SELECT spam FROM wp_blogs WHERE blog_id = '2'

    I get this when I try to use the Site admin to display the blogs. I have installed the WPMU Mailer plugin, but I don't think that is it.

    This is where the Spam column links to
    http://blogs.wooster.edu/wp-admin/wpmu-edit.php?action=spamblog&id=2

    Do I need to run a DB update script? I ran Upgrade Site from Site Admin. Help.

  2. itdamager
    Member
    Posted 18 years ago #

    You could either ignore that until the devs fix it, or you could, at your own risk, manually run the following mysql query to fix it and enable the new 'mark as spam' option.

    ALTER TABLE wp_blogs ADD spam ENUM( '0', '1' ) DEFAULT '0' NOT NULL ;

  3. kahless
    Member
    Posted 18 years ago #

    The risk was minimal. What is more annoying is the fact that I no longer get the entire list of blogs when viewing Site Admin and the Blog tab. Any clue why?

    I also got things to upgrade using your patches. No idea what was wrong and you can ignore my comment on your blog. Thanks for helping out the less skilled.

  4. itdamager
    Member
    Posted 18 years ago #

    The page loads normally for me, but my entire list of blogs is only 3 on my test system...

  5. Stapleton
    Member
    Posted 18 years ago #

    yes I had that problem with not being able to display the blogs and the spam error, so what I did was replace the wpmu-blogs with a older version, and it made all the blogs display you can get it here:
    http://www.bloggoing.com/wp-inst/wpmu-blogs

About this Topic

  • Started 18 years ago by kahless
  • Latest reply from Stapleton