• 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

Error deleting domain

S

Sys Av

Guest
Hello,
I have created a domain on Plesk, and tried to login as domain administrator..
I got a blank page when I login..
Then, I tried to remove the domain, so I can add it again.
I got this error:

ERROR: PleskFatalException
Up LevelUp Level
DomainUser::getAccount failed: Unable to create Account object: Account: unable to select:

no such row in the table

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


I did find out this article on the kb:

http://kb.odin.com/en/5493

First, hey don't say on the article what database to use..
I would guess is psa, but..
I am not very proficient with mysql, so everything that has to do with databases (and more, with plesk main database) kind of scares me :)

Then, they say is for version 8.1 up to 8.3
My server is 8.6 (on top of Suse 10.3), and there is my conundrum..Is there any change on the psa table structure from 8.3 to 8.6 that would screw the plesk database?
Can I apply the resolution from that article?

Thanks for any suggestion you might have.

Barasians
 
Last edited by a moderator:
Still error after applying resolution from article

I have followed the steps from the article above (did first a dump of the psa database)
No errors, but when I have logged back into Plesk and tried to delete the domain, I got this:

ERROR: PleskFatalException
Up LevelUp Level
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:430
PhDomain->reset(integer '0', boolean true, boolean false)
1: /usr/local/psa/admin/plib/class.BsDomain.php:307
BsDomain->reset(integer '0')
2: /usr/local/psa/admin/plib/class.BsDomain.php:301
BsDomain->delete(integer '0')
3: /usr/local/psa/admin/plib/class.BsDomain.php:541
mdeleteDomains(array)
4: /usr/local/psa/admin/plib/class.Manager.php:352
Manager->removeDomains(array)
5: /usr/local/psa/admin/htdocs/domains/removeDomains.php3:44


Ideas?

Thanks
 
Hi,

Try running the following query:
select preset_id from DashboardPresetConfig left join DashboardPreset on DashboardPresetConfig.preset_id=DashboardPreset.id where DashboardPreset.id is NULL group by preset_id;

and post here what you get as result.
 
I get empty set:
mysql> select preset_id from DashboardPresetConfig left join DashboardPreset on DashboardPresetConfig.preset_id=DashboardPreset.id where DashboardPreset.id is NULL group by preset_id;
Empty set (0.00 sec)

Thanks ziba!
 
try to run the following command:

mysql -uadmin -p`cat /etc/psa/.psa.shadow ` -D psa -e "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"

Then remove references to non-existing presets from dom_param, for example:
mysql> delete from dom_param where dom_id=xx and param='custom_preset_id'

where xx is id value from the output of previous command
 
Back
Top