Error adding knowledge base category

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
spamking
Posts: 9
Joined: Mon Mar 14, 2011 8:27 pm

Error adding knowledge base category

Post by spamking »

Hesk version: 2.5.5
PHP version: 5.4.14
MySQL version: 5.1.72

Write your message below:

Receiving the can't execute SQL error when attempting to add a new knowledge base category. It doesn't matter whether it is a private or public category.

Creating a new article works fine.

I can manually create a category directly in the database and then edit the category name from the admin area on the help desk application.
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: Error adding knowledge base category

Post by Klemen »

Turn "Debug mode" to ON in Settings > Help desk tab then try again and see what error message do you get?
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
spamking
Posts: 9
Joined: Mon Mar 14, 2011 8:27 pm

Re: Error adding knowledge base category

Post by spamking »

Klemen wrote:Turn "Debug mode" to ON in Settings > Help desk tab then try again and see what error message do you get?
Can't execute SQL: INSERT INTO `hesk_kb_categories` (`name`,`parent`,`cat_order`,`type`) VALUES ('Test Category','1','100','0')

MySQL said:
Field 'articles' doesn't have a default value
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: Error adding knowledge base category

Post by Klemen »

Your database isn't properly setup.

Did you run the "update" script when updating your help desk to version 2.5.x as explained in docs?
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