• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

What do You think about that???

Q

Q6511200

Guest
idp:/usr/local/psa/bin # ./domain.sh -r coijak.pl
ERROR: PleskFatalException
Dashboard preset used by user failed: DashboardPreset: unable to select: no such row in the table

0: /usr/local/psa/admin/plib/class.PhDomain.php:424
PhDomain->reset(integer '0', boolean true, boolean false)
1: /usr/local/psa/admin/plib/class.BsDomain.php:313
BsDomain->reset(integer '0')
2: /usr/local/psa/admin/plib/class.BsDomain.php:307
BsDomain->delete(integer '0')
3: /usr/local/psa/admin/plib/class.BsDomain.php:540
mdeleteDomains(array)
4: /usr/local/psa/admin/plib/class.Manager.php:352
Manager->removeDomains(array)
5: /usr/local/psa/admin/plib/api-common/cuDomain.php:1667
cuDomain->cmdRemove(string 'coijak.pl')
6: /usr/local/psa/admin/plib/api-common/cuDomain.php:649
cuDomain->cuDomain()
7: /usr/local/psa/admin/plib/api-cli/domain.php:24


Can`t delete this domain... how to resolve this problem?
 
Hello,

I've similar problem any help is really welcome. Here's my error:

0: /usr/local/psa/admin/plib/class.PhDomain.php:424
PhDomain->reset(integer '0', boolean true, boolean false)
1: /usr/local/psa/admin/plib/class.BsDomain.php:313
BsDomain->reset(integer '0')
2: /usr/local/psa/admin/plib/class.BsDomain.php:307
BsDomain->delete(integer '0')
3: /usr/local/psa/admin/plib/class.BsDomain.php:540
mdeleteDomains(array)
4: /usr/local/psa/admin/plib/class.Manager.php:352
Manager->removeDomains(array)
5: /usr/local/psa/admin/htdocs/domains/removeDomains.php3:50
 
Originally posted by Q6511200
idp:/usr/local/psa/bin # ./domain.sh -r coijak.pl
ERROR: PleskFatalException
Dashboard preset used by user failed: DashboardPreset: unable to select: no such row in the table

0: /usr/local/psa/admin/plib/class.PhDomain.php:424
PhDomain->reset(integer '0', boolean true, boolean false)
1: /usr/local/psa/admin/plib/class.BsDomain.php:313
BsDomain->reset(integer '0')
2: /usr/local/psa/admin/plib/class.BsDomain.php:307
BsDomain->delete(integer '0')
3: /usr/local/psa/admin/plib/class.BsDomain.php:540
mdeleteDomains(array)
4: /usr/local/psa/admin/plib/class.Manager.php:352
Manager->removeDomains(array)
5: /usr/local/psa/admin/plib/api-common/cuDomain.php:1667
cuDomain->cmdRemove(string 'coijak.pl')
6: /usr/local/psa/admin/plib/api-common/cuDomain.php:649
cuDomain->cuDomain()
7: /usr/local/psa/admin/plib/api-cli/domain.php:24


Can`t delete this domain... how to resolve this problem?
Click to expand...


Such error means that a domain has reference to custom dashboard presets that really does not exist.

You can find this domain using this query:
select d.name,d.id, dp.param, dp.val, P.id from domains d, dom_param dp left join DashboardPreset P on P.id=dp.val where dp.param='custom_preset_id' and d.id=dp.dom_id and P.id is NULL;

Let's say you got such result:

+----------------+---------------+----------------------+------+------+
| name | id | param | val | id |
+----------------+---------------+----------------------+------+------+
| domain.tld | 7 | custom_preset_id | 81 | NULL |
+----------------+---------------+----------------------+------+------+

Then remove references to non-existing presets from dom_param for thisdomain, for example:

mysql> delete from dom_param where dom_id=7 and param='custom_preset_id'

Do not forget to create a dump of psa database before doing this ;)
Hope this helps.
 
Great! But how to get into mysql? What is the user/pass/db_name?
 
Originally posted by Q6511200
Great! But how to get into mysql? What is the user/pass/db_name?
Click to expand...

In order to access Plesk database via MySQL, please, run the following command:

#mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
 
Unable to init SSLCertificate object: SSLCertificate: unable to select: no such row in the table

0: /usr/local/psa/admin/plib/class.PhDomain.php:216
PhDomain->reset_certificates(boolean true)
1: /usr/local/psa/admin/plib/class.PhDomain.php:432
PhDomain->reset(integer '0', boolean true, boolean false)
2: /usr/local/psa/admin/plib/class.BsDomain.php:313
BsDomain->reset(integer '0')
3: /usr/local/psa/admin/plib/class.BsDomain.php:307
BsDomain->delete(integer '0')
4: /usr/local/psa/admin/plib/class.BsDomain.php:540
mdeleteDomains(array)
5: /usr/local/psa/admin/plib/class.Manager.php:352
Manager->removeDomains(array)
6: /usr/local/psa/admin/htdocs/domains/removeDomains.php3:52

I get error like this now.
Can You help me to fix this?

