Article ID: 3665, created on Feb 8, 2008, last review on Apr 18, 2012

  • Applies to:
  • Helm 3

Resolution

Problem/Summary

When adding a service type, you see duplicate entries (e.g. Access, Access, Ipswitch Mail 6, Ipswich Mail 6).

Checking the error logs, you may see errors similar to these:

AND LimitPropertyId = (SELECT LimitPropertyId FROM LimitProperty WHERE LimitPropertyName = 'MaxPHPInstals')
(Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.)
 
Solution
The key part is "Subquery returned more than one value". There should only be one value for each of these.

This happens if the database set up script has been run twice. Doing this will cause serious issues in Helm. If you have just set up the database you need to drop the database and rebuild it again.

110556ad4b9f1c73a3682661cd1dca89 152090ff5e9a05ea7e1cf0c248449638 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF