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