profiles map error

can't install it. I keep getting the following error

-- -- There are errors in the following MySQL queries:
-- -- Error: Column 'Order' cannot be null

INSERT INTO `sys_menu_top`(`ID`, `Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`, `Check`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `Icon`, `BQuickLink`, `Statistics`) VALUES(NULL, 6, 'Profiles Map', '_bx_map_world_map', 'modules/?r=map_profiles/', @iCatProfileOrder, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'bx_people.png', '', 0, '');

Module can not find "People" main menu item with ID=6 and can not add submenu there.

If you removed this menu item then you need to remove (or comment out) the following lines from "Profiles Map" module install.sql file:

-- top menu
SET @iCatProfileOrder := (SELECT MAX(`Order`)+1 FROM `sys_menu_top` WHERE `Parent` = 6 ORDER BY `Order` DESC LIMIT 1);
INSERT INTO `sys_menu_top`(`ID`, `Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`, `Check`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `Icon`, `BQuickLink`, `Statistics`) VALUES
(NULL, 6, 'Profiles Map', '_bx_map_world_map', 'modules/?r=map_profiles/', @iCatProfileOrder, 'non,memb', '', '', '', 1, 1, 1, 'custom', 'bx_people.png', '', 0, '');

Oh! That would explain it. Thank you.

I replaced the People main menu item and that did solve the problem. I need to learn how to read these errors better. Now that you've explained it, I can see how it happened.