ChiefsPlanet

ChiefsPlanet (https://chiefsplanet.com/BB/index.php)
-   Nzoner's Game Room (https://chiefsplanet.com/BB/forumdisplay.php?f=1)
-   -   ChiefsPlanet This Server, UGH (https://chiefsplanet.com/BB/showthread.php?t=351710)

Bump 01-10-2024 12:10 AM

nice job getting it back. We appreciate you guys

Eleazar 01-10-2024 12:46 AM

Nice work Austin. Go to bed. haha

BWillie 01-10-2024 01:03 AM

This page is permanently on page 1 for me.

A Salt Weapon 01-10-2024 01:05 AM

Quote:

Originally Posted by AustinChief (Post 17326320)
Tables optimized but still need to find why our CPU usage is so high

Pretty sure all of direckshits and cosmo’s gay kiddie porn is uploaded here. That’s probably a good start to finding out why.

stanleychief 01-10-2024 01:12 AM

Did y'all make the upgrade to SSD/NVMe yet?

big nasty kcnut 01-10-2024 01:19 AM

We're back

srvy 01-10-2024 01:46 AM

Welp the server proved that what day of the week it crashes means nothing. By damned it will crash any damn day it pleases.

HonestChieffan 01-10-2024 05:52 AM

Back in the day we did radio checks on CB. Now we optimize our server.


Breaker 1-9, need a radio check.....

Loud and clear for sure driver....

OnTheWarpath15 01-10-2024 06:26 AM

This is quickly becoming a "PC Load Letter? What the ****?" type situation.

https://media0.giphy.com/media/RhEvC...giphy.gif&ct=g

cabletech94 01-10-2024 06:40 AM

I’m just glad that I can now post of the best chiefs (fan) website in the world again. At least until it crashes again.

This is a serious question tho: do we need a monetary donation to aid in an upgrade or something? I’d be willing to do my part, and I’d imagine some of these others would too.

Lzen 01-10-2024 06:51 AM

Quote:

Originally Posted by Chief Ten Beers (Post 17326231)
It finally happened on a random Tuesday LMAO

Ha! I thought about that. I wonder if DaFace decided to change that maintenance day to Tuesday after the last time.

Lzen 01-10-2024 06:56 AM

I tried going to that old downtime CP forum. Whatever you do, do NOT click that. Just delete the link. Trust me.

Edited

New World Order 01-10-2024 07:13 AM

This site is free. I appreciate the work the mods/administrators do for us.

Doesn't bother me that we have downtime here and there.

lewdog 01-10-2024 07:24 AM

How come the $20 I donated years ago hasn’t fixed this server shit yet?!?!!

LoneWolf 01-10-2024 07:26 AM

Quote:

Originally Posted by A Salt Weapon (Post 17326352)
Pretty sure all of direckshits and cosmo’s gay kiddie porn is uploaded here. That’s probably a good start to finding out why.

Bugeater: We have a zero tolerance policy for pedo accusations.

A Salt Weapon: Hold my beer.

displacedinMN 01-10-2024 07:45 AM

Better this morning.

I can donate if needed.

ptlyon 01-10-2024 08:09 AM

Quote:

Originally Posted by lewdog (Post 17326411)
How come the $20 I donated years ago hasn’t fixed this server shit yet?!?!!

That's a cuz $20 back then don't equal $20 these days.

That said, 20 bucks is 20 bucks.

ptlyon 01-10-2024 08:10 AM

Quote:

Originally Posted by HonestChieffan (Post 17326378)
Back in the day we did radio checks on CB. Now we optimize our server.


Breaker 1-9, need a radio check.....

Loud and clear for sure driver....

Anybody know what a counter check was?

Bob Dole 01-10-2024 08:16 AM

Quote:

Originally Posted by ptlyon (Post 17326438)
Anybody know what a counter check was?

That’s been a few years. Good lord.

scho63 01-10-2024 09:10 AM

Quote:

Originally Posted by lewdog (Post 17326411)
How come the $20 I donated years ago hasn’t fixed this server shit yet?!?!!

Fess up, it was only $2.

:D

scho63 01-10-2024 09:18 AM

This site crashes and has more failures than the Boeing Max 737 and yet you keeping mocking me about being IN the tech industry.........:doh!:

How I picture the MOD team trying to fix this shit.



https://pansci.asia/wp-content/uploa...e05fe3ed15.jpg

Lzen 01-10-2024 09:21 AM

Serious question. Is there a temp forum that we can go to like the old Downtime CP?

DaFace 01-10-2024 09:23 AM

Quote:

Originally Posted by Lzen (Post 17326558)
Serious question. Is there a temp forum that we can go to like the old Downtime CP?

Which link were you using? This is the best one at the moment:

https://www.tapatalk.com/groups/downtime_cp/

That said, it's been migrated twice (not by our choice) since I actually spent any time on it 10-15 years ago, so the interface isn't great.

Dunerdr 01-10-2024 09:24 AM

Serious question. How much does it cost to run CP a year? I haven't donated in a few years and am feeling guilty now.

Bearcat 01-10-2024 09:30 AM

Quote:

Originally Posted by scho63 (Post 17326552)
This site crashes and has more failures than the Boeing Max 737 and yet you keeping mocking me about being IN the tech industry.........:doh!:

How I picture the MOD team trying to fix this shit.

DaFace is the only mod with access to the database and 1) highly doubt he has access to fix anything at thay level, 2) he isn't even in IT and could probably walk circles around your IT adjacency, and 3) feel free to PM AC with your expert opinion of what's wrong, I'm sure he'd appreciate someone jumping in to fix this free thing you use on his dime.

Bearcat 01-10-2024 09:33 AM

Quote:

Originally Posted by Lzen (Post 17326558)
Serious question. Is there a temp forum that we can go to like the old Downtime CP?

I spent the time death scrolling the discord server.... reading rabble nonchalantly pointing out several times how "we could all go to "The U"", and reading Baby Lee's ironic and completely random "mod from hell" rant.

I give it 4 clowns (that's out of 10).

:o):o):o):o)

Graystoke 01-10-2024 09:43 AM

I am all in to donate if needed. And I certainly appreciate this site and the time Mods and Administrators put into this.

Pablo 01-10-2024 09:44 AM

I thought scho was formerly a flooring salesman or something. Maybe that was somebody else but it stuck in my brain. He also slept at his office to save money on rent? Was that an IT gig or am I crazy?

DaFace 01-10-2024 09:48 AM

Quote:

Originally Posted by Bearcat (Post 17326577)
DaFace is the only mod with access to the database and 1) highly doubt he has access to fix anything at thay level, 2) he isn't even in IT and could probably walk circles around your IT adjacency, and 3) feel free to PM AC with your expert opinion of what's wrong, I'm sure he'd appreciate someone jumping in to fix this free thing you use on his dime.

From my perspective, the main issue is that we're on software that was written in 2008, and it's so old that we can't even be on the newer versions of PHP and MySQL, so even the backend kind of sucks.

It's compounded by the fact that it's really difficult to "right size" a server for our use case. It needs to be able to handle gameday traffic, but normal volume is only about 10% of that level, so we've got ad revenue* that's about 10% of what we'd need to support peak usage. So it's a lot of duct tape and bubble gum to keep us moving along.

But as you alluded to, I've never claimed to be some sort of IT guru. My only superpower is being willing to spend the time trying to fix things as best I can. AustinChief has far more knowledge than I do but far less time.

In the end, the "right" solution is almost certainly to move to a new server and new software, but 1) it's an astronomical amount of time to do that and 2) the "look and feel" of ChiefsPlanet would change dramatically in the process. We probably just need to rip off the bandaid, but that's easy to say when you're not the one who has to put the hours into it.

*As a note here, I don't actually have any visibility into our ad revenue and costs - that's all AustinChief's territory. I'm just guessing.

scho63 01-10-2024 09:49 AM

Quote:

Originally Posted by Bearcat (Post 17326577)
DaFace is the only mod with access to the database and 1) highly doubt he has access to fix anything at thay level, 2) he isn't even in IT and could probably walk circles around your IT adjacency, and 3) feel free to PM AC with your expert opinion of what's wrong, I'm sure he'd appreciate someone jumping in to fix this free thing you use on his dime.

You can dish it out but you can't take it.

Crying like a whiny bitch. LMAO

scho63 01-10-2024 09:52 AM

Quote:

Originally Posted by Pablo (Post 17326596)
I thought scho was formerly a flooring salesman or something. Maybe that was somebody else but it stuck in my brain. He also slept at his office to save money on rent? Was that an IT gig or am I crazy?

You have some parts correct and some mixed.

Bearcat 01-10-2024 09:54 AM

Quote:

Originally Posted by Pablo (Post 17326596)
I thought scho was formerly a flooring salesman or something. Maybe that was somebody else but it stuck in my brain. He also slept at his office to save money on rent? Was that an IT gig or am I crazy?

This floor is so nice, you can sleep on it

..that shit sells itself.

Bearcat 01-10-2024 09:57 AM

Quote:

Originally Posted by DaFace (Post 17326601)
From my perspective, the main issue is that we're on software that was written in 2008, and it's so old that we can't even be on the newer versions of PHP and MySQL, so even the backend kind of sucks.

It's compounded by the fact that it's really difficult to "right size" a server for our use case. It needs to be able to handle gameday traffic, but normal volume is only about 10% of that level, so we've got ad revenue* that's about 10% of what we'd need to support peak usage. So it's a lot of duct tape and bubble gum to keep us moving along.

But as you alluded to, I've never claimed to be some sort of IT guru. My only superpower is being willing to spend the time trying to fix things as best I can. AustinChief has far more knowledge than I do but far less time.

In the end, the "right" solution is almost certainly to move to a new server and new software, but 1) it's an astronomical amount of time to do that and 2) the "look and feel" of ChiefsPlanet would change dramatically in the process. We probably just need to rip off the bandaid, but that's easy to say when you're not the one who has to put the hours into it.

*As a note here, I don't actually have any visibility into our ad revenue and costs - that's all AustinChief's territory. I'm just guessing.

I'll click on more ads if it means this place will never have the layout of TwoBillsDrive.

scho63 01-10-2024 09:58 AM

Is the server issue more a tech problem or money issue?

If its a money issue, how much?

Lets do a fund raiser.

Lzen 01-10-2024 10:07 AM

Quote:

Originally Posted by DaFace (Post 17326565)
Which link were you using? This is the best one at the moment:

https://www.tapatalk.com/groups/downtime_cp/

That said, it's been migrated twice (not by our choice) since I actually spent any time on it 10-15 years ago, so the interface isn't great.

Oh, it was ...... zvision or something like that. I can't remember what the link says. And, of course, I deleted it

Lzen 01-10-2024 10:10 AM

Quote:

Originally Posted by DaFace (Post 17326601)
From my perspective, the main issue is that we're on software that was written in 2008, and it's so old that we can't even be on the newer versions of PHP and MySQL, so even the backend kind of sucks.

It's compounded by the fact that it's really difficult to "right size" a server for our use case. It needs to be able to handle gameday traffic, but normal volume is only about 10% of that level, so we've got ad revenue* that's about 10% of what we'd need to support peak usage. So it's a lot of duct tape and bubble gum to keep us moving along.

But as you alluded to, I've never claimed to be some sort of IT guru. My only superpower is being willing to spend the time trying to fix things as best I can. AustinChief has far more knowledge than I do but far less time.

In the end, the "right" solution is almost certainly to move to a new server and new software, but 1) it's an astronomical amount of time to do that and 2) the "look and feel" of ChiefsPlanet would change dramatically in the process. We probably just need to rip off the bandaid, but that's easy to say when you're not the one who has to put the hours into it.

*As a note here, I don't actually have any visibility into our ad revenue and costs - that's all AustinChief's territory. I'm just guessing.

DaFace,
I know it doesn't get said enough but I (and I'm sure many others) really appreciate what you (and Bearcat and others) do to keep us going.

This site is darn near a quarter century old. Crazy to think about it in that perspective.

Frazod 01-10-2024 10:12 AM

Quote:

Originally Posted by Lzen (Post 17326640)
DaFace,
I know it doesn't get said enough but I (and I'm sure many others) really appreciate what you (and others) do to keep us going.

This site is darn near a quarter century old. Crazy to think about it in that perspective.

Yes, this. Thank you. :thumb:

DaFace 01-10-2024 10:17 AM

Quote:

Originally Posted by Lzen (Post 17326630)
Oh, it was ...... zvision or something like that. I can't remember what the link says. And, of course, I deleted it

Yeah, that's what it was originally. They got bought out by some other group than then got bought out by Tapatalk.

If it seems like we're going into another era of frequent outages (which I'm optimistic isn't the case), I'll drop that link in the "down for maintenance" page so people can find it. Or if you just Google "Downtime Chiefsplanet," it'll be the first result.

Indian Chief 01-10-2024 10:18 AM

Quote:

Originally Posted by scho63 (Post 17326620)
Is the server issue more a tech problem or money issue?

If its a money issue, how much?

Lets do a fund raiser.

You're going to have to stop eating out for lunch.

Zebedee DuBois 01-10-2024 10:49 AM

Quote:

Originally Posted by Lzen (Post 17326640)
DaFace,
I know it doesn't get said enough but I (and I'm sure many others) really appreciate what you (and Bearcat and others) do to keep us going.

This site is darn near a quarter century old. Crazy to think about it in that perspective.

I approve this message.

I also concur.

scho63 01-10-2024 10:52 AM

Quote:

Originally Posted by Indian Chief (Post 17326654)
You're going to have to stop eating out for lunch.

I can afford both.....:rolleyes:

ROYC75 01-10-2024 11:05 AM

Quote:

Originally Posted by Lzen (Post 17326640)
DaFace,
I know it doesn't get said enough but I (and I'm sure many others) really appreciate what you (and Bearcat and others) do to keep us going.

This site is darn near a quarter century old. Crazy to think about it in that perspective.

Temps.

All of this! To each and everyone of you for keeping argubly the greatest site on the net!

After all, I'm glad when this site comes back up! It sucks to lose contact with soo many friends on here!

kccrow 01-10-2024 11:09 AM

Quote:

Originally Posted by DaFace (Post 17326601)
From my perspective, the main issue is that we're on software that was written in 2008, and it's so old that we can't even be on the newer versions of PHP and MySQL, so even the backend kind of sucks.

It's compounded by the fact that it's really difficult to "right size" a server for our use case. It needs to be able to handle gameday traffic, but normal volume is only about 10% of that level, so we've got ad revenue* that's about 10% of what we'd need to support peak usage. So it's a lot of duct tape and bubble gum to keep us moving along.

