Can't execute SQL: INSERT INTO `hesk_kb_articles`

[killcount]

Script URL:
Version of script: 2.0
Hosting company: localhost IIS
URL of phpinfo.php: localhost
URL of session_test.php: localhost
What terms did you try when SEARCHING for a solution: save article, hesk_kb_articles,

Write your message below:

# Can't execute SQL: INSERT INTO `hesk_kb_articles` (`catid`,`dt`,`author`,`subject`,`content`,`type`,`html`,`art_order`,`history`) VALUES ('1',NOW(),'2','Tester','texts goes here!','0','1','10','On 02-05-2009 15:30 submitted by Mark Sarpy (Mark Sarpy)
')

MySQL said:
Field 'rating' doesn't have a default value

Please notify webmaster at

Everytime i try to save article i get that error. im running PHP 5.2.8 and mySQL server 5.0 if that matters.

[Klemen]

Can you check in phpMyAdmin what table types you have? Is MyISAM or InnoDB or some other?

[killcount]

Sure.

hesk_attachments
hesk_categories
hesk_kb_articles
-id
-catid
-dt
-author
-subject
-content
-rating
-votes
-views
-type
-html
-art_order
-history
hesk_kb_categories
hesk_notes
hesk_replies
hesk_std_replies
hesk_tickets
hesk_users


Is it something Im doing wrong?

[Klemen]

No, it's not something you are doing wrong I'm just trying to figure out why all these errors started.

Please go to your phpMyAdmin again and in the database structure (where all your tables in the database are listed) see what is says under "Type" for all your Hesk databases.

[killcount]

for type it says MyISAM.
i hope thats what your asking for.

[Klemen]

This should fix it:

Code: Select all

<?php 
define('IN_SCRIPT',1); 
define('HESK_PATH',''); 
require(HESK_PATH . 'hesk_settings.inc.php'); 
require(HESK_PATH . 'language/'.$hesk_settings['language'].'.inc.php'); 
require(HESK_PATH . 'inc/common.inc.php'); 
require(HESK_PATH . 'inc/database.inc.php'); 

hesk_dbConnect(); 

$sql = "ALTER TABLE `".$hesk_settings['db_pfix']."kb_articles` CHANGE `rating` `rating` FLOAT DEFAULT '0' "; 
hesk_dbQuery($sql); 
$sql = "ALTER TABLE `".$hesk_settings['db_pfix']."kb_articles` CHANGE `votes` `votes` MEDIUMINT(8) UNSIGNED  DEFAULT '0' "; 
hesk_dbQuery($sql); 
$sql = "ALTER TABLE `".$hesk_settings['db_pfix']."kb_articles` CHANGE `views` `views` MEDIUMINT(8) UNSIGNED  DEFAULT '0' "; 
hesk_dbQuery($sql); 
$sql = "ALTER TABLE `".$hesk_settings['db_pfix']."kb_articles` CHANGE `type` `type` ENUM('0','1','2') DEFAULT '0' "; 
hesk_dbQuery($sql); 
$sql = "ALTER TABLE `".$hesk_settings['db_pfix']."kb_articles` CHANGE `html` `html` ENUM('0','1') DEFAULT '0' "; 
hesk_dbQuery($sql); 
$sql = "ALTER TABLE `".$hesk_settings['db_pfix']."kb_articles` CHANGE `art_order` `art_order` SMALLINT(5) UNSIGNED  DEFAULT '0' "; 
hesk_dbQuery($sql); 

echo "Database modified"; 
?>

If you get any other errors you can post them here, no need to open a new topic.

[killcount]

Can't execute SQL: ALTER TABLE `hesk_kb_articles` CHANGE `history` `history` TEXT DEFAULT ''

MySQL said:
BLOB/TEXT column 'history' can't have a default value

Please notify webmaster at

whats what i got when i tryed to run the dbupdate.php.

[Klemen]

Try again, I modified the above code.

[killcount]

Thank you sir!

[killcount]

i get Can't execute SQL: INSERT INTO `hesk_kb_categories` too.

[killcount]

i should of made a new topic

[dbower]

The above script fixed problem of adding a article but I still get the error when trying to add a new category


Can't execute SQL: INSERT INTO `hesk_kb_categories` (`name`,`parent`,`cat_order`,`type`) VALUES ('Software','1','20','0')

MySQL said:
Field 'articles' doesn't have a default value

Please notify webmaster at dbower@greenetweed.com

[Klemen]

Please try searching the forum:
viewtopic.php?t=2353