Upgrade 7.0.2 to 7.0.3

Hello Everyone!

I did the update

but I'm stock on this page I see this WARNING RED BLOCK at the bottom

any Idead

can some one tell me about this

For some reason you don't have Profile Edit (pedit) page in page builder, this page is in default installation and I don't see the reason it is missing.

Hi AlexT!

can you tell me how to get it done

so I don't get thw warning red block

I'm waiting to fix this to do a upgrade to mysite

Thank's

- Restore site from backup

- Check if you have Profile Edit (pedit) page in page builder

- Add this page to page builder (if you have not this page), you can get code from original install.sql:

INSERT IGNORE INTO `sys_page_compose_pages` VALUES('pedit', 'Profile Edit', 8, 1);

INSERT IGNORE INTO `sys_page_compose` VALUES(NULL, 'pedit', '998px', 'Profile fields', '_edit_profile_info', 1, 1, 'Info', '', 1, 50, 'memb', 0);
INSERT IGNORE INTO `sys_page_compose` VALUES(NULL, 'pedit', '998px', 'Profile privacy', '_edit_profile_privacy', 2, 1, 'Privacy', '', 1, 50, 'memb', 0);

- Check if page was really added
- Run upgrade script again if you have this page in page builder

Hi AlexT!

One question can I do this with out doing the site restore backup

I did the upgrade and that's why I get on the block

can you tell me if I can do with out restoring my site using the backup

It is more complex solution - upgrade script modification will be required.

Hi AlexT!

I do have

Profile Edit in Page Builder

wat i do know

I'm getting the same errror.

INSERT INTO `sys_page_compose` (`Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`) VALUES('pedit', '998px', 'Manage Avatars', '_bx_ava_manage_avatars', 2, @iMaxOrder, 'PHP', 'return BxDolService::call(''avatar'', ''manage_avatars'', array ((int)$_REQUEST[''ID'']));', 1, 50, 'memb', 0);: Column 'Order' cannot be null

Yea

we have to wait for AlexT so we can get it to work wih out getting that error

Upgrade script tries to insert new 'manage avatars' block to 'profile edit' page into second column, but it looks like you have no second column on profile edit page. Then try to edit /upgrade/files/7.0.2-7.0.3/modules/avatar/sql.sql file and change this line:

SET @iMaxOrder = (SELECT `Order` + 1 FROM `sys_page_compose` WHERE `Page` = 'pedit' AND `Column` = 2 ORDER BY `Order` DESC LIMIT 1);

to this one:

SET @iMaxOrder = (SELECT `Order` + 1 FROM `sys_page_compose` WHERE `Page` = 'pedit' AND `Column` = 1 ORDER BY `Order` DESC LIMIT 1);

So it will try to insert new block into the end of first column, and run upgrade script again.