When attempting to login to InstantForum or InstantKB or visiting InstantForum or InstantKB whilst already logged in you may receive the following error message...
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The is caused as you have 2 or more user accounts within the InstantASP_Users table with the same email address or username. Both email addresses and usernames within your InstantASP_Users table must be unique for each user.
If two or more users within the InstantASP_Users table have the same email address or username this error will occur.
InstantForum has built in checks to ensure usernames and email addresses are unique for every user. If you've added users to the InstantASP_Users table without using our .NET API this error could occur.
Identity the accounts where the username and email address appear two or more times and either delete the extra accounts or update the account email address or username to ensure it's unique.
You can identify accounts with the same username using the following TSQL query...
SELECT COUNT(UserID) As Occurrences, Username FROM InstantASP_Users GROUP BY Username ORDER BY Occurrences
Duplicate Email Addresses
You can identify accounts with the same email address using the following TSQL query...
SELECT COUNT(UserID) As Occurrences, EmailAddress FROM InstantASP_Users GROUP BY EmailAddress ORDER BY Occurrences
Once you've identified the problem accounts using the query above you will need to manually resolve the accounts with duplicate email addresses or usernames. Once all usernames and email addresses are unique you should not see the error detailed in this article again.
If this problem continues please don't hesitate to open a support ticket or contact us.