But as you alluded to, I've never claimed to be some sort of IT guru. My only superpower is being willing to spend the time trying to fix things as best I can. AustinChief has far more knowledge than I do but far less time.

In the end, the "right" solution is almost certainly to move to a new server and new software, but 1) it's an astronomical amount of time to do that and 2) the "look and feel" of ChiefsPlanet would change dramatically in the process. We probably just need to rip off the bandaid, but that's easy to say when you're not the one who has to put the hours into it.

*As a note here, I don't actually have any visibility into our ad revenue and costs - that's all AustinChief's territory. I'm just guessing.

Rip it off and go to vB 6

scho63 01-10-2024 11:21 AM

1. If it's an incredible amount of time to complete, supply a time table and put a fair price to it.
2. If it needs a new server too, let's price that out as well.
3. Let's come up with a number to see if we realistically could raise the money or have a donated server.

We have been talking about this for at least 6-7 years with no parameters.

Maybe some CP members want to be investors in Chiefsplanet.

Maybe create a LP to get this shit finally fixed.

scho63 01-10-2024 11:22 AM

How many "real" members do we have that are truly active on the site?

DaFace 01-10-2024 11:32 AM

Quote:

Originally Posted by kccrow (Post 17326754)
Rip it off and go to vB 6

Xenforo is my preference.

Quote:

Originally Posted by scho63 (Post 17326791)
1. If it's an incredible amount of time to complete, supply a time table and put a fair price to it.
2. If it needs a new server too, let's price that out as well.
3. Let's come up with a number to see if we realistically could raise the money or have a donated server.

We have been talking about this for at least 6-7 years with no parameters.

Maybe some CP members want to be investors in Chiefsplanet.

Maybe create a LP to get this shit finally fixed.

Tell all your own clients that you need to postpone their projects for a few weeks while you work on your hobby Chiefs forum. See how that goes.

Quote:

Originally Posted by scho63 (Post 17326794)
How many "real" members do we have that are truly active on the site?

We typically see around 1,000 active users per day.

dmahurin 01-10-2024 11:37 AM

Just looked into it a bit out of curiosity, has anyone looked into "vanilla" or "flarum" as an alternative to vbulletin? They are both free and open source, are more modern builds that can handle updated mySQL versions, and in the case of Vanilla, has an import tool already built that could bring everything over pretty easily. Without seeing the current db and code I can't say for sure, but it might be worth playing around with on the downtime server to see if feasible. If it works out, could convert the main planet site over and there would be a full backup on downtime from testing. Bring over all the user and role info, basic forum and sub forum structures, possibly even the existing posts if wanted. Might make sense to start fresh on the new one and leave the "historical" posts on downtime.

Bearcat 01-10-2024 11:41 AM

Quote:

Originally Posted by DaFace (Post 17326816)
Tell all your own clients that you need to postpone their projects for a few weeks while you work on your hobby Chiefs forum. See how that goes.

They would probably just wait for the next car to pull up to their corner. :shrug:

Frazod 01-10-2024 11:42 AM

At the end of the day, it's Kyle's world, and we're all just living in it. If he needs help, he'll ask.

DaFace 01-10-2024 11:43 AM

Quote:

Originally Posted by dmahurin (Post 17326831)
Just looked into it a bit out of curiosity, has anyone looked into "vanilla" or "flarum" as an alternative to vbulletin? They are both free and open source, are more modern builds that can handle updated mySQL versions, and in the case of Vanilla, has an import tool already built that could bring everything over pretty easily. Without seeing the current db and code I can't say for sure, but it might be worth playing around with on the downtime server to see if feasible. If it works out, could convert the main planet site over and there would be a full backup on downtime from testing. Bring over all the user and role info, basic forum and sub forum structures, possibly even the existing posts if wanted. Might make sense to start fresh on the new one and leave the "historical" posts on downtime.

The software is a minimal cost compared to the hosting.

DaFace 01-10-2024 11:43 AM

Quote:

Originally Posted by Frazod (Post 17326843)
At the end of the day, it's Kyle's world, and we're all just living in it. If he needs help, he'll ask.

Bingo.

scho63 01-10-2024 11:50 AM

Quote:

Originally Posted by DaFace (Post 17326816)

Tell all your own clients that you need to postpone their projects for a few weeks while you work on your hobby Chiefs forum. See how that goes.

We typically see around 1,000 active users per day.

Then see if you can outsource it. Argentina is cheap.

Jesus Christ I've never seen more excuses or smug ass answers on trying to execute something. :harumph:

If Austin Chief doesn't have the time, try to hire someone.

How about a high school tech guru?

dmahurin 01-10-2024 11:56 AM

Quote:

Originally Posted by DaFace (Post 17326845)
The software is a minimal cost compared to the hosting.

Absolutely but if he could save 3000 a year and have a modern db and site better optimized for the growing user base and traffic, could be a win win. Both of the free options I posted are PHP/mySQL based so shouldn't much in way of a learning curve for anyone working on it if they work on it currently. Hell, if someone wants to send me a copy of the database schema with no data in it, I'd play around and see if I could get something basic working as a proof of concept.

