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.


  • 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
  • Thunderbird Error An error occurred while loading or saving configuration information for thunderbird. Some of your configuration settings may not work properly.
  • CPanel Link to all of the command line options
  • PayPal Convert BuyNow Button to Plain HTML Link
  • OpenVZ Unable to stop container
  • Sipura/Linksys VOIP Adapter How to Check your IP Address
  • Ubuntu Linux Slow/Delayed SSH ping response Solution
  • Webalizer Error "Error: Unable to restore run data (10)" no longer updating
  • phpBB guests unable to view forums without logging in Anonymous account solution
  • phpBB create new email hash manually when modifying or adding user manually directly through MySQL
  • cp ignore symlink and copy the actual file
  • iptables how to forward port to another IP address with DNAT
  • SolusVM error error: Failed to create domain from /home/kvm/kvm101/kvm101.xml error: cannot open file '/dev//dev/kvmcontainer/kvm101_img': No such file or directory
  • drbd 8.3 hard drive failure recovery example
  • mytop install errors
  • Argument list too long solution - rm -rf new/* -bash: /bin/rm: Argument list too long