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 Upgrade

Discussion in 'Plesk Expand 2.1 Troubleshooting Issues' started by resellertr, Aug 3, 2007.

  1. resellertr

    resellertr Regular Pleskian

    25
    57%
    Joined:
    Jul 14, 2004
    Messages:
    133
    Likes Received:
    0
    Hi,

    Today I upgraded from 2.1 to 2.2, on Central DNS I get this error.



    Error Unable to query the database: Unknown column 'dns.status' in 'where clause'. SQL: SELECT COUNT(dns.id) FROM dns_server AS dns LEFT JOIN dns_slave_server_repository AS sr ON sr.slave_dns_id = dns.id WHERE dns.status <> 'ok' GROUP BY sr.dns_id HAVING COUNT(sr.dns_id) = 0
    Please see more details in the Problem Report ('report-Aug032007-125009.log'):

    ----------- HEADER ---
    Report fullname: /usr/local/expand/var/log/problem_report/report-Aug032007-125009.log
    Report datetime: Aug 03 2007 12:50:09

    Product: PLESK EXPAND
    Version: 2.2.0.46

    User ID: 1
    User Role: sadmin

    ----------- CALL STACK ---
    [call #9] CoreApp->system_die(Unable to query the database: Unknown column 'dns.status' in 'where clause'. SQL: SELECT COUNT(dns.id) FROM dns_server AS dns LEFT JOIN dns_slave_server_repository AS sr ON sr.slave_dns_id = dns.id WHERE dns.status <> 'ok' GROUP BY sr.dns_id HAVING COUNT(sr.dns_id) = 0);
    called at [/usr/local/expand/frontend/plib/CoreApp.php:862]

    [call #8] CoreApp->app_die(Unable to query the database: Unknown column 'dns.status' in 'where clause'. SQL: SELECT COUNT(dns.id) FROM dns_server AS dns LEFT JOIN dns_slave_server_repository AS sr ON sr.slave_dns_id = dns.id WHERE dns.status <> 'ok' GROUP BY sr.dns_id HAVING COUNT(sr.dns_id) = 0);
    called at [/usr/local/expand/frontend/plib/CoreApp.php:743]

    [call #7] CoreApp->db_query(SELECT COUNT(dns.id) FROM dns_server AS dns LEFT JOIN dns_slave_server_repository AS sr ON sr.slave_dns_id = dns.id WHERE dns.status <> 'ok' GROUP BY sr.dns_id HAVING COUNT(sr.dns_id) = 0);
    called at [/usr/local/expand/frontend/plib/CoreApp.php:758]

    [call #6] CoreApp->db_query_value(SELECT COUNT(dns.id) FROM dns_server AS dns LEFT JOIN dns_slave_server_repository AS sr ON sr.slave_dns_id = dns.id WHERE dns.status <> 'ok' GROUP BY sr.dns_id HAVING COUNT(sr.dns_id) = 0);
    called at [/usr/local/expand/frontend/plib/CoreLib.php:225]

    [call #5] db_query_value(SELECT COUNT(dns.id) FROM dns_server AS dns LEFT JOIN dns_slave_server_repository AS sr ON sr.slave_dns_id = dns.id WHERE dns.status <> 'ok' GROUP BY sr.dns_id HAVING COUNT(sr.dns_id) = 0);
    called at [/usr/local/expand/frontend/plib/uiclasses/info/plesk/dns/Stats.php:59]

    [call #4] Info_Plesk_Dns_Stats->_load_stats();
    called at [/usr/local/expand/frontend/plib/uiclasses/info/plesk/dns/Stats.php:20]

    [call #3] Info_Plesk_Dns_Stats->Info_Plesk_Dns_Stats(, );
    called at [/usr/local/expand/frontend/plib/uiclasses/screen/plesk/dns/server/List.php:161]

    [call #2] Screen_Plesk_Dns_Server_List->_draw();
    called at [/usr/local/expand/frontend/plib/uiclasses/screen/plesk/dns/server/List.php:64]

    [call #1] Screen_Plesk_Dns_Server_List->Screen_Plesk_Dns_Server_List(array(screen_id => 12.00.01, screen_title => Centralized DNS));
    called at [/usr/local/expand/frontend/htdocs/plesk/dns_servers.php:38]

    ----------- SERVER ARGUMENTS ---
    [PHP_FCGI_CHILDREN] => 1
    [FCGI_ROLE] => RESPONDER
    [SERVER_SOFTWARE] => sw-cp-server/1.0.0
    [SERVER_NAME] => expandserver.com:8442
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PORT] => 8442
    [SERVER_ADDR] => 77.92.140.12
    [REMOTE_PORT] => 4850
    [REMOTE_ADDR] => MyIP
    [SCRIPT_NAME] => /plesk/dns_servers.php
    [PATH_INFO] =>
    [SCRIPT_FILENAME] => /usr/local/expand/frontend/htdocs/plesk/dns_servers.php
    [DOCUMENT_ROOT] => /usr/local/expand/frontend/htdocs/
    [REQUEST_URI] => /plesk/dns_servers.php?start_path=1
    [QUERY_STRING] => start_path=1
    [REQUEST_METHOD] => GET
    [REDIRECT_STATUS] => 200
    [SERVER_PROTOCOL] => HTTP/1.1
    [HTTPS] => on
    [HTTP_HOST] => expandserver.com:8442
    [HTTP_USER_AGENT] => Mozilla/5.0 (Windows; U; Windows NT 5.1; tr; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
    [HTTP_ACCEPT] => text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    [HTTP_ACCEPT_LANGUAGE] => tr-TR,tr;q=0.8,en-us;q=0.5,en;q=0.3
    [HTTP_ACCEPT_ENCODING] => gzip,deflate
    [HTTP_ACCEPT_CHARSET] => ISO-8859-9,utf-8;q=0.7,*;q=0.7
    [HTTP_KEEP_ALIVE] => 300
    [HTTP_CONNECTION] => keep-alive
    [HTTP_REFERER] => https://expandserver.com:8442/exp/menu.php?release=22046
    [HTTP_COOKIE] => EXPANDSID=db2c40b9f10b62714833a92e3ecfaf15
    [ORIG_PATH_INFO] =>
    [PHP_SELF] => /plesk/dns_servers.php
    [REQUEST_TIME] => 1186134609
    [argv] => array(
    [0] => start_path=1
    )
    [argc] => 1


    ----------- REQUEST PARAMETERS [GET] ---
    [start_path] => 1


    ----------- REQUEST PARAMETERS [POST] ---
    None

    ----------- DEBUG LOG ---
    [Aug 03 2007 12:50:09] [debug] [MyIP] [SQL] SELECT enabled FROM exp_person WHERE id =1
    [Aug 03 2007 12:50:09] [debug] [MyIP] [SQL] SELECT codename FROM exp_priv_category
    [Aug 03 2007 12:50:09] [debug] [MyIP] [SQL] SELECT codename FROM exp_priv_obj_class
    [Aug 03 2007 12:50:09] [debug] [MyIP] [SQL] SELECT obj.codename AS obj_name, pr.codename AS property FROM exp_priv_properties pr LEFT JOIN exp_priv_obj_class obj ON pr.object_id = obj.id
    [Aug 03 2007 12:50:09] [debug] [MyIP] [SQL] SELECT obj.codename AS obj_name, act.codename AS act_name FROM exp_priv_methods act LEFT JOIN exp_priv_obj_class obj ON act.object_id = obj.id
    [Aug 03 2007 12:50:09] [debug] [MyIP] [SQL] SELECT * FROM exp_person_object_right p_obj WHERE p_obj.person_id = 1
    [Aug 03 2007 12:50:09] [debug] [MyIP] [SQL] SELECT * FROM exp_button_custom_handler WHERE screen_id = '03.00.01'
    [Aug 03 2007 12:50:09] [debug] [MyIP] [SQL] SELECT COUNT(dns.id) FROM dns_server AS dns LEFT JOIN dns_slave_server_repository AS sr ON sr.slave_dns_id = dns.id GROUP BY sr.dns_id HAVING COUNT(sr.dns_id) = 0
    [Aug 03 2007 12:50:09] [debug] [MyIP] [SQL] SELECT COUNT(dns.id) FROM dns_server AS dns LEFT JOIN dns_slave_server_repository AS sr ON sr.slave_dns_id = dns.id WHERE dns.status <> 'ok' GROUP BY sr.dns_id HAVING COUNT(sr.dns_id) = 0
    [Aug 03 2007 12:50:09] [error] [MyIP] Unable to query the database: Unknown column 'dns.status' in 'where clause'. SQL: SELECT COUNT(dns.id) FROM dns_server AS dns LEFT JOIN dns_slave_server_repository AS sr ON sr.slave_dns_id = dns.id WHERE dns.status <> 'ok' GROUP BY sr.dns_id HAVING COUNT(sr.dns_id) = 0

    ----------- END ---
     
  2. regx

    regx Guest

    0
     
    Seems like the database wasn't upgraded completely. Couldn't it be a result of SELinux problems you've descibed in other topic?

    Try looking at
    /usr/local/expand/var/log/update.log file. It keeps history and log messages of all updates performed.

    What version did you upgrade from? I did not see such problem during upgrade- probably it depends on MySQL version used?
     
  3. resellertr

    resellertr Regular Pleskian

    25
    57%
    Joined:
    Jul 14, 2004
    Messages:
    133
    Likes Received:
    0
    Hi,

    It wasn't Selinux problem. OS was Cent OS 4.5 and Expand 2.1. Selinux was disabled.

    I think Expand 2.2 has big problems on setup/upgrade.
     
Loading...