Error deleting domain

[Sys Av]

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

 

[Sys Av]

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

 

[Sys Av]

I have tried the ziba@' suggestion from this thread:
http://forum.parallels.com/showthread.php?t=78370

I got Empty set, no domain name returned..

Thank you

 

[ziba]

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.

 

[Sys Av]

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!

 

[nika]

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