Unable to install Profiles Map module: Error

Hello,

I'm not sure what has caused this but I am receiving the following error when trying to install the module Profiles Map. I get the following error:

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, '');

I have checked the tables in the database and a number of the rows have null in the 'Order' column, I have another installation of Dolphin though which has the same data in the 'Order' column but the module installs and uninstalls with no problem.

Please could anyone advise what I could do to rectify the problem please?

Many thanks,

Hi,

I have same problem - I have checked the forums - no answer to be found.

Many Thanks

Glenn

Hi,

Solved.... Navigate to you MySQL table go to phpadmin - go to Dolphin Database - go to table

sys_menu_top

Edit table - tick - allow null

Done

Need more details. I am not finding the null checkbox

Use PhpAdmin

1. click on the table name sys_menu_top in the left column
2. click on structure on the upper tabbed area
3. click the pencil for the Order field
4. on the next screen check Null
5. save
6. Then try to reinstall Google Search

This worked for me.

Have the same error on Profile Map/D 7.0.4. Fixed with your tips. Thanks a lot!

That worked ... Thanks!