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.


  • 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
  • Centos scp or sftp program missing solution/what rpm provides them
  • How to install grub on virtio KVM with Linux
  • KVM: unknown exit, hardware reason 0x80000021 kvm_run returned -22 solution
  • Linux bash how to list files of a certain date with the statu command for scripting
  • cPanel How to set SSL and Dedicated IP in cPanel
  • OpenVZ vzctl update changes how iptables work - iptables v1.3.5: can't initialize iptables table `nat': Table does not exist (do you need to insmod?) Perhaps iptables or your kernel needs to be upgraded. updated solution
  • Wordpress Plugin manual install how-to
  • Disable linux baxh proxy ENV export variable
  • Linux bash read exif data tags from image jpeg/tiff/jpg
  • PHP Issues with Joomla Strict Standards: Non-static method JLoader::import() should not be called statically