Ad Widget

Collapse

ERROR: column "web.latest.toggle_other" does not exist

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hundux
    Junior Member
    • Feb 2013
    • 9

    #1

    ERROR: column "web.latest.toggle_other" does not exist

    I get the following error, when trying to delete an autodiscovered host.
    Zabbix version is 2.1.0-33994, database was upgraded from 2.0.5


    Deleted: Item "Memory total-available" on "xxx.yyy.com".
    Deleted: Host "xxx.yyy.com".
    pg_query(): Query failed: ERROR: column "web.latest.toggle_other" does not exist
    LINE 1: DELETE FROM profiles WHERE idx="web.latest.toggle_other" AND...
    ^ [hosts.php:529 → CAPIObject->delete() → CAPIObject->__call() → czbxrpc::call() → czbxrpc::callAPI() → call_user_func() → CHost->delete() → CProfile::delete() → DBexecute() → pg_query() in /opt/zabbix_frontend/php_2.1.0-33994/include/db.inc.php:512]
    Error in query [DELETE FROM profiles WHERE idx="web.latest.toggle_other" AND idx2='10134'] [ERROR: column "web.latest.toggle_other" does not exist
    LINE 1: DELETE FROM profiles WHERE idx="web.latest.toggle_other" AND...
    ^]
  • hundux
    Junior Member
    • Feb 2013
    • 9

    #2
    The query should probably use single quotes instead of double:

    DELETE FROM profiles WHERE idx='web.latest.toggle_other' AND idx2='10134'

    instead of

    DELETE FROM profiles WHERE idx="web.latest.toggle_other" AND idx2='10134'

    How this can be changed?

    Comment

    Working...