The MU forums have moved to WordPress.org

Database error: Unknown column 'user_id' in 'field list' (5 posts)

  1. Farms
    Member
    Posted 18 years ago #

    Hiya,

    When trying to install teh latest upgrades this error has kept on coming up:

    "WordPress database error: [Unknown column 'user_id' in 'field list']
    SELECT user_id FROM wp_users WHERE user_login = 'admin'"

    Which brings this up for new users (i.e. breaks the system):

    "Warning: Cannot modify header information - headers already sent by (output started at /home/lndblogs/public_html/wp-inst/wp-includes/wp-db.php:108) in /home/lndblogs/public_html/wp-inst/wp-includes/pluggable-functions.php on line 199

    Warning: Cannot modify header information - headers already sent by (output started at /home/lndblogs/public_html/wp-inst/wp-includes/wp-db.php:108) in /home/lndblogs/public_html/wp-inst/wp-includes/pluggable-functions.php on line 200

    Warning: Cannot modify header information - headers already sent by (output started at /home/lndblogs/public_html/wp-inst/wp-includes/wp-db.php:108) in /home/lndblogs/public_html/wp-inst/wp-includes/pluggable-functions.php on line 172"

    Is anyone else having this problem? I'd really appreciate an pointer at fixing it.

    Cheers, James

  2. octarine
    Inactive
    Posted 18 years ago #

    I came across this problem too. I posted on here.
    My solution was:
    I installed wpmu today, and was seeing alot of database errors.

    Changing the column name on line 377 of wpmu-functions.php from user_id to ID seems to have fixed it.

  3. Farms
    Member
    Posted 18 years ago #

    Thanks that's great has worked just fins (so far ;)

    A note for the Devs... it's still a problem in the 21 August release...

    Cheers, James

  4. donncha
    Key Master
    Posted 18 years ago #

    Got it fixed now! Thanks for spotting that, I was away for a few days.

  5. Farms
    Member
    Posted 18 years ago #

    Thanx Donncha :)

About this Topic