709 to 710 upgrade stops at Set @iMenuGroupsTop =

HI,

I ran a test upgrade 709 to 710 and the script stopped with the following:

SET @iMenuGroupsTop = (SELECT `ID` FROM `sys_menu_top` WHERE `Parent` = 0 AND `Type` = 'top' AND `Name` = 'Groups');: Subquery returns more than 1 row

I ran the select manually, pulling all columns and got the following:

ID     Parent     Name     Caption     Link     Order     Visible     Target     Onclick     Check     Movable     Clonable     Editable     Deletable     Active     Type     Picture     Icon     BQuickLink     Statistics
440     0     Groups     _bx_groups_menu_root     modules/?r=groups/home/|modules/?r=groups/     27                     3     1     1     1     1     top     modules/boonex/groups/|bx_groups.png         1    
411     0     Groups     _bx_groups_menu_root     modules/?r=groups/home/|modules/?r=groups/     25     memb                 3     1     1     1     1     top     modules/boonex/groups/|bx_groups.png         1    
414     0     Groups     _bx_groups_menu_root     modules/?r=groups/home/|modules/?r=groups/     26                     3     1     1     1     1     top     modules/boonex/groups/|bx_groups.png         1    

Any advice would be greatly appreciated.

Thanks!

For some reason you have more than one. And there should only be one.

Delete the ones with the ID of 414 and 440

I have deleted the rows successfully, but since the failure, I will refresh and start again with the upgrade.

Thanks for your help deano!