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.

  • initial Main Mode message received on but no connection has been authorized with policy=PSK
  • Firefox errors Unable to generate public/private key pair. (Error code: sec_error_keygen_fail)
  • Centos/obfsproxy errors
  • rsync backup entire system properly
  • OpenVZ Install Guide Again / Quick Setup
  • flypro EEPROM PLCC32 programmer software error "The device ID does not match, whether to continue operating"
  • grub cannot install or boot from mdadm RAID 10 array
  • mdadm create raid10 array with only 2 drives
  • Openvz Enable netadmin
  • Centos yum mirror problem error "[Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found""
  • ssh session and port forward or reverse port matching or assocation howto
  • yum how to blacklist and exclude mirrors
  • ECC Errors in action
  • Avocent Unable to load resource avctVideo.jar
  • iptables port forwarding multiple ports to another IP
  • Dell CS24 NV5/NV7 Gigabyte GA-3CESL-RH Motherboard ROM Chip info
  • phlash Cannot flash when memory managers ( e.g. HIMEM) are present Phoenix BIOS
  • Weird Ubuntu Issues with NVIDIA driver/Compiz
  • HP Switch 2824 CLI Telnet Experience , Guide and Tutorial
  • rm how to delete a file with -- 2 leading dashes