Page 1 of 1

Error adding knowledge base category

Posted: Tue Oct 28, 2014 5:14 pm
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.

Re: Error adding knowledge base category

Posted: Tue Oct 28, 2014 6:49 pm
by Klemen
Turn "Debug mode" to ON in Settings > Help desk tab then try again and see what error message do you get?

Re: Error adding knowledge base category

Posted: Tue Oct 28, 2014 7:33 pm
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

Re: Error adding knowledge base category

Posted: Wed Oct 29, 2014 10:26 am
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?