..\core\Updates\1.4-rc2.php:
Error trying to execute the query 'UPDATE piwik_log_visit
SET location_ip = UNHEX(LPAD(HEX(CONVERT(location_ip, UNSIGNED)), 8, '0'))'.
The error was: SQLSTATE[HY000]: General error: 1292 Truncated incorrect INTEGER value: '
8L'
Please assist, I ran it both web and command line, no luck. =(