Most Users Ever Online Statistic.

[alfuzzy]

Originally Posted by Max Taxable

That's pretty much a standard disclaimer, any time anyone with experience is recommending you manually run a db query. Along with either/or, "Make sure you do a backup first!"

Could sound ominous, but really it's not. It's just part of "best practices" not to do stuff like that on your live site without first trying it on a tester. And it's "best practices" to recommend testing first.

Totally understand the disclaimer aspect. No way 100% of the suggestions will work 100% of the time. And it's the 0.00001% of the time something doesn't work...is when something will come back to bite you in the butt!

Originally Posted by Max Taxable

You never let us know if you ran the query or not, and if so did it get you where you wanted to be.

My main issue is I've had trouble setting up a test site. Tried doing it on my server...and it didn't work out (even with expert help). And tried doing a local test setup using products like XAMPP & MAMP...and couldn't get it to work ether. Setup instructions for XAMPP & MAMP just not detailed enough. I'm sure after I figure out how to do it the first time...it will make total sense.

Just not there yet with the learning curve! lol

Thanks

[MarkFL]

Oh yeah, the first time I set up a local server using xampp it took me hours to get it working. There's definitely a learning curve for all this stuff, but what I lack in expertise I mostly make up with tenacity.

But, once you do get a local server set up it's well worth all the effort. I've got all kinds of forum software now running on it, and it's super nice to have a place to try things out without worrying about destroying a live site.

[Max Taxable]

Originally Posted by alfuzzy

My main issue is I've had trouble setting up a test site.

You can safely run the query. It's been tested. It's only affecting the datastore, there's zero chance it can do any damage. You're good to go.

[rekha]

If you have your admincp setup to allow mysql queries, then it is @ admincp -> Maintenance -> Execute SQL Query. Otherwise, you can login to mysql directly or use a mysql frontend (we use Navicat) to run mysql queries.