I think that mysql db has broken somehow.. but don`t know how.
 
Q6511200: SSL certificate has been lost from psa.certificates table while some object is still referring to it. Usually, only domains and IP addresses referring to psa.certificates. Use these queries to find out what object is referring to lost certificate:

select ip.id, ip.ip_address, ip.ssl_certificate_id, c.id from IP_Addresses ip left join certificates c on c.id=ip.ssl_certificate_id where c.id is NULL;

You need to update ssl_certificate_id column of every found in psa.IP_Addresses record with id of existing certificate.

select d.id, d.name, R.rep_id, R.component_id, c.id from domains d, Repository R left join certificates c on c.id=R.component_id where d.cert_rep_id=R.rep_id and c.id is NULL;

Here, you need to update component_id column in Repository table with existing id of certificate for each pair of values (rep_id,component_id) found with this query.
 
Thanks for the help it helped for one domain but for another where there's no DashboardPreset Error it didn't. I still get the following after trying to delete it:

0: /usr/local/psa/admin/plib/class.PhDomain.php:424
PhDomain->reset(integer '0', boolean true, boolean false)
1: /usr/local/psa/admin/plib/class.BsDomain.php:313
BsDomain->reset(integer '0')
2: /usr/local/psa/admin/plib/class.BsDomain.php:307
BsDomain->delete(integer '0')
3: /usr/local/psa/admin/plib/class.BsDomain.php:540
mdeleteDomains(array)
4: /usr/local/psa/admin/plib/class.Manager.php:352
Manager->removeDomains(array)
5: /usr/local/psa/admin/htdocs/domains/removeDomains.php3:50

Any idea ?

Thanks
 
Hi;

I have a similar issue:

Unable to init SSLCertificate object: SSLCertificate: unable to select: no such row in the table

--------------------------------------------------------------------------------

0: /usr/local/psa/admin/plib/class.PhDomain.php:223
PhDomain->reset_certificates(boolean true)
1: /usr/local/psa/admin/plib/class.PhDomain.php:439
PhDomain->reset(integer '0', boolean true, boolean false)
2: /usr/local/psa/admin/plib/class.BsDomain.php:307
BsDomain->reset(integer '0')
3: /usr/local/psa/admin/plib/class.BsDomain.php:301
BsDomain->delete(integer '0')
4: /usr/local/psa/admin/plib/class.BsDomain.php:541
mdeleteDomains(array)
5: /usr/local/psa/admin/plib/class.Manager.php:352
Manager->removeDomains(array)
6: /usr/local/psa/admin/htdocs/domains/removeDomains.php3:44

If I run the following commands I get an "Empty set (0.00 sec)"

select d.name,d.id, dp.param, dp.val, P.id from domains d, dom_param dp left join DashboardPreset P on P.id=dp.val where dp.param='custom_preset_id' and d.id=dp.dom_id and P.id is NULL;

or

select ip.id, ip.ip_address, ip.ssl_certificate_id, c.id from IP_Addresses ip left join certificates c on c.id=ip.ssl_certificate_id where c.id is NULL;

but when I run

select d.id, d.name, R.rep_id, R.component_id, c.id from domains d, Repository R left join certificates c on c.id=R.component_id where d.cert_rep_id=R.rep_id and c.id is NULL;

I get this

mysql> select d.id, d.name, R.rep_id, R.component_id, c.id from domains d, Repository R left join certificates c on c.id=R.component_id where d.cert_rep_id=R.rep_id and c.id is NULL;
+----+-------------------+--------+--------------+------+
| id | name | rep_id | component_id | id |
+----+-------------------+--------+--------------+------+
| 10 | oilsonline.com | 7 | 2 | NULL |
| 13 | tisserandshop.com | 7 | 2 | NULL |
+----+-------------------+--------+--------------+------+
2 rows in set (0.00 sec)

I am trying to completely remove the tisserandshop.com domain but it will not let me and I do not know the syntax to "UPDATE" can you help.
 
Hi,

I had a same problem with ssl error while erasing domain. mysql query noted above given me null output, so I checked db psa and here is solution that worked for me:

- use db psa
- navigate to table "domains"
- find domain record you want to erase
- set cert_rep_id to NULL value

after these 4 steps I was able to delete domain without any error...
 
I need to be able to edit my post the owner of the domains identified in my post has insisted they be removed from this forum post can someone help me edit my post
 
Please reply this is an urgent legal issue

Forum Administrator

Please reply as this is an urgent legal matter and the following domain names must be edited or removed from the post on your forum.

+----+-------------------+--------+--------------+------+
| id | name | rep_id | component_id | id |
+----+-------------------+--------+--------------+------+
| 10 | domaina.com | 7 | 2 | NULL |
| 13 | domainb.com | 7 | 2 | NULL |
+----+-------------------+--------+--------------+------+

Please reply or just edit the record for me.
 
I just wanted to reply that this is in fact the answer - I ran into the same problem today and used these steps to fix.

go into the server via SSH and enter MySQL

mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa
Click to expand...

Then use the query to find the domain name that is bad

Code: 
SELECT d.id,
       d.name,
       R.rep_id,
       R.component_id,
       c.id
FROM   domains d,
       repository R
       LEFT JOIN certificates c
              ON c.id = R.component_id
WHERE  d.cert_rep_id = R.rep_id
       AND c.id IS NULL;

The response will look something like this, although exact result of yours will be a little different
+-----+-------------+--------+--------------+------+
| id | name | rep_id | component_id | id |
+-----+-------------+--------+--------------+------+
| 505 | domain.com | 27 | 16 | NULL |
| 505 | domain.com | 27 | 25 | NULL |
+-----+-------------+--------+--------------+------+
2 rows in set (0.00 sec)
Click to expand...

Then update the database and you can then remove the domain
update domains set cert_rep_id = NULL where id=505;
Click to expand...
 
You must log in or register to reply here.

Similar threads

M
Issue File dump-header not found on first position in archive.
Replies
0
Views
762
massin
M
nethubonline
Resolved Plesk install failure on AlmaLinux 9
Replies
3
Views
1K
nethubonline
nethubonline
R
Issue Plesk Extension.... 'Transfer of DNS Records'
Replies
4
Views
854
Rob Taylor
R
R
Forwarded to devs Plesk Extension 'Transfer of DNS Records' Not Functioning
Replies
7
Views
2K
Robert Alexander
R
M
Question Unable to install Joomla using APS
Replies
1
Views
931
peon
peon
Back
Top