• 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

psa database problems after upgrading to 8.0

C

covici

Guest
Hi. I am running a Debian version of Plesk and after upgrading to 8.0 at least the domains and the general page all have this error and do not proceed.
ERROR: PleskMainDBException
MySQL query failed: Unknown column 'd.id' in 'on clause'
0: /opt/psa/admin/plib/common_func.php3:229
db_query(string 'select d.id from domains d, Limits l LEFT JOIN subdomains sd ON
sd.dom_id = d.id where (d.limits_id=l.id) and (l.limit_name='disk_space') and (l.value>=0)
and (d.real_size>l.value) GROUP BY d.id')
1: /opt/psa/admin/plib/class.DomainsList.php3:264
DomainsList->fetchDomainsList()
2: /opt/psa/admin/plib/class.cList.php3:100
cList->fetchList()
3: /opt/psa/admin/plib/class.cList.php3:120
cList->init()
4: /opt/psa/admin/htdocs/domains/domains.php3:265

Any assistance would be appreciated.
 
Originally posted by BoiseComputer
Any solution found for this problem?
No, I gave up on Plesk altogether -- tried to downgrade to 7.54
and it got very confused, so I do all things by hand and its working.
 
Back
Top