Article ID: 9501, created on Dec 27, 2010, last review on Jun 19, 2016

Symptoms

When you log in under a customer account to the native Control Panel provided by Parallels Customer and Business Manager and go to Invoices or Subscriptions, you see the error “Exception thrown without a stack frame in Unknown on line”.

Cause

The database of Parallels Customer and Business Manager is in the inconsistent state because of an error occurred on creation of such customer accounts.

Resolution

The error happens when a customer is assigned a wrong theme ID. To fix it, you should run an appropriate MySQL statement we give in this article. We suppose that your Parallels Customer and Business Manager DB name is billing. Otherwise, update the MySQL statements correspondingly.

To fix the account under Linux, run the following command:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin billing -e"UPDATE clients SET theme_id = (SELECT theme_id FROM themes WHERE theme_name = 'default' AND theme_active = 1 LIMIT 1)"

To fix the account under Windows, do the following:

  1. Run the following command to receive a password to the Business Manager database:

    "%plesk_bin%\dbclient.exe" --direct-sql --sql="select admin_password from databaseservers order by id asc limit 1"
    
  2. Change the theme ID:

    "%plesk_dir%\mysql\bin\mysql -uadmin –p<cbm_db_password> billing –e”UPDATE clients SET theme_id = (SELECT theme_id FROM themes WHERE theme_name = 'default' AND theme_active = 1 LIMIT 1)”
    

Email subscription for changes to this article
Save as PDF