module uninstall failed

I have tried to uninstall the Orca Forum module from Admin Tools but get the following message :

Uninstallation of: Orca Forum Failed

-- Changing Database:

-- -- There are errorsin the following MySQL queries:

-- -- Error: Subquery returns more than 1 row

SET @ild = (SELECT 'ID' FROM 'sys_menu_top' WHERE 'Name' = 'Forum' AND 'Parent' = 0);

Can anyone can shed some light on this?

It means there is more than one entry in the top nav menu that has the name Forum.

The duplicate will need to be manually removed from the sys_menu_top database table via phpMyAdmin.

Hi Deano

I was hoping you would answer but before I got your reply I deleted a couple of lines including

SET @ild = (SELECT 'ID' FROM 'sys_menu_top' WHERE 'Name' = 'Forum' AND 'Parent' = 0);

and the forum sprung into action so I'm not going to push my luck, I've been at this all day and now going for a beer...

Sorry Deano

I was in too much of a rush for that beer to explain correctly.

I needed to uninstall the Forum as I was missing the Page Builder Blocks for Forum then to reinstall it to get back the blocks but failed when uninstalling as previously mentioned.

By deleting those lines I was able to uninstall Forum then reinstall it which as you will know would put the blocks back....what you said as a solution was something I was looking at but too nervous to try....many thanks again

Well. Just make sure you put those lines back. If you don't, next time you uninstall, the uninstall will not be clean which will then in turn cause a problem reinstalling.

very much appreciated, many thanks