DaFace 01-10-2024 11:59 AM

Quote:

Originally Posted by scho63 (Post 17326858)
Then see if you can outsource it. Argentina is cheap.

Jesus Christ I've never seen more excuses or smug ass answers on trying to execute something. :harumph:

If Austin Chief doesn't have the time, try to hire someone.

How about a high school tech guru?

Dude. You don't know what you're talking about. No one would even touch a project like this for less than $10k, and my guess is that it would take more like $30k+. That's why we're always so patient when we have a guy who can do it for free but has trouble finding the time for it.

So sure, the donation button is at the top. Drop $30k on that link, and I'm sure you'll get Kyle's attention. But unless you're up for that, STFU about things you clearly have zero understanding of.

DaFace 01-10-2024 12:04 PM

Quote:

Originally Posted by dmahurin (Post 17326866)
Absolutely but if he could save 3000 a year and have a modern db and site better optimized for the growing user base and traffic, could be a win win. Both of the free options I posted are PHP/mySQL based so shouldn't much in way of a learning curve for anyone working on it if they work on it currently. Hell, if someone wants to send me a copy of the database schema with no data in it, I'd play around and see if I could get something basic working as a proof of concept.

Eh, Xenforo or vBulletin 6 are both around $200 for the software and both have migration tools - that's really not the issue. I'd personally rather go with those rather than something open source since they tend to be better supported.

