Hi,

I am running the automatic upgrade from 5.5 V2 -> 6.0.

It ends with an error:
"Running SQL script (upgrade.sql)
Failed to run SQLscript: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."

Trying to run it manually shows me the exact 4 statements causing the error, which is:

UPDATE CMS_SettingsCategory SET CategoryIconPath = NULL, CategoryIsCustom = 0, CategoryIsGroup = 1, CategoryParentID = (SELECT CategoryID FROM CMS_SettingsCategory WHERE CategoryName = 'CMS.FacebookConnect') WHERE CategoryName = 'CMS.FacebookConnect.General';

UPDATE CMS_SettingsCategory SET CategoryIconPath = NULL, CategoryIsCustom = 0, CategoryIsGroup = 1, CategoryParentID = (SELECT CategoryID FROM CMS_SettingsCategory WHERE CategoryName = 'CMS.Integration.SharePoint') WHERE CategoryName = 'CMS.SharePoint.General';

UPDATE CMS_SettingsCategory SET CategoryIconPath = NULL, CategoryIsCustom = 0, CategoryIsGroup = 1, CategoryParentID = (SELECT CategoryID FROM CMS_SettingsCategory WHERE CategoryName = 'CMS.MetaWeblogAPI') WHERE CategoryName = 'CMS.MetaWeblogAPI.General';

UPDATE CMS_SettingsCategory SET CategoryIconPath = NULL, CategoryIsCustom = 0, CategoryIsGroup = 1, CategoryParentID = (SELECT CategoryID FROM CMS_SettingsCategory WHERE CategoryName = 'CMS.OpenID') WHERE CategoryName = 'CMS.OpenID.General';

The error message(s) is correct the select do return more than one record so it doesn't make sense!

I dont believe that I have been messing with those tables, so the question is how do I proceed?

Thanks!

Per