MySQL error during submit of ticket and add category

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
adubas
Posts: 1
Joined: Wed Jul 12, 2006 4:13 pm

MySQL error during submit of ticket and add category

Post by adubas »

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
Klemen
Site Admin
Posts: 10139
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Post Reply