forums.smartfoxserver.com

Posted: **17 Feb 2011, 07:31**

Hi,

I don't know what's wrong with the dbmanager. Sometimes it works and then this error:

011/02/16 23:56:21.394 - [ SEVERE ] [id: 43] (DbManager.executeCommand): DbManager error during command execution: INSERT INTO tblchatlog (chat_id, user_id, user_name, roomname, room_id, message, chat_date) VALUES(NULL, '10676', 'MODZone',  'Sqwungle', '15', 'I haven't seen you on kerrobi for a while', '1297918581')

Hope you can help me figure it out.

smartfoxserver Pro ver. 1.6.6
LINUX
VM TOTAL memory 530+MB
com.mysql.jdbc.Driver

Posted: **17 Feb 2011, 07:51**

It could be caused by your database design, where it does not accept a NULL value (for chat_id), or that a duplicate value is not allowed.

Check your database design against each value specified in the error.

Posted: **17 Feb 2011, 08:35**

thanks.

I'll try not to include the null value because the primary id is in auto increment so it's ok not to include that value.

I'll test this.