/
Errata - 3.0.2 Upgrading from a version older than 2.2.0

Errata - 3.0.2 Upgrading from a version older than 2.2.0

By Mark Unwin
Apr 12, 2019

We have an issue where we attempt to read the dashboards table, which doesn't exist pre- 2.2.0.

This results in the web interface trying to redirect in an infinite loop.

All that is required is to create the table, then you should be able to log on to the web interface and run the schema upgrade as per normal.

This will be addressed for our next release.

 

Linux.

mysql -u openaudit -popenauditpassword openaudit -e "CREATE TABLE dashboards (id int(10) unsigned NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL DEFAULT '', org_id int(10) unsigned NOT NULL DEFAULT '1', type enum('default','org','user','') NOT NULL DEFAULT '', user_id int(10) unsigned NOT NULL DEFAULT '0', description text NOT NULL, sidebar enum('y','n') NOT NULL DEFAULT 'y', options text NOT NULL, edited_by varchar(200) NOT NULL DEFAULT '', edited_date datetime NOT NULL DEFAULT '2000-01-01 00:00:00', PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8;"

Windows

c:\xampp\mysql\bin\mysql.exe -u openaudit -popenauditpassword openaudit -e "CREATE TABLE dashboards (id int(10) unsigned NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL DEFAULT '', org_id int(10) unsigned NOT NULL DEFAULT '1', type enum('default','org','user','') NOT NULL DEFAULT '', user_id int(10) unsigned NOT NULL DEFAULT '0', description text NOT NULL, sidebar enum('y','n') NOT NULL DEFAULT 'y', options text NOT NULL, edited_by varchar(200) NOT NULL DEFAULT '', edited_date datetime NOT NULL DEFAULT '2000-01-01 00:00:00', PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8;"

Related content