[ZBX-3570] Many queries errors Created: 2011 Feb 27  Updated: 2017 May 30  Resolved: 2011 Feb 27

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.2 (alpha)
Fix Version/s: 1.9.2 (alpha)

Type: Incident report Priority: Major
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

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



 Comments   
Comment by Alexey Pustovalov [ 2011 Feb 27 ]

my mistake... normal create schema and data

Generated at Thu Mar 20 00:02:48 EET 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.