1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

psa database problems after upgrading to 8.0

Discussion in 'Plesk for Linux - 8.x and Older' started by covici, May 22, 2006.

  1. covici

    covici Guest

    0
     
    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.
     
  2. BoiseComputer

    BoiseComputer Regular Pleskian

    28
    23%
    Joined:
    Apr 14, 2006
    Messages:
    143
    Likes Received:
    5
    Location:
    Boise, Idaho
    Any solution found for this problem?
     
  3. covici

    covici Guest

    0
     
    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.
     
Loading...