I (thankfully) tested the upgrade from v3.1.1 to v3.2 on my site locally. I am getting an SQL error: “Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.”
I compiled the debug symbols, and tracked the error down to the script GetPortal. It seems the subquery in the line
'SuperTabId' = ( select TabId from Tabs where PortalId is null and ParentId is null ),
returns two values, 7 and 288.
After comparing the production database to the upgraded test database, I noticed there are three new entries in the tab table:
| TabID |
TabOrder |
PortalID |
TabName |
IsVisible |
ParentID |
Level |
TabPath |
| 287 |
10027 |
0 |
Authentication |
1 |
6 |
1 |
//Admin/Authentication |
| 288 |
-1 |
<NULL> |
Authentication |
1 |
<NULL> |
1 |
//Authentication |
| 289 |
0 |
2 |
Authentication |
1 |
223 |
0 |
//Admin//Authentication |
The record 288 is being returned as the SuperTabId along with the normal Host tab.
Any ideas?