Forums

New 5.6 Install Fails With MySQL Error 1264

Permalink 1 user found helpful
I am attempting a clean install of 5.6.0. After completing the site/database details screen a progress bar appears indicating it's creating tables, then I get the error message -

mysql error: [1264: Out of range value for column 'uLastIP' at row 1] in EXECUTE("update Users set uLastIP = -713304780, uLastLogin = 1346673362, uPreviousLogin = '0', uNumLogins = uNumLogins + 1 where uID = '1'")
piccolopete
 
Hanswurstel replied on at Permalink Reply
Hi there,
I had the same problem today and 'solved' it by the following hack:
FILE: concrete\core\models\user.php
LINE: 221
FROM: $db->query("update Users set uLastIP = ?, uLastLogin = ?, uPreviousLogin = ?, uNumLogins = uNumLogins + 1 where uID = ?", array(ip2long($_SERVER['REMOTE_ADDR']), time(), $uLastLogin, $this->uID));
TO:   $db->query("update Users set uLastIP = ?, uLastLogin = ?, uPreviousLogin = ?, uNumLogins = uNumLogins + 1 where uID = ?", array(16843009, time(), $uLastLogin, $this->uID));
CHANGE: ip2long($_SERVER['REMOTE_ADDR']) -> 16843009

The problem seems to be that the ip2long($_SERVER['REMOTE_ADDR']) returns a negative number which is not suitable for the unsigned int 10 field (uLastIP) in the Users table.
As a temporary hack I just changed the IP to a standard value of 1.1.1.1 (16843009) which should work as long as the is no official fix.

Hope that helps
JohntheFish replied on at Permalink Reply
JohntheFish
Have you reported this on the bug tracker? Its not the sort of issue the core team would encounter (unless they test with an IP that shows the glitch)
piccolopete replied on at Permalink Reply
piccolopete
Thanks. That worked for me. I've posted the issue on "Bug Tracker" also.