Stuck at Update messages poster_ip with ipv6 support (May take a while) 47 of 69

[NukeWorker.com]

Upgrading from 2.0.18 to 2.1 RC3
https://www.nukeworker.com/forum/index.php
I am stuck at "Update messages poster_ip with ipv6 support (May take a while) 47 of 69." for two+ hours now. There are around 173k message in the database.

I did a search, and found this message (below) from a year ago, which started off like my issue, then the OP started deleting columns, instead of fixing the issue.

https://www.simplemachines.org/community/index.php?topic=565367.0
I attempted to edit the query they posted to fit my situation:

Code Select Expand

SELECT id_msg, poster_ip_old, poster_ip FROM yabbse_messages
WHERE (poster_ip_old not like '%.%.%.%' and poster_ip_old != '' and poster_ip_old !=  'unknown')
or (poster_ip not like '%.%.%.%' and poster_ip != '' and poster_ip !=  'unknown');
I must have made a mistake, because it appears to show me all 173k of of the rows. 

Regardless, there is some "weird" data, such as listed below where the New IP doesn't match the format:

Code Select Expand

63.36.112.96     ?$p`
63.36.112.101     ?$pe
63.57.109.75     ?9mK
63.57.109.87     ?9mW
32.97.110.67     anC
216.163.54.85     أ6U
208.144.195.169     Аé
67.213.187.38     Cջ&


I also made sure my PHP.INI had plenty of execution time and memory allotted.
I'm an older guy, and I'm not as good at computers as I used to be.  If someone would come fix my mess, I'd appreciate it ($).
This is a production environment, and I's like to get it back online ASAP.



edited by live627 to add code tags

[NukeWorker.com]

Update: I let it run overnight "Time Elapsed: 1021 mins, 41 seconds. ", just to make sure that it wasn't taking a long time...
Any help would be appreciated.

[Dzonny]

Hey there!

Sorry to hear that you're experiencing such problems.
Do you have a backup from previous version when forum worked fine (2.0.18)?

Can you check which datatype got the column poster_ip of you messages table and report back (use phpMyAdmin)?

Also might be a good idea to check the output of this sql code:

Code Select Expand

select max(length(poster_ip)) from smf_messages

[Sir Osis of Liver]

Forum is offline.  Not a good idea to upgrade this forum to 2.1, it's still in RC and somewhat buggy.  Restore to 2.0.18.  If you need assistance pm me, will be back on tonight.

[live627]

My initial recommendation baaed on your situation:

   
• Restore the 2.0.18 backup
• Once whatever wrong is sorted, clone your live forum and try to upgrade it
• Once the clone is  upgraded smoothly, the live forum can be upgraded

I think getting the forum back up and running is the top priority

[live627]

I have a possible fix fr you

https://github.com/live627/SMF2.1/commit/96f77c0d9117c885c2dc71e8ecac5f4b4700b720#diff-0cf727f65c7334c7ab0eba9a56d44120e61dc8538ebc68e330a4679a99172cb0R5101

[NukeWorker.com]

Do you have a backup from previous version when forum worked fine (2.0.18)?

Can you check which datatype got the column poster_ip of you messages table and report back (use phpMyAdmin)?

Also might be a good idea to check the output of this sql code:

Code Select Expand

select max(length(poster_ip)) from smf_messages

I mis-spoke, I was upgrading from 2.0.17 to 2.1 RC

I have restored my old forum directory/folder.

I get a white screen here: https://www.nukeworker.com/forum/index.php

And an error here which I believe refers to a mod: https://www.nukeworker.com/forum/index.php?action=markasread;sa=all;sesc=

Datatype the column poster_ip of my messages table:
poster_ip_old    varchar(255)     utf8_general_ci    Yes     NULL
poster_ip     varbinary(16)             Yes     NULL
Is this the code you wanted me to run?:

SELECT id_msg, poster_ip_old, max(length(poster_ip)) FROM yabbse_messages WHERE (poster_ip_old not like '%.%.%.%' and poster_ip_old != '' and poster_ip_old != 'unknown') or (poster_ip not like '%.%.%.%' and poster_ip != '' and poster_ip != 'unknown')

It outputted this:
    id_msg     poster_ip_old     max(length(poster_ip))
    35079    65.110.158.210    4

Running just this:
SELECT max(length(poster_ip))  FROM `yabbse_messages`

Gives no rows, but still says max length is 4.

Also, it looks like my "backup_" may have gotten overwritten, by trying to run the upgrade script more than once...

I'm calling my host to restore everything to before I messed it up.  But I'd still like to get it fixed.

-- the old site has been restored --