XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.9.2 (alpha)
    • 1.9.2 (alpha)
    • Frontend (F)
    • None

    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

      Attachments

        Activity

          People

            Unassigned Unassigned
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: