-
Incident report
-
Resolution: Fixed
-
Major
-
1.9.2 (alpha)
-
None
ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-01400: cannot insert NULL into ("ZABBIX"."USER_HISTORY"."TITLE1")[/var/www/zabbix/php/include/db.inc.php:530]
SQL error [ORA-01400: cannot insert NULL into ("ZABBIX"."USER_HISTORY"."TITLE1")] in [INSERT INTO user_history (userhistoryid, userid, title5, url5) VALUES(76, 1, 'S_DASHBOARD', 'dashboard.php')]
ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-01400: cannot insert NULL into ("ZABBIX"."PROFILES"."SOURCE")[/var/www/zabbix/php/include/db.inc.php:530]
SQL error [ORA-01400: cannot insert NULL into ("ZABBIX"."PROFILES"."SOURCE")] in [INSERT INTO profiles (profileid, userid, idx, value_str, type, idx2) VALUES (256, 1, 'web.menu.view.last', 'dashboard.php', 3, 0)]
ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-01400: cannot insert NULL into ("ZABBIX"."PROFILES"."SOURCE")[/var/www/zabbix/php/include/db.inc.php:530]
SQL error [ORA-01400: cannot insert NULL into ("ZABBIX"."PROFILES"."SOURCE")] in [INSERT INTO profiles (profileid, userid, idx, value_str, type, idx2) VALUES (257, 1, 'web.paging.lastpage', 'dashboard.php', 3, 0)]
but table:
CREATE TABLE ZABBIX.USER_HISTORY (
USERHISTORYID NUMBER(20) NOT NULL,
USERID NUMBER(20) NOT NULL,
TITLE1 VARCHAR2(255) DEFAULT '' NOT NULL,
URL1 VARCHAR2(255) DEFAULT '' NOT NULL,
TITLE2 VARCHAR2(255) DEFAULT '' NOT NULL,
URL2 VARCHAR2(255) DEFAULT '' NOT NULL,
TITLE3 VARCHAR2(255) DEFAULT '' NOT NULL,
URL3 VARCHAR2(255) DEFAULT '' NOT NULL,
TITLE4 VARCHAR2(255) DEFAULT '' NOT NULL,
URL4 VARCHAR2(255) DEFAULT '' NOT NULL,
TITLE5 VARCHAR2(255) DEFAULT '' NOT NULL,
URL5 VARCHAR2(255) DEFAULT '' NOT NULL,
PRIMARY KEY (USERHISTORYID)
);
seems troubles with export data for new installation zabbix trunk, many errors about ORA-01400