[ROL-1953] mysql roller_permission insert statements not defined correctly in 400-to-500-migration.vm and 400-to-500-migration.sql file

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0
• Fix Version/s: 5.0.2, 5.1.0
• Component/s: Installation & Configuration
• Environment: any
• Assignee: Roller Unassigned
• Reporter: Harsh Gupta
• Created: 29/Nov/12 08:07
• Updated: 14/Jan/14 02:57
• Resolved: 30/Dec/12 16:26

Description

Here select statement is a combination of w.id and w.username whereas the column where it has to insert is roller_permission's id column that doesn't have enough length to fit in.

concat function is incorrectly used here according to me and if i just use select w.id , upgrade works for me

insert into roller_permission (id,username,actions,objectid,objecttype,pending,datecreated)
select concat(w.id, u.username) , u.username, 'edit_draft', w.handle, 'Weblog', 0, current_timestamp
from rolleruser as u, website as w, roller_user_permissions as p
where p.user_id = u.id and p.website_id = w.id and permission_mask = 1;

insert into roller_permission (id,username,actions,objectid,objecttype,pending,datecreated)
select concat(w.id, u.username) , u.username, 'author', w.handle, 'Weblog', 0, current_timestamp
from rolleruser as u, website as w, roller_user_permissions as p
where p.user_id = u.id and p.website_id = w.id and permission_mask = 2;

insert into roller_permission (id,username,actions,objectid,objecttype,pending,datecreated)
select concat(w.id, u.username) , u.username, 'admin', w.handle, 'Weblog', 0, current_timestamp
from rolleruser as u, website as w, roller_user_permissions as p
where p.user_id = u.id and p.website_id = w.id and permission_mask = 3;