CREATE TABLE idps (
    uid integer NOT NULL,
    idp_type character(3) NOT NULL,
    idp_id integer NOT NULL,
    idp_calc character varying(12) NOT NULL,
    idp_status integer DEFAULT 0 NOT NULL,
    created_date timestamp without time zone DEFAULT '2000-01-01 00:00:00'::timestamp without time zone NOT NULL,
    created_user character varying(16) DEFAULT 'SYSTEM'::character varying NOT NULL,
    revised_date timestamp without time zone,
    revised_user character varying(16)
);

CREATE SEQUENCE idps_uid_seq    START WITH 1    INCREMENT BY 1    NO MINVALUE    NO MAXVALUE    CACHE 1;
ALTER TABLE ONLY idps ALTER COLUMN uid SET DEFAULT nextval('idps_uid_seq'::regclass);
ALTER TABLE ONLY idps    ADD CONSTRAINT idps_pkey PRIMARY KEY (idp_type, idp_id);
ALTER TABLE ONLY idps    ADD CONSTRAINT idps_uid_key UNIQUE (uid);
ALTER TABLE ONLY idps ADD CONSTRAINT idps_idp_type_fkey FOREIGN KEY (idp_type) REFERENCES idp_types(idp_type);

Fatal Error: PostgreSQL: ERROR: 22P02: invalid input syntax for integer: "" LINE 1: SELECT count(*) FROM idps WHERE uid='' ^ LOCATION: pg_atoi, numutils.c:52
SQL query: SELECT count(*) FROM idps WHERE uid=''
Error in line 578 of file 'C:\xampp\radicore\includes\dml.pgsql.class.inc'.

2015-07-22 00:59:21
Fatal Error: PostgreSQL: ERROR: 22P02: invalid input syntax for integer: "" LINE 1: SELECT count(*) FROM idps WHERE uid='' ^ LOCATION: pg_atoi, numutils.c:52
SQL query: SELECT count(*) FROM idps WHERE uid=''
Error in line 578 of file 'C:\xampp\radicore\includes\dml.pgsql.class.inc'.

Host Info: idp-etl2.eng.sonicwall.com, Server Version: 9.3.6
Client Encoding: UTF8, Server Encoding: UTF8
Database: NSDB2, Schema: "NSDB2", PUBLIC

PHP_SELF: /radicore/nsdb2/idps(add1).php

CURRENT DIRECTORY: C:\xampp\htdocs\radicore\nsdb2

SERVER_ADDR: 10.204.23.21

User Id: MGR

Role Id: GLOBAL

REQUEST_URI: /radicore/nsdb2/idps(add1).php

Page Stack:

  [0] main_menu
  [1] nsdb2
  [2] nsdb2_idps(list1)
  [3] nsdb2_idps(add1)

Backtrace:

0: array =
  function: string = errorHandler
  args: array =
    0: integer = 256
    1: string = PostgreSQL: ERROR:  22P02: invalid input syntax for integer: ""
LINE 1: SELECT count(*) FROM idps WHERE uid=''
                                            ^
LOCATION:  pg_atoi, numutils.c:52
    2: string = C:\xampp\radicore\includes\dml.pgsql.class.inc
    3: integer = 578
    4: object = pgsql
1: array =
  file: string = C:\xampp\radicore\includes\dml.pgsql.class.inc
  line: integer = 578
  function: string = trigger_error
  args: array =
    0: string = PostgreSQL: ERROR:  22P02: invalid input syntax for integer: ""
LINE 1: SELECT count(*) FROM idps WHERE uid=''
                                            ^
LOCATION:  pg_atoi, numutils.c:52
    1: integer = 256
2: array =
  file: string = C:\xampp\radicore\includes\dml.pgsql.class.inc
  line: integer = 1040
  function: string = getCount
  class: string = pgsql
  type: string = ->
  args: array =
    0: string = nsdb2
    1: string = idps
    2: string = SELECT count(*) FROM idps WHERE uid=''
3: array =
  file: string = C:\xampp\radicore\includes\std.table.class.inc
  line: integer = 7653
  function: string = insertRecord
  class: string = pgsql
  type: string = ->
  args: array =
    0: string = nsdb2
    1: string = idps
    2: array =
      uid: string = null
      idp_type: string = idp
      idp_id: string = 1
      idp_calc: string = idp:1
      idp_status: string = 0
      created_date: string = 2000-01-01 00:00:00
      created_user: string = SYSTEM
      revised_date: string = null
      revised_user: string = null
4: array =
  file: string = C:\xampp\radicore\includes\std.table.class.inc
  line: integer = 4180
  function: string = _dml_insertRecord
  class: string = Default_Table
  type: string = ->
  args: array =
    0: array =
      uid: string = null
      idp_type: string = idp
      idp_id: string = 1
      idp_calc: string = idp:1
      idp_status: string = 0
      created_date: string = 2000-01-01 00:00:00
      created_user: string = SYSTEM
      revised_date: string = null
      revised_user: string = null
5: array =
  file: string = C:\xampp\radicore\includes\std.add1.inc
  line: integer = 104
  function: string = insertRecord
  class: string = Default_Table
  type: string = ->
  args: array =
    0: array =
      uid: string = null
      idp_type: string = idp
      idp_id: string = 1
      idp_calc: string = idp:1
      idp_status: string = 0
      created_date: string = 2000-01-01 00:00:00
      created_user: string = SYSTEM
      revised_date: string = 
      revised_user: string = 
6: array =
  file: string = C:\xampp\htdocs\radicore\nsdb2\idps(add1).php
  line: integer = 9
  args: array =
    0: string = C:\xampp\radicore\includes\std.add1.inc
  function: string = require