Problem adding KB Category - Can't execute SQL
Posted: Fri Aug 14, 2009 6:23 pm
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)."')";
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)."')";