Upgrade 1.6->1.8.1 error: missing usrgrp and user_history

[tangel]

Is there a proper fix for the missing user_history table and usrgrp.debug_mode column?

I ended up running:

CREATE TABLE user_history (
        userhistoryid   bigint unsigned         DEFAULT '0'     NOT NULL,
        userid          bigint unsigned         DEFAULT '0'     NOT NULL,
        title1          varchar(255)            DEFAULT ''      NOT NULL,
        url1            varchar(255)            DEFAULT ''      NOT NULL,
        title2          varchar(255)            DEFAULT ''      NOT NULL,
        url2            varchar(255)            DEFAULT ''      NOT NULL,
        title3          varchar(255)            DEFAULT ''      NOT NULL,
        url3            varchar(255)            DEFAULT ''      NOT NULL,
        title4          varchar(255)            DEFAULT ''      NOT NULL,
        url4            varchar(255)            DEFAULT ''      NOT NULL,
        title5          varchar(255)            DEFAULT ''      NOT NULL,
        url5            varchar(255)            DEFAULT ''      NOT NULL,
        PRIMARY KEY (userhistoryid)
) type=InnoDB;
CREATE UNIQUE INDEX user_history_1 on user_history (userid);

alter table usrgrp add debug_mode integer default '0' NOT NULL;

[tangel]

I just found the upgrade shell script under upgrades/dbpatches/1.8/mysql .

This seems to try and take care of all the odds and ends that need to change when upgrading the database.

Is this something you just need to find or did I miss where it was mentioned in the documentation?

[tangel]

FYI, this should also stop the undefined index errors in the php frontend such as:

Undefined index: rows_per_page[/var/www/html/include/forms.inc.php:646