Error SQL during UPGRADE 7.0.9 --> 7.1

Big error during upgrade  709 ---> 710

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

Have you an idea ?

Thanks per advance

ERROR 701 UPGRADE.png · 85.3K · 279 views
Quote · 12 Dec 2012

yup  you need to go in the database and remove the one of the two sounds links in sys_menu_top.   you may be able to do it from the admin panel in nav builder if the admin still works

then your gonna have to set the tmp version back to 7.0.9 in sys_options table.

Then your gonna have to edit the install sql and remove the first few lines of code because you cant run those queries more then once. 

https://dolphin-techs.com - Skype: Dolphin Techs
Quote · 12 Dec 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.