Ad Widget

Collapse

Unknown column 'status' in 'proxy_history'

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bcnx
    Junior Member
    • Jan 2011
    • 19

    #1

    Unknown column 'status' in 'proxy_history'

    Hi,

    we are way behind with our upgrade, so I am currently upgrading 2.0 to 2.2, in order to then upgrade to 3.4
    The database upgrade fails however. With debugging on we get:

    query failed: [1054] Unknown column 'status' in 'proxy_history' [alter table proxy_history change column status state integer default '0' not null]

    I am using version 2.2.21
    Zabbix seems to be expecting a column I don't have.
    How do I best proceed from this?

    Cheers,

    BC
  • bcnx
    Junior Member
    • Jan 2011
    • 19

    #2
    Hi,

    I fixed this by launching this SQL statement:

    ALTER TABLE proxy_history ADD status integer DEFAULT '0' NOT NULL;
    Last edited by bcnx; 21-04-2018, 00:55.

    Comment

    Working...