Package: smbind
Version: 0.4.7-3
Severity: important
Hi, I just installed smbind and select postgresql as database backend.
Now, when I load url http://localhost/smbind/src/configtest.php, I get
this output:
[...]
Testing database INSERT into zones table...OK Testing database INSERT
into users table...OK Testing database INSERT into records table...DB
Error: null value violates not-null constraint
This is probably because the statement "INSERT INTO records (host)
VALUES ('test567')" is using a table with many required and unspecified
fields:
smbind=> \d records;
Tabella "public.records"
Colonna | Tipo |
Modificatori
-------------+-------------------+------------------------------------------------------
id | integer | not null default
nextval('records_id_seq'::regclass)
zone | integer | not null default 0
host | character varying | not null
type | character varying | not null
pri | integer | not null default 0
destination | character varying | not null
valid | character varying | not null default 'unknown'::character
varying
Indici:
"records_id_key" UNIQUE, btree (id)
So, in your statement, you should also specify "type" and "destination"
required and not null fields.
Bye,
Giuseppe
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
