We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

MySQL Error

Development and Programming

combinedmedia's avatar
combinedmedia
79 posts
about 17 years ago
combinedmedia's avatar combinedmedia

Hello There is something wrong with my website. I get this error while Im trying to add a new category:

MySQL ERROR: Error Number: 1364 Description: Field ‘cat_order’ doesn’t have a default value Query: INSERT INTO `exp_categories` (`group_id`, `cat_name`, `cat_url_title`, `cat_description`, `cat_image`, `parent_id`, `site_id`) VALUES (‘6’, ‘sub421’, ‘sub421’, ”, ”, ‘12’, ‘1’)

and Im getting error while Im trying to publish new entry:

MySQL ERROR: Error Number: 1364 Description: Field ‘recent_comment_date’ doesn’t have a default value Query: INSERT INTO `exp_weblog_titles` (`entry_id`, `weblog_id`, `author_id`, `site_id`, `ip_address`, `title`, `url_title`, `entry_date`, `edit_date`, `versioning_enabled`, `year`, `month`, `day`, `expiration_date`, `comment_expiration_date`, `sticky`, `status`, `allow_comments`, `allow_trackbacks`, `forum_topic_id`, `dst_enabled`) VALUES (”, ‘17’, ‘1’, ‘1’, ‘213.94.220.9’, ‘asdad’, ‘asdad’, ‘1218632932’, ‘20080813150852’, ‘y’, ‘2008’, ‘08’, ‘13’, ‘0’, ‘0’, ‘n’, ‘open’, ‘y’, ‘n’, ‘0’, ‘y’)

I dont know wahts happend, as befor everything was working fine…please any suggestions?

       
Justin Hurlburt's avatar
Justin Hurlburt
344 posts
about 17 years ago
Justin Hurlburt's avatar Justin Hurlburt

Greetings,

Did you recently install/enable any extensions? Try disabling extensions and see if that helps.

       
combinedmedia's avatar
combinedmedia
79 posts
about 17 years ago
combinedmedia's avatar combinedmedia

Hi, Its working fine now. Host company had some problems and that caused problems with woriking in ee. But now everything is fine. Thank you.

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.