Error When Trying to Delete Old Domain

[amandler]

When trying to delete an old domain by clicking on the Delete icon on its control panel, I get:

"Unable to delete hosting: SiteAppManager: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

0: /opt/psa/admin/htdocs/domains/hosting/phosting_setup.php:180"

And when trying to delete from the domain list by clicking the checkbox next to the domain and then "Remove Selected", I get:

"Unable to remove hosting: SiteAppManager: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

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

I was able to create, and then delete, a new domain without incident. I can also delete SOME old domains. Two, so far, produce these errors. Only recent event is that I just changed the admin password.

Thanks for your help.

 

[blank_page]

Hi,

my huntch , you have upgraded probably mysql from 4 to 5.
I would try to modify the appropriate mysql entry in the psa database and then delete.

 

[amandler]

ongoing problem

I was never able to resolve this problem. I can't figure out what is wrong with the domain database entry. Anyone else seen this?