Problem adding KB Category - Can't execute SQL

[jonibuttke]

Script URL:
Version of script:2.1
Hosting company:Hostik
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:Can't execute SQL, kb-categories

Write your message below:
After upgrading to HESK 2.1 over mySQL5.1 we were having trouble adding new Knowledgebase Categories.

Seems like we had to explicitly code a value of "0" for the number of articles in a new KB Category:

$sql = "INSERT INTO `".hesk_dbEscape($hesk_settings['db_pfix'])."kb_categories` (`name`,`parent`,`articles`,`cat_order`,`type`) VALUES ('".hesk_dbEscape($title)."','".hesk_dbEscape($parent)."','0','".hesk_dbEscape($my_order)."','".hesk_dbEscape($type)."')";

[Klemen]

I didn't get any such errors when testing with MySQL 5.1(.30, .33 and .36), but thanks for sharing, I will modify the file to make sure others don't have similar problems.