WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Data too long for column (10 posts)

  1. steven_stern
    Member
    Posted 8 years ago #

    When I go to the dashboard, there's an error message splattered all over the page, beginning with

    [Data too long for column 'option_value' at row 1]
    UPDATE wp_options SET option_value =

    If I refresh the page, the error goes away and the main admin page displays normally.

    As far as I can tell, 3 rows in wp_options are updated, all relating to RSS.

  2. maerk
    Member
    Posted 8 years ago #

    Have you recently installed a plugin?

  3. steven_stern
    Member
    Posted 8 years ago #

    Nothing recent. I'll deactivate them all and start turning them on, one by one.

  4. steven_stern
    Member
    Posted 8 years ago #

    Nothing's changed in my plugins, and disabling and re-enabling didn't seem to help. I've added a timestamp column to wp_options to see what's changing.

  5. maerk
    Member
    Posted 8 years ago #

    When you say you added a column to wp_options, what do you mean?

    Based on your error message, it looks like wordpress is trying to write something to your options table in your database, but the database has been set up to only accept things of a certain length (number of characters).

    Did this start happening suddenly, or has it done this since you installed it? It's very strange, do you know which part of the database specifically is being affected, can you check your server's error logs at all?

  6. steven_stern
    Member
    Posted 8 years ago #

    I moved the tables to innodb, then back to MyISAM, so that may have broken something. I'm enabling query logging and will post a reply here when I have something that looks interesting.

  7. steven_stern
    Member
    Posted 8 years ago #

    There are some really nasty UPDATE statements in the log. I put them at http://sstern.ccim.com/update-query.zip.

  8. steven_stern
    Member
    Posted 8 years ago #

    This is still an issue. I've posted a picture of what I see at http://sstern.ccim.com/wp-admin-bug.png. It seems that the feed used to build the dashboard is the problem.

  9. jimqode
    Member
    Posted 8 years ago #

    I found a workaround for this problem. Have a look at http://symbolengine.com/?p=6

  10. steven_stern
    Member
    Posted 8 years ago #

    Thanks! It's a shame to cut off the feed, but...

    Why isn't everyone reporting this problem?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags