Ad Widget

Collapse

INSERT has more expressions than target columns

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jbecker
    Junior Member
    • Jul 2014
    • 2

    #1

    INSERT has more expressions than target columns

    I've encountered some strange issues with graph prototypes lately.
    I'm using Zabbix 4.0.24 at the moment andi see the following erros in the server log:

    Code:
    [FONT=monospace][COLOR=#000000]4743:20201113:111414.877 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  INSERT has more expressions than target columns [/COLOR]
    LINE 1: ...0,000000,100,000000,0,0,0,1,0,0,000000,0,000000 ,0,null,0,nul...
                                                                ^
    [insert into graphs (graphid,name,width,height,yaxismin,yaxismax,show_ work_period,show_triggers,graphtype,show_legend,sh ow_3d,percent_left,percent_right,ymin_type,ymin_it emid,ymax_type,ymax_itemid,flags) values (7835,'Disk space usage /',600,340,0,000000,100,0000
    00,0,0,0,1,0,0,000000,0,000000,0,null,0,null,4),(7 836,'Disk space usage /opt',600,340,0,000000,100,000000,0,0,0,1,0,0,00000 0,0,000000,0,null,0,null,4),(7837,'Disk space usage /var',600,340,0,000000,100,000000,0,0,0,1,0,0,00000 0,0,000000,0,null,0,null,4),(7838,'Dis
    k space usage /home',600,340,0,000000,100,000000,0,0,0,1,0,0,0000 00,0,000000,0,null,0,null,4),(7839,'Disk space usage /srv',600,340,0,000000,100,000000,0,0,0,1,0,0,00000 0,0,000000,0,null,0,null,4);[/FONT]
    I've checked the prototypes and even exported the tempalte to ensure that the values are ok.
    It seems however the ymin , ymax as well as the percent_left and percent_right values are inserted as "100,0" insted of "100.0" . Strangly however the prototypes of the template have the right values in the graphs table.

    Can someone mybe give me a hint where the ssystem ist going wrong here.
    A manual created graph shows no issues.

    Kind regards
    Jacob
Working...