Upgrade Error

TMDHosting tried to upgrade my site and the upgrade failed.  They received the following error.  Can you assist us?

Please note that we have tried to upgrade your application to its most recent stable version available, but the attempt was unsuccessful because we have received the following error during the upgrade process:

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

Search the forums here.  I believe some are seeing duplicate rows in the database when upgrading.  If so, you have to go into the database to fix the problems.  If you do, back up the database first.

If TMDHosting has supplied you with cPanel, or another control panel, with phpMyAdmin, you can use it to remove the duplicate row.  As always, back up the database (the export, select all tables, save to file) in case you do something wrong and trash the database.

If TMDHosting could perform the upgrade for you, I don't see why TMDHosting can not try deleting the duplicate row for you.

Yes, there are two rows in the database that meet the criteria of the query.  However, the two rows are not duplicate.

Can TMD restore your site?  It is possible they "screwed" up the upgrade and you may wish for someone else to perform the site upgrade.

One question, what version of Dolphin were you using before the upgrade?  The upgrade to 7.1 can only be performed on 7.0.9.  If your site was not 7.0.9, then you have to upgrade through the upgrades to reach 7.0.9.

The two rows that is tripping up the query are:

411     0     Events     _bx_events_menu_my_events_profile     modules/?r=events/browse/my     0     memb                 3     1     1     1     0     top             0

398     0     Events     _bx_events_menu_root     modules/?r=events/home/|modules/?r=events/     5     memb                 3     1     1     1     1     top     modules/boonex/events/|bx_events.png         1

I was hoping someone more knowledgeable than I would chime in with their advice.  However, after studying the menu structure in the backend, and doing a bit of reading on what the blue and red menu items, top versus system, mean.  I think I have concluded correctly that entry ID 411 is in error; perhaps added to the database by a module install.  The two are not duplicates, so mySQL server would not have had a hissy fit.

411 is entered as a top menu item; however 398 is also entered as a top menu item with the same parent and name.  Looking at the "code" for the top menu item it would appear that ID 398 is the correct one.  Perhaps 411 is suppose to be a custom entry instead but I really don't know.

OK, the 411 entry is the "My Events" button.  So that needs to stay.