Support » Fixing WordPress » Error Update Users & What should I do?

  • Hello I was got this error and how to fix this. This happen everytime I try to update my Profile.
    Database error: [Unknown column ‘user_description’ in ‘field list’]
    UPDATE wp_users SET user_firstname=’Nurudin’, user_lastname=’Jauhari’, user_nickname=’ari’, user_icq=”, user_email=’nurudinjauhari@yahoo.com’, user_url=’http://’, user_aim=”, user_msn=”, user_yim=’nurudinjauhari’, user_idmode=’nickname’, user_description = ”, user_nicename = ‘ari’ WHERE ID = 1
    ERROR: couldn’t update your profile…
    Thanks everyone

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Matt Mullenweg

    (@matt)

    Troublemaker

    Run upgrade.php again with a newer version.

    Getting same error. Ran upgrade.php, nothing…
    New, fresh install of latest nightly, same problem. Seems like a bug in the sql update string…

    It looks like user_description is new, but the install / upgrade scripts aren’t adding that column to the users table.
    I just went in to the table and added it, but it should be fixed in the upgrade or install scripts somewhere.

    I suggest making “TEXT” lowercase in DB schema and try upgrade again, since all other text-type fields use lowercase. Other text fields also don’t include default values.
    Still, this worked fine on my upgrade.

    I suggest making “TEXT” lowercase in DB schema and try upgrade again, since all other text-type fields use lowercase. Other text fields also don’t include default values.

    can you explain clearer??

    Yeah, not sure what that means…
    Do you have access to phpmyadmin?
    A quick workaround is to go into the users table and just add the user_description as an extra field. It seems right now in the nightlys this is missed as a new field.
    Either that, or start hacking up the code to back out the new stuff regarding user_description calls… But that’s pointless.
    I’m sure it’ll get fixed down the road, but simply adding this field manually solved my issue, which sounds exactly like your issue.

    and after browsing through the bug track and cvs, it appears to be solved in cvs, so wait for the next nightly if you are uncomfortable with adding the field yourself

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error Update Users & What should I do?’ is closed to new replies.