MySQL error during submit of ticket and add category
Posted: Wed Jul 12, 2006 4:32 pm
Script URL:
Version of script: 0.93.1
Version of PHP: 5.14
MySQL: 5.0.22
Hosting company: inhouse
Have you searched THIS FORUM for your problem:
(if not please do before posting)
If so, what terms did you try:
Write your message below:
The install goes well. I toggled the default settings in the config page to reflect our inhouse sites ets. Database connect works... when submitting ticket I get the following error:
Can't execute SQL: INSERT INTO `hesk_tickets` ( `id`,`trackid`,`name`,`email`,`category`,`priority`,`subject`,`message`,`dt`,`ip`,`status` ) VALUES ( '','1JQTDGZVL2','test','test@test.com','1','2','test','test',NOW(),'10.92.0.24','1' )
MySQL said:
Incorrect integer value: '' for column 'id' at row 1
Please notify webmaster at
----------
I am able to edit my profile info in admin like change password and email etc. I get the same error while trying to edit categories as well... this error on category...
Can't execute SQL: INSERT INTO `hesk_categories` (`id`,`name`) VALUES ('','test')
MySQL said:
Incorrect integer value: '' for column 'id' at row 1
Please notify webmaster at
Version of script: 0.93.1
Version of PHP: 5.14
MySQL: 5.0.22
Hosting company: inhouse
Have you searched THIS FORUM for your problem:
(if not please do before posting)
If so, what terms did you try:
Write your message below:
The install goes well. I toggled the default settings in the config page to reflect our inhouse sites ets. Database connect works... when submitting ticket I get the following error:
Can't execute SQL: INSERT INTO `hesk_tickets` ( `id`,`trackid`,`name`,`email`,`category`,`priority`,`subject`,`message`,`dt`,`ip`,`status` ) VALUES ( '','1JQTDGZVL2','test','test@test.com','1','2','test','test',NOW(),'10.92.0.24','1' )
MySQL said:
Incorrect integer value: '' for column 'id' at row 1
Please notify webmaster at
----------
I am able to edit my profile info in admin like change password and email etc. I get the same error while trying to edit categories as well... this error on category...
Can't execute SQL: INSERT INTO `hesk_categories` (`id`,`name`) VALUES ('','test')
MySQL said:
Incorrect integer value: '' for column 'id' at row 1
Please notify webmaster at