(But again, only one person's opinion matters here.)

Graystoke 01-10-2024 12:06 PM

Quote:

Originally Posted by scho63 (Post 17326858)
Then see if you can outsource it. Argentina is cheap.

Jesus Christ I've never seen more excuses or smug ass answers on trying to execute something. :harumph:

If Austin Chief doesn't have the time, try to hire someone.

How about a high school tech guru?

This post ^ comes across poorly, it may not be your intent, so apologies in advance, but..
Quit tracking your shit stained boots across the carpet of whom we are guests.

Fish 01-10-2024 12:13 PM

Quote:

Originally Posted by scho63 (Post 17326858)
Then see if you can outsource it. Argentina is cheap.

Jesus Christ I've never seen more excuses or smug ass answers on trying to execute something. :harumph:

If Austin Chief doesn't have the time, try to hire someone.

How about a high school tech guru?

JFC you can be annoying. Again, for as much as you like to throw around your claims of IT knowledge, you have an incredibly ignorant view of how IT stuff actually works. People are being smug to you because you're a dipshit.

High school tech guru? FFS man...

penguinz 01-10-2024 12:14 PM

Quote:

Originally Posted by DaFace (Post 17326816)
Xenforo is my preference.



Tell all your own clients that you need to postpone their projects for a few weeks while you work on your hobby Chiefs forum. See how that goes.



We typically see around 1,000 active users per day.

Xenforo would be a good switch. Really nice software with a very active and growing mod development community.

Bearcat 01-10-2024 12:24 PM

Quote:

Originally Posted by Graystoke (Post 17326877)
This post ^ comes across poorly, it may not be your intent, so apologies in advance, but..
Quit tracking your shit stained boots across the carpet of whom we are guests.

Dude has zero self awareness.

Constantly talks down to people, will ask a tech question and then call people dumbasses when nobody knows WTF he's talking about while he flaunts his own tech (adjacency) experience, is incapable of distinguishing between the dumbest of shitposters and those who really know their shit because we're all just idiots compared to him, far quicker assumes he knows everything there is to know about a situation so he can talk down to people than simply asking questions and assuming those involved have an IQ over 70, constantly projects his shitty behavior onto others.

....and then after all that over the course of years and thread after thread, is astounded people don't treat him with the utmost respect, like he's somehow a random target from internet assholes.

Pepe Silvia 01-10-2024 12:57 PM

This place is finished.

Dunerdr 01-10-2024 01:12 PM

I work at a data center and the way they spend money i'd have to imagine that host services must be pretty damn steep. No matter what the direction is, Sho's fundraiser idea couldnt hurt. Even if its just to keep the current set up. Could do something simple like a basic printful store. Complete hands off outside of designing a shirt or something. They print it and ship it. I use one for my drag racing page.

Zebedee DuBois 01-10-2024 01:13 PM

Firstly - I have zero technical expertise in this area and should probably be ignored
Secondly - I, personally, don't place a high value on the histories of this place, the old threads from 5, 10 years ago - even though I have hung out here for 20+ years.

Wildy uninformed proposal: Just migrate user names and info to a new platform and let the users create all new threads for the topics of interest. It would seem like that would be an easier transfer than all the threads, links, pics, etc. For instance, how often do people look back to page 10 of a 30 page thread? I know I don't.

Of course, there should probably be some sort of poll to gauge whether this approach is acceptable to the users.

I'll shut my ignorant and insensitive mouth now.

Rams Fan 01-10-2024 01:13 PM

Quote:

Originally Posted by scho63 (Post 17326791)
1. If it's an incredible amount of time to complete, supply a time table and put a fair price to it.
2. If it needs a new server too, let's price that out as well.
3. Let's come up with a number to see if we realistically could raise the money or have a donated server.

We have been talking about this for at least 6-7 years with no parameters.

Maybe some CP members want to be investors in Chiefsplanet.

Maybe create a LP to get this shit finally fixed.

I deal with SQL tables every ****ing day for my job.

Do you realize how much manpower it takes to migrate from one environment to another? That's not even counting the hours of coding it takes by trial and error to figure out what works and what doesn't work.

On top of that, you're asking people who work actual jobs for a living to prioritize this over their work or to outsource (which leads to an entirely different set of possible issues with regards to security vulnerabilities)?

WTF

I'm not a software engineer nor a developer, so I won't tend to understand the technical aspects regarding migration to a new cloud or server, but I'd be happy to volunteer to help with any SQL related tasks (can write in MySQL/PostgreSQL).

DaFace 01-10-2024 01:19 PM

Quote:

Originally Posted by Zebedee DuBois (Post 17326968)
Firstly - I have zero technical expertise in this area and should probably be ignored
Secondly - I, personally, don't place a high value on the histories of this place, the old threads from 5, 10 years ago - even though I have hung out here for 20+ years.

Wildy uninformed proposal: Just migrate user names and info to a new platform and let the users create all new threads for the topics of interest. It would seem like that would be an easier transfer than all the threads, links, pics, etc. For instance, how often do people look back to page 10 of a 30 page thread? I know I don't.

Of course, there should probably be some sort of poll to gauge whether this approach is acceptable to the users.

I'll shut my ignorant and insensitive mouth now.

I've wondered about it. Part of our problem is that we have a post table with like 15 million rows, and that gets accessed and sorted literally every time someone loads a thread.

But in theory, that SHOULD be a surmountable problem, and there's no question that the deep history of this place is part of its appeal. I'd be hesitant to just throw all of that out if we can get around it (and I think we can).

DaFace 01-10-2024 01:22 PM

Quote:

Originally Posted by Rams Fan (Post 17326969)
I deal with SQL tables every ****ing day for my job.

Do you realize how much manpower it takes to migrate from one environment to another? That's not even counting the hours of coding it takes by trial and error to figure out what works and what doesn't work.

On top of that, you're asking people who work actual jobs for a living to prioritize this over their work or to outsource (which leads to an entirely different set of possible issues with regards to security vulnerabilities)?

WTF

I'm not a software engineer nor a developer, so I won't tend to understand the technical aspects regarding migration to a new cloud or server, but I'd be happy to volunteer to help with any SQL related tasks (can write in MySQL/PostgreSQL).

The good news is that (as noted above), there are migration tools that should make SOME of the transition a little easier. But as you alluded to, there are endless little snags you tend to run into along the way, and it doesn't help that this isn't even a "pure" install of vB 3.8 - it's been upgraded like 10 times starting with 2.1 (I think), so there's all sorts of shitty code lying around that could cause issues along the way.

In the end, it's entirely possible that Kyle will choose to just migrate to a new server and keep vB 3.8 as is. It's old, and it's shitty, but in theory just getting onto a new box that keeps the db on an SSD would take care of most of our issues, so if that's the easy path forward compared to starting from scratch on new software, it is what it is.

DaFace 01-10-2024 01:25 PM

For the curious, our first version was vBulletin 1.1.4. ROFL

https://web.archive.org/web/20010223...m/BB/index.php

Fish 01-10-2024 01:28 PM

Quote:

Originally Posted by Zebedee DuBois (Post 17326968)
Firstly - I have zero technical expertise in this area and should probably be ignored
Secondly - I, personally, don't place a high value on the histories of this place, the old threads from 5, 10 years ago - even though I have hung out here for 20+ years.

Wildy uninformed proposal: Just migrate user names and info to a new platform and let the users create all new threads for the topics of interest. It would seem like that would be an easier transfer than all the threads, links, pics, etc. For instance, how often do people look back to page 10 of a 30 page thread? I know I don't.

Of course, there should probably be some sort of poll to gauge whether this approach is acceptable to the users.

I'll shut my ignorant and insensitive mouth now.

As DaFace already touched on... it's just not possible to simply migrate user names and info to a new platform. You guys underestimate what an incredibly complex undertaking something like that is. Since we're running a very old version of vBulletin, it's next to impossible to migrate the existing database to something newer without destroying who knows what and introducing countless new errors that users would then bitch constantly about.

This is just not an easy fix at all without trashing/changing most of what makes CP what it currently is.

wazu 01-10-2024 01:29 PM

Quote:

Originally Posted by DaFace (Post 17326990)
The good news is that (as noted above), there are migration tools that should make SOME of the transition a little easier. But as you alluded to, there are endless little snags you tend to run into along the way, and it doesn't help that this isn't even a "pure" install of vB 3.8 - it's been upgraded like 10 times starting with 2.1 (I think), so there's all sorts of shitty code lying around that could cause issues along the way.

In the end, it's entirely possible that Kyle will choose to just migrate to a new server and keep vB 3.8 as is. It's old, and it's shitty, but in theory just getting onto a new box that keeps the db on an SSD would take care of most of our issues, so if that's the easy path forward compared to starting from scratch on new software, it is what it is.

If we just set up a new server from scratch, Xenforo or whatever, and had a cutover day where everybody is redirected to that new setup, isn't that enough? We could keep the old vBulletin 3.8 thing up under a different URL, and reference it as needed, but lock out all new posts. The old DB would stop growing, and the new server would be all new tech stack whatever and hopefully buy another 30 years. Maybe this has been proposed and shot down. I realize even this is still a project, but seems like one that is about as lightweight as could be hoped for.

Rams Fan 01-10-2024 01:30 PM

Quote:

Originally Posted by DaFace (Post 17326980)
I've wondered about it. Part of our problem is that we have a post table with like 15 million rows, and that gets accessed and sorted literally every time someone loads a thread.

But in theory, that SHOULD be a surmountable problem, and there's no question that the deep history of this place is part of its appeal. I'd be hesitant to just throw all of that out if we can get around it (and I think we can).

That's a valid point regarding performance, though. For my work, we deal with billions of rows of data, and in order to free up some bandwidth on the server (deal with a Greenplum database currently), older data and tables are consistently deleted.

Not sure what infrastructure is supported on the back end (again, not claiming to be an IT expert I just happen to have to be aware of a lot of the back end stuff as part of my work), but may likely either just need to enhance the current state to keep everything. If not, deleting stuff might be the way to go.

Quote:

Originally Posted by DaFace (Post 17326990)
The good news is that (as noted above), there are migration tools that should make SOME of the transition a little easier. But as you alluded to, there are endless little snags you tend to run into along the way, and it doesn't help that this isn't even a "pure" install of vB 3.8 - it's been upgraded like 10 times starting with 2.1 (I think), so there's all sorts of shitty code lying around that could cause issues along the way.

In the end, it's entirely possible that Kyle will choose to just migrate to a new server and keep vB 3.8 as is. It's old, and it's shitty, but in theory just getting onto a new box that keeps the db on an SSD would take care of most of our issues, so if that's the easy path forward compared to starting from scratch on new software, it is what it is.

Even if there is some form of migration on older software, you're still looking at hours which can turn to days/weeks of perfecting the migration with regards to getting everything up and running just by the sheer nature of the activity of migration. The timeline would be (understandably) pro-longed since this forum is maintained by people as a hobby.

Which is why I don't get scho's bitching at all.

scho63 01-10-2024 02:11 PM

Quote:

Originally Posted by Rams Fan (Post 17327017)
Which is why I don't get scho's bitching at all.

No one said it would be easy. I don't expect someone to sacrifice their job for a side hustle/hobby.

I think the bigger issue is what stays and what goes during any migration.

Maybe Kyle can put it to a vote - he can propose a few things.

Examples
A. Keep everything the same - no cost
B. Keep everything and migrate to a superior system. Cost 20K and 2 months
C. Toss certain things and delete other very old stuff. Cost 10k and 1 month

With 1 million tables, there are a massive amount of old threads and data that may have little to no replies. Shit can them.

Photos: massive amounts and establish a cut off for them. Maybe no photos older than 5 years.

It's not really bitching about the downtime as much as all the time spent bitching about the down time and no clear path after years.

Maybe Kyle can just say, **** it. It is was it is, so deal with it. I got no problem with that.

He can ask for volunteers or donations or show a plan so we can all help.

I'm not sure what he wants to make out of a new site. Building a complete site from scratch? Plugging some holes? Redevelop current site?

CP members are nothing short of shocking when it comes to pitching in. Just ask and maybe he might be surprised at all the help he gets.

penguinz 01-10-2024 02:15 PM

@DaFace.... I haven't been in the backend of VBull in over a decade but if I recall correctly it defaults to storing all the attachments, avatars, etc in the DB. OK to do on small sites but not large ones like this.

I know the new version allows to change it to filesystem but not sure if the 3.x does.

Filesystem vs DB will be much faster and less load on the server. Could be a big reason the DB backups bring the server to a halt.

DaFace 01-10-2024 02:16 PM

Quote:

Originally Posted by wazu (Post 17327012)
If we just set up a new server from scratch, Xenforo or whatever, and had a cutover day where everybody is redirected to that new setup, isn't that enough? We could keep the old vBulletin 3.8 thing up under a different URL, and reference it as needed, but lock out all new posts. The old DB would stop growing, and the new server would be all new tech stack whatever and hopefully buy another 30 years. Maybe this has been proposed and shot down. I realize even this is still a project, but seems like one that is about as lightweight as could be hoped for.

Yes, it's a viable solution. We're starting to hit at the crux of the issue, though. In a sense, this is an engineering problem. We (and by we, I really just mean Kyle since the rest of us are just spitballing) are trying to optimize for a combination of:

-Short-term reliability
-Long-term maintenance requirements
-Ingrained user experience
-Possibilities for new features
-Discussion history
-Cost
-And probably a half-dozen other things

Tons of potential solutions, all that come with their own pros and cons.

displacedinMN 01-10-2024 02:17 PM

I like this format. I have seen others. Like Orange mange.....it sucked.

seamonster 01-10-2024 02:18 PM

Quote:

Originally Posted by scho63 (Post 17327100)
No one said it would be easy. I don't expect someone to sacrifice their job for a side hustle/hobby.

I think the bigger issue is what stays and what goes during any migration.

Maybe Kyle can put it to a vote - he can propose a few things.

Examples
A. Keep everything the same - no cost
B. Keep everything and migrate to a superior system. Cost 20K and 2 months
C. Toss certain things and delete other very old stuff. Cost 10k and 1 month

With 1 million tables, there are a massive amount of old threads and data that may have little to no replies. Shit can them.

Photos: massive amounts and establish a cut off for them. Maybe no photos older than 5 years.

It's not really bitching about the downtime as much as all the time spent bitching about the down time and no clear path after years.

Maybe Kyle can just say, **** it. It is was it is, so deal with it. I got no problem with that.

He can ask for volunteers or donations or show a plan so we can all help.

I'm not sure what he wants to make out of a new site. Building a complete site from scratch? Plugging some holes? Redevelop current site?

CP members are nothing short of shocking when it comes to pitching in. Just ask and maybe he might be surprised at all the help he gets.

A million rows is nothing...Especially if it's just a couple text columns. To me this sounds like some sort of hardware catastrophe that's befallen ChiefsPlanet.

DaFace 01-10-2024 02:20 PM

Quote:

Originally Posted by penguinz (Post 17327107)
@DaFace.... I haven't been in the backend of VBull in over a decade but if I recall correctly it defaults to storing all the attachments, avatars, etc in the DB. OK to do on small sites but not large ones like this.

I know the new version allows to change it to filesystem but not sure if the 3.x does.

Filesystem vs DB will be much faster and less load on the server. Could be a big reason the DB backups bring the server to a halt.

It's a reasonable question, but we've had attachments stored in the filesystem for a decade or so.

penguinz 01-10-2024 02:24 PM

Quote:

Originally Posted by seamonster (Post 17327118)
A million rows is nothing...Especially if it's just a couple text columns. To me this sounds like some sort of hardware catastrophe that's befallen ChiefsPlanet.

It's old software that requires old php and mysql. Throwing more horsepower at it is not going to get that much ROI.

If it was modern code and SQL I would be in more agreement with the hardware being part of the solution.

DaFace 01-10-2024 02:26 PM

Quote:

Originally Posted by seamonster (Post 17327118)
A million rows is nothing...Especially if it's just a couple text columns. To me this sounds like some sort of hardware catastrophe that's befallen ChiefsPlanet.

Again, it's just frustrating when people say stuff like this without knowing what you're talking about. A million rows (technically 16 million at the moment) is no problem...for an enterprise-level server cluster with a team of database administrators maintaining it.

We have one box that's realistically not much faster than a computer you could buy today at Best Buy that's largely maintained by one guy in his free time. Oh, and it's running on software that isn't even supported anymore.

It's like saying, "Well, any old PC can do 4K video editing these days" and pretending like it shouldn't be an issue for someone trying to do it on an Intel Celeron PC running Windows XP.

DaFace 01-10-2024 02:28 PM

Quote:

Originally Posted by penguinz (Post 17327135)
It's old software that requires old php and mysql. Throwing more horsepower at it is not going to get that much ROI.

If it was modern code and SQL I would be in more agreement with the hardware being part of the solution.

Don't get me wrong - new hardware will help, especially storing the database on SSDs. But it's just another bandaid, and if we keep running this old software, we'll almost certainly be due for yet another hardware upgrade in a few years, while modern software could set us up to handle additional growth much more effectively.

I've wanted to upgrade software for years, but a hardware migration takes 10% of the work that a software migration does (and still is a ton of work). Thus, the ~5-year cycle of new server upgrade that works well for a bit and then eventually runs into more issues.

scho63 01-10-2024 02:41 PM

So at the end of the day, it sounds like the antiquated software is the major roadblock.

Maybe the best solution is to start a brand new ChiefsPlanet with new software, lock ALL old threads from any new postings and signups, keep the site up for viewing and ads to generate income with a link on the new site, make everyone signup on the new site with their old user names, and then there is NO migration.

All you need is a new server.

Seems much faster, no migration of all the old stuff except user data.

Am I missing something? :hmmm:

George Liquor 01-10-2024 02:48 PM

Maybe we can all pool $100 together to wager on fanduel in hopes of getting a new server? I bet we can be there by Superbowl Sunday.


All times are GMT -6. The time now is 03:27 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.