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

Error after mysql upgrade

Discussion in 'Plesk for Linux - 8.x and Older' started by Larkspeed, Apr 9, 2007.

  1. Larkspeed

    Larkspeed Guest

    I recently upgraded our server to mysql 5 and thought everything was fine until I tried to login to the plesk 8.0 panel.

    At that point I recieved this error:

    MySQL query failed: Unknown column 'd.id' in 'on clause'

    0: /usr/local/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.cl_id=5 and (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: /usr/local/psa/admin/plib/class.DomainsList.php3:264
    2: /usr/local/psa/admin/plib/class.cList.php3:100
    3: /usr/local/psa/admin/plib/class.cList.php3:120
    4: /usr/local/psa/admin/htdocs/domains/domains.php3:265

    So I thought ok i'll upgrade plesk but on running the autoinstaller it starts fine and then errors out with the following error:

    Reading system installed packages...done.
    Download file build-8.1.1-cos4.2-i386.hdr.gz: 16%..28%..39%..51%..62%..73%..85%..96%..100% done
    Download file update-8.1.1-cos4.2-i386.hdr.gz: 58%..100% done
    Resolve components
    ERROR: Package perl-HTML-Tree-1:1:3.16-cos4.build81070322.16.noarch listed in inf3 file, but not found in build headers (hdr.gz) file, possible versions mismatch.
    ERROR: Installation failed

    I realy need help in sorting this out as we need plesk back running