Menu

Search

InstantASP Support

Help & Support


Subquery returned more than 1 value


Error Messages

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.

Cause

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.

Resolution

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.

Duplicate Username

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.

That's It!

If this problem continues please don't hesitate to open a support ticket or contact us.


Optionally provide private feedback to help us improve this article...

Thank you for your feedback!


Comments require login or registration.

Details

Product: InstantKB, InstantForum
Version: All Versions
Type: ERRMSG
Level: Novice
Article not rated yet.
Article has been viewed 2.2K times.
Last Modified: 2 Years Ago
Last Modified By: Ryan Healey

Options

Similar Articles