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

Plesk error after upgrading (mysql)

Discussion in 'Plesk for Linux - 8.x and Older' started by edvxpert, Mar 31, 2006.

  1. edvxpert

    edvxpert Guest

    0
     
    Hi,

    after upgrading to 8.0.0 I get the following error when selecting "Domains" in Plesk.

    ERROR: PleskMainDBException
    Add to favoritesAdd to favorites
    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.cl_id=15 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: /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

    Furthermore I get an error when selecting "modules":
    ERROR: PleskMainDBException
    Eine Ebene höherEine Ebene höher
    MySQL query failed: 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 'release, description, icon FROM Modules ORDER BY name' at line 1

    0: /opt/psa/admin/plib/common_func.php3:229
    db_query(string 'SELECT id, name, packname, display_name, version, release, description, icon FROM Modules ORDER BY name;')
    1: /opt/psa/admin/plib/modules/ModuleMaker.php:24
    getModules()
    2: /opt/psa/admin/htdocs/modules/modules.php:19

    What does that mean and how can I fix it?

    Thanks for your help.

    Christian
     
  2. BoiseComputer

    BoiseComputer Regular Pleskian

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