Re: Upgrade from 4.0.1 to 5.0

[mlus <ml...@39596.com>]

I solved this problem with fix two things.

1)  db convert problem

when use postgresql as db,  roller-5.0 will fail update db.

"400-to-500-migration.sql" has problem sql code.

----------------------------------------------------------------
insert into roller_permission
(id,username,actions,objectid,objecttype,pending,datecreated)
   select   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;
----------------------------------------------------------------

This insert SQL has problem, so change to

----------------------------------------------------------------
insert into roller_permission
(id,username,actions,objectid,objecttype,pending,datecreated)
   select   w.id || u.username  , u.username, 'edit_draft', w.handle,
'Weblog', false, 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;
----------------------------------------------------------------

roller_permission.pending column data is boolean type.
So, insert data "0" cause error !


2)  design  problem
Change to custom-design before update.
This save css data to " roller_data/[blogname] ".

roller5.0 has no design data.