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.


  • 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
  • esniper and curl errors https://signin.ebay.com/ws/eBayISAPI.dll?SignIn: Couldn't connect to server: couldn't connect to host
  • Disable cphulk in CPanel if you can't login even with the right password
  • bash increment how to
  • Centos automatic ifcfg-eth0 scripts based on list of IPs from bash
  • Vbox/Virtualbox devices grayed out for non-root user solution
  • libguestfs tools howto guide for managing virtual machine images
  • NS_ERROR_FAILURE (0x80004005) The virtual machine 'XP' has terminated unexpectedly during startup with exit code 1.
  • Directadmin compile error solution cc: Internal error: Killed (program cc1)
  • Samsung C410W/CLP410W not printing in Linux solution
  • Samsung Printer Password Login to change settings CLP
  • bash shellshock how to manually patch when there is no update for Centos/Debian/Ubuntu/Fedora
  • How to root and unlock S4 in Canada Bell/Rogers/Telus/Fido I337 4.4.2
  • OpenVZ Howto disable ploop and switch back to SIMFS