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.

  • bash scripting for loop set number of iterations
  • linux bash mass rename tool Centos/Debian/Ubuntu
  • Cannot get mono to work properly on Linux Mint
  • CPanel SNI error
  • Bing/Microsoft Ads causing problems for ad tracking and site loading
  • imagemagick converting jpg images to pdf file size too large
  • convert imagemagick pdf to jpg is too small when converting solution
  • How To Record Your Screen with Linux
  • Virtualbox Error
  • How to get/display full path to file in Linux/Unix
  • kernel:[14277.697049] EDAC MC0: UE row 4, channel-a= 0 channel-b= 1 labels "-": (Branch=0 DRAM-Bank=0 RDWR=Read RAS=7048 CAS=0 FATAL Err=0x4 (>Tmid Thermal event with intelligent throttling disabled))
  • CPanel Cannot Login HTTP error 401 You do not have permission to access this page.
  • Failed to open a session for the virtual machine XPCB. Implementation of the USB 2.0 controller not found! Because the USB 2.0 controller state is part of the saved VM state, the VM cannot be started. To fix this problem, either install the 'Oracle V
  • OpenVZ how to enable FUSE in the container
  • How to manually mount Linux disk image partition without using losetup
  • Debian 8 Jessie in Linux OpenVZ Container does not work on Centos host
  • bash script Get Model and Serial Number of All Hard Disks in Server on Linux
  • How to scp transfer a file in Linux with spaces
  • unfortunately lg keyboard has stopped - LG Phone Keyboard Issue
  • Location of cPanel apache access logs