1.3 -> 1.4 Database Update Error


#1

..\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. =(


(vipsoft) #2

Use this version of core/Updates/1.4-rc2.php http://dev.piwik.org/trac/export/4669/trunk/core/Updates/1.4-rc2.php