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.
Error adding knowledge base category
Moderator: mkoch227
Re: Error adding knowledge base category
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 
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


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
Re: Error adding knowledge base category
Can't execute SQL: INSERT INTO `hesk_kb_categories` (`name`,`parent`,`cat_order`,`type`) VALUES ('Test Category','1','100','0')Klemen wrote:Turn "Debug mode" to ON in Settings > Help desk tab then try again and see what error message do you get?
MySQL said:
Field 'articles' doesn't have a default value
Re: Error adding knowledge base category
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?
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 
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


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