Upgrade Error

After completing the upgrade from 7.0.9 to 7.1.0, I received the following error message: 

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

Can someone provide the solution to this problem?

Somehow you have several menu items named "Video", it should be only one.

You need to get rid of duplicated menu items with system name = 'Video'.

You can do it via Admin Navigation Builder.

After you did this you need to run upgrade script again, however some more steps are needed to run it again, more details are here:

http://www.boonex.com/forums/topic/Errors-fixing-procedures-during-upgrade.htm

Thanks for the reply Alex :)  After missing around with the http://www.boonex.com/forums/topic/Errors-fixing-procedures-during-upgrade.htm, I was finally able to successfully upgrade to D7.1.   Somehow there were two instances of "Videos" for the top menu in my database, after deleting the extras and removing the russian language pack in the Upgrade patch, then I was able to upgrade. 

The only question I have now is how to remove this message,

You can ignore this message for a while, since 7.0.9 is still considered as stable version and 7.1.0 is beta for now.

I was in limbo with my site.  I didn't want to spend all this time adding content to a D7.0.9 site to only have to complete a major overhaul to upgrade to D7.1.  So, I downloaded the latest version of D7.1 and set it up yesterday.  There were a few bugs, but the majority of the issues are simply cosmetic issues.  My videos work now :)