GIVES AN '' value insteath of NULL for the ID in plugins

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
robbrecht
Posts: 1
Joined: Thu Jul 16, 2009 6:54 am
Location: Belgium

GIVES AN '' value insteath of NULL for the ID in plugins

Post by robbrecht »

Whe i want to add anything (thold, manage plugin, mactrack) it allways results in the same error:

MESSAGE IN SQL incorrect interger value: ''for comumn 'id' at row 1

HE GIVES AN '' value insteath of NULL for the ID.

07/16/2009 01:56:53 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1366', SQL:"INSERT INTO manage_groups ( id , name , site_id) VALUES ('', 'FACTORY', '1')'
07/16/2009 01:56:53 PM - CMDPHP: Poller[0] DEVEL: SQL Exec: "INSERT INTO manage_groups ( id , name , site_id) VALUES ('', 'FACTORY', '1')"

=> MESSAGE IN SQL incorrect interger value: ''for comumn 'id' at row 1
=> If i add in manualy

INSERT INTO manage_groups ( id , name , site_id) VALUES (NULL, 'FACTORY', '1')

it works
cigamit
Developer
Posts: 3372
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Post by cigamit »

Is your MySQL server running in STRICT mode?
Post Reply

Who is online

Users browsing this forum: No registered users and 28 guests