MySQL Out of Range Solution for DATETIME field -

MySQL Out of Range Solution for DATETIME field

Affected rows: 0
Warning: #1264 Out of range value adjusted for column 'deleteon' at row 1
SQL query:
UPDATE `custtable`.`custinfo` SET `deleteon` = '2011-02-29 00:00:00' WHERE `custinfo`.`custid` =105 LIMIT 1 ;

This happened after a migration to a new SQL database due to user error.  The old database server MySQL 3.23 or 4 allowed an impossible date to be entered by a user.  As we know February 29th DOES NOT exist but the database allowed the value.  MySQL 5.0 is smarter and rejected it and ended up setting a blank value for that field.  It was hard to troubleshoot at first until we actually looked at the date :)

So the solution is to use Feb-28th or March 1st since the 29th does not exist.


  • NS_ERROR_FAILURE (0x80004005) The virtual machine 'XP' has terminated unexpectedly during startup with exit code 1.
  • Directadmin compile error solution cc: Internal error: Killed (program cc1)
  • Samsung C410W/CLP410W not printing in Linux solution
  • Samsung Printer Password Login to change settings CLP
  • bash shellshock how to manually patch when there is no update for Centos/Debian/Ubuntu/Fedora
  • How to root and unlock S4 in Canada Bell/Rogers/Telus/Fido I337 4.4.2
  • OpenVZ Howto disable ploop and switch back to SIMFS
  • firefox android text size inconsistent large and small text size solution
  • /usr/libexec/mysqld: The table 'session' is full solution
  • Openvz iptables v1.4.7: can't initialize iptables table `nat': Table does not exist (do you need to insmod?) Perhaps iptables or your kernel needs to be upgraded. solution
  • Postfix Errors & Solutions "unprivileged": bad value: "???" - bad transport type:
  • Postfix how to secure outgoing authenticated e-mails for privacy and hide the IP address, mailer and other things
  • Samsung Galaxy Note Upgrade/Update Experience from 4.0.4 with aftermarket ROMs
  • Openvz 2014-08-12T19:05:55-0400 vzctl : CT 391801 : Unable to start init, probably incorrect template 2014-08-12T19:05:55-0400 vzctl : CT 391801 : Container start failed
  • Cannot mount iPhone or iPad in Linux
  • PayPal subscriptions automatically cancelling after creation of profile
  • .htaccess mod_rewrite preserve access to custom query string solution
  • Stop Wordpress new user notification how-to
  • 2CO/2Checkout Howto Enable IPN/Notification Setup & Script Info
  • 2CO/2Checkout how to create recurring payment subscription button dynamically