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 DOESNOT 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.


  • bash string substitution
  • sed print specific line number
  • Unable to configure RSA server private key SSL Library Error: 185073780 error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch
  • Error code: ssl_error_rx_record_too_long
  • Centos OpenDKIM & Postfix Setup Guidel
  • The redirect URI in the request: urn:ietf:wg:oauth:2.0:oob can only be used by a Client ID for native application. It is not allowed for the 'WEB' client type.
  • dir2slideshow Centos rpm requirements
  • bash script delete all non-English characters
  • Lost connection to MySQL server during query [2013]
  • No package fuse-encfs available. yum
  • Error: Cannot retrieve metalink for repository: epel. Please verify its path and try again
  • No response from subprocess (whostmgr (whostmgr)): The subprocess exited with status 12 (ENOMEM).
  • ResourceManager[31705]: CRIT: Resource STOP failure. Reboot required!
  • htaccess modrewrite query string to another URL howto
  • bash script how to do wildcard string comparisons or matching
  • bash script test if directory exists
  • bash script check if file exists
  • bash script linux how to do a wildcard string comparison
  • Windows 2012 Server R2 Install Error "windows cannot find the microsoft license terms windows 2012 server install"
  • cPanel how to force reinstall rpms and fix packages and other problems caused by updates or duplicate rpms