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.


  • 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
  • kvm how to add secondary cdrom drive
  • Dell CS24SC Server Info
  • Dell CS10-F1D Server Info lspci Linux specs
  • Linux Kernel EDAC errors EDAC MC0: UE row 0, channel-a= 0 channel-b= 1 labels "-": NON-FATAL recoverable (Branch=0 DRAM-Bank=0 Buffer ID = 0 RDWR=Read RAS=0 CAS=0 NON-FATAL recoverable Err=0x800 (Non-Aliased Uncorrectable Patrol Data ECC))
  • Linux disable firmware prevents NIC/Ethernet from working phy0 -> rt2x00lib_request_firmware: Error - Failed to request Firmware.
  • VPN Account Buyers Guide and General Info
  • KVM/QEMU how to boot from direct kernel vmlinuz and initrd with networking
  • Flash slowing down your Firefox browser? Install Flashblock plugin