Upgrade stuck at "Update members ip with ipv6 support" (46 of 65)

[simplengmakina]

yes,
but the error message with backtrace is more intresting,
since it should work with null (not blank) values.

Like magic! Setting the ip to 'null' does fix the issue!

[Ramón Cutanda]

I had exactly the same issue, but I could solved it with the help provided in this thread. THANKS!

I had more than 300 users in my database with "empty" (blank) IPs. Not "NULL", simply empty. I turned all those user IPs (1 and 2) into NULL and, finally, the upgrader could continue.

But shortly after I had the same problem with "messages". This time, I had around 100 "empty" IPs and around 1,000 "unknown". I turned the "emply" IPs into NULL (the same I did with users) and then I modified the upgrade script following the "Fix upgrade mysql ip convert logic":

https://github.com/SimpleMachines/SMF2.1/pull/5436/commits/2a7b15ec9c57423970b9ed98ed303f7ed6dd6ac4

That didn't seem to work; or maybe I simply was a bit impatient... so I did a "find and replace" converting all the "unknown" IPs into 127.0.0.1

After that the conversion finished and I am now on 2.1 RC1
Thanks :-)