Revolved : Reseller problem account

**theprincy** · Apr 18th 2014

i can login with the admin-account, but if i change into a reseller that has created a domain or assigned this message appears:

Code

An error has been encountered
An exception with the following message has been thrown in file /var/www/imscp/gui/library/shared-functions.php (Line: 2551):
SQLSTATE[HY093]: Invalid parameter number: no parameters were bound
Query was:
SELECT * FROM domain WHERE domain_id = ?

Display More

Latest Stable-Release: 1.1.5
Linux System : Debian 7

**Nuxwin** · Apr 18th 2014

Hello ;

Teamviewer?

**theprincy** · Apr 18th 2014

send pm

**theprincy** · Apr 18th 2014

This was some orphan entries (eg, user without domain entry in database).

**Nuxwin** · Apr 18th 2014

To resume, to find those orphan entries (user without domain entry) I've run the following SQL query:

SQL

SELECT admin_id, domain_name FROM admin LEFT JOIN domain ON(domain_admin_id = admin_id) WHERE created_by = <reseller_id>

Where <reselller_id> must be replaced with the reseller unique identifier.

In the result, any entry with domain_name set as NULL is an orphan entry. Therefore, you can remove the user(s) with one of the following queries:

One user only

SQL

DELETE FROM admin WHERE admin_id = <admin_id>

where <admin_id> must be replaced by your admin ID

Many users

SQL

DELETE FROM admin WHERE admin_id IN(<admin_id_list>)

where <admin_id_list> must be replaced by your admin ID list, each comma separated.

Once it's done, you must also check in other tables and remove any row which reference the ID of deleted admins.

Revolved : Reseller problem account

Share

Daily visitors