Export IP address from who's online - online.php

[ayjayef]

We are getting a few thousand guests online at any one time and while I can view each single "who's online" page we would like to export all the IP's to a file so we can sort them.
...

[ayjayef]

Thanks Wayne.
Unfortunately MySQL only shows the download for 8.0.18 so I can't even do a full rebuild using 8.0.16 as I don't have it!

Hopefully Vbull 5.5.5 comes out of beta soon...

[ayjayef]

Double AAARRGGHHH (because I shouldn't swear!)

I followed the install requirement suggestion of "MySQL 8 or greater" and have had the server off-line for 8 hours+ doing this upgrade.

...

[ayjayef]

I won't pretend to understand this but I think it's ominous that the line starts with "Beginning with MySQL 8.0.18"


https://dev.mysql.com/doc/refman/8.0/en/hash-joins.ht...

[ayjayef]

AARRGGHHH -- all night upgrade process to get the latest version up and 25% into the upgrade received:

-----------
Fatal Error Occurred

You have an error in your SQL syntax;...

[ayjayef]

I've also had many years of good success with [GlowHost] Spam-O-Matic
https://www.vbulletin.org/forum/showthread.php?t=248042

(just another option)

[ayjayef]

Super Wayne to the rescue again!
Great reply, and that's exactly where it was.

After finding the odd time stamp of 4294967295 (should have been a number a quarter of the size) I searched...

[ayjayef]

I'm guessing that there is a field somewhere in the database set that saves the time of the last PM.

I've compared working and non-working accounts, specifically the USER table but can't...

[ayjayef]

Have been chasing this quirk for years on a VB 4.2.x forum and never found it:

This forum requires that you wait 30 seconds between sending private messages. Please try again in 2731512566...

[ayjayef]

Thanks Mark.



Wow, first I knew that. We have had to do many over the years, typically to fix searchcore and a couple of other tables that corrupt after a dirty shutdown. I...

[ayjayef]

Thanks for the tips In Omnibus.

The real upgrade didn't ever stop, it just took an hour or more to complete. The upgrade screen says it might take a long time but if multiple upgrades take...

[ayjayef]

hmmm... out of frustration I just thought of something I hadn't tried.

I just did a "repair/optimise tables" on the VB4.2.2 before exporting the database.
Imported it into...

[ayjayef]

Going around in circles for a week and really need a little direction please.


Original live server: VB 4.22, IIS v7, PHP 5.3.9, MySQL 5.1.59, Win2012R2
Threads: 38,000 - Posts:...

[ayjayef]

...and that fix just worked for me too.

Thanks demojames.

[ayjayef]

Well I've spent about 3 hours reading the forums, blogs and even the VBulletin manual and it seems that the only YaBB conversion is a "Tier1" for version 2.1

Has anyone done a YaBB...