Upgrade 1.1 -> 1.4 loses 'Applications'

[azilber]

Doing the upgrade, all the items associated with a particulate application became unassociated. What a mess.

For some reason also the user 'Admin' did not get type=3 (even though that's in the patch.sql). Very strange.

[Alexei]

Fixed statement for migration of users:

update users_tmp set type=3 where [b][color=DarkRed]alias[/color][/b]='Admin';

Fixed items_applications migration script (MySQL):

CREATE TABLE items_applications_tmp (
		itemappid			   bigint unsigned		 NOT NULL auto_increment,
		applicationid		   bigint unsigned		 DEFAULT '0'	 NOT NULL,
		itemid		  bigint unsigned		 DEFAULT '0'	 NOT NULL,
		PRIMARY KEY (itemappid)
) ENGINE=InnoDB;
CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);

insert into items_applications_tmp select NULL,applicationid,[b][color=DarkRed]itemid[/color][/b] from items_applications;
drop table items_applications;
alter table items_applications_tmp rename items_applications;

CREATE TABLE items_applications_tmp (
		itemappid			   bigint unsigned		 DEFAULT '0'	 NOT NULL,
		applicationid		   bigint unsigned		 DEFAULT '0'	 NOT NULL,
		itemid		  bigint unsigned		 DEFAULT '0'	 NOT NULL,
		PRIMARY KEY (itemappid)
) ENGINE=InnoDB;
CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);

insert into items_applications_tmp select * from items_applications;
drop table items_applications;
alter table items_applications_tmp rename items_applications;

[tronite]

Fixed statement for migration of users:

update users_tmp set type=3 where [b][color=DarkRed]alias[/color][/b]='Admin';

Fixed items_applications migration script (MySQL):

CREATE TABLE items_applications_tmp (
		itemappid			   bigint unsigned		 NOT NULL auto_increment,
		applicationid		   bigint unsigned		 DEFAULT '0'	 NOT NULL,
		itemid		  bigint unsigned		 DEFAULT '0'	 NOT NULL,
		PRIMARY KEY (itemappid)
) ENGINE=InnoDB;
CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);

insert into items_applications_tmp select NULL,applicationid,[b][color=DarkRed]itemid[/color][/b] from items_applications;
drop table items_applications;
alter table items_applications_tmp rename items_applications;

CREATE TABLE items_applications_tmp (
		itemappid			   bigint unsigned		 DEFAULT '0'	 NOT NULL,
		applicationid		   bigint unsigned		 DEFAULT '0'	 NOT NULL,
		itemid		  bigint unsigned		 DEFAULT '0'	 NOT NULL,
		PRIMARY KEY (itemappid)
) ENGINE=InnoDB;
CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);

insert into items_applications_tmp select * from items_applications;
drop table items_applications;
alter table items_applications_tmp rename items_applications;

Sorry to ask, but is there a mailing list where we can be told as users beforehand of such issues?

[tronite]

Sorry about the last post I just realised that there is a forum dedicated to just the patches!