Fork me on GitHub

Unknown column 'pn_name' in 'field list' when Upgrading  Bottom

  • Running the upgrade script and it's spitting out a repetitive list of that below, I'm guessing it's doing it for each user on the database but when I look up the table it's not listed as pn_name for their username instead it's pn_uname did it bug out on me?

    Quote

    Unknown column 'pn_name' in 'field list'
    SELECT pn_uid AS "uid",pn_name AS "name",pn_email AS "email",pn_femail AS "femail",pn_url AS "URL",pn_user_avatar AS "user_avatar",pn_user_icq AS "user_icq",pn_user_occ AS "user_occ",pn_user_from AS "user_from",pn_user_intrest AS "user_intrest",pn_user_sig AS "user_sig",pn_user_aim AS "user_aim",pn_user_yim AS "user_yim",pn_user_msnm AS "user_msnm",pn_bio AS "bio",pn_timezone_offset AS "timezone_offset" FROM nuke_users76x


    Also another one says

    Quote

    Backing Up user database...
    Unknown column 'pn_timezone_offset' in 'field list'
    UPDATE nuke_users SET pn_timezone_offset = pn_timezone_offset-12
    done
  • 0 users

This list is based on users active over the last 60 minutes.