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.


  • Cannot Read License File cPanel Solution
  • Centos and obfsproxy install errors
  • There was a problem importing one of the Python modules required to run yum. The error leading to this problem was:
  • curl: (35) SSL connect error solution
  • Mint/Ubuntu/Debian error twisted/test/raiser.c:4:20: fatal error: Python.h: No such file or directory #include Python.h
  • find: missing argument to '-mtime'
  • openvpn 2.3.10-1.el6 issues auth-env does not work correctly for auth-user-pass-verify
  • How to modify HTML/Themeforest Themes to work in any path statically using unix/linux's sed command
  • vps windows 2008 datacenter error code 0xc004c020
  • cp copy all contents of directory to another one including hidden files and folders howto
  • Cannot load /etc/httpd/modules/mod_file_cache.so into server: /etc/httpd/modules/mod_file_cache.so:
  • Apache SSL Reverse Proxy Very Slow Solution
  • PDF Cannot Open Interactive Solution Ubuntu/Debian/Mint Please wait... If this message is not eventually replaced by the proper contents of the document, your PDF viewer may not be able to display this type of document. You can upgrade to the latest
  • Error: database disk image is malformed - yum error solution and fix
  • esniper error on Linux Mint 17.2 Debian/Ubuntu: Cannot connect to URL : SSL connect error: gnutls_handshake() failed: Illegal parameter Retrying... esniper encountered a bug. It looks like your esniper version is not current. You have version 2.28
  • Nvidia Linux Card not working due to LSI 9200/SAS2008 IRQ conflict
  • SAS2008 LSI 9200-E Linux Upgrade Flash Firmware with sas2flash
  • Apache Vhost HowTo Serve Same Content using a different domain and IP
  • Check Linux Ubuntu/Debian/Mint Version from Command Line
  • Linksys PAP2T No delay in dialing recommended fast dial plan