The State of the Planet Address:AustinChief, Phobia, whoever...

[mikey23545]

Seems like you guys are having more and more trouble with the website...First the search, now I just read that the rep function is being limited in some way.

If money is the root of this problem, let's fix it.

How much would each of us have to fork over to maintain this website the way it needs to be maintained? Could it be paid monthly, or would it need to be paid annually? I would think if it is working in most regards, gratis, then it shouldn't be too expensive to get the bells and whistles running again.

I know I would be willing to pay a small monthly fee to keep the finest NFL BB on the internet running smoothly...How about every one else?

[|Zach|]

I feel the same way but we have been told it is not a money issue.

[4th and Long]

The rep function itself works fine. They just limited how many of your rep comments you can view now.

As for money, I've seen this question asked a hundred times with no real answer.

[go bo]

donations are always accepted, if i'm not mistaken...

[mikey23545]

donations are always accepted, if i'm not mistaken...

Well, I have donated in the past...I'm just wondering if the practice needs to be formalized...

Money buys bandwidth and storage. Is that not the answer?

[4th and Long]

donations are always accepted, if i'm not mistaken...
Really? Cool. Give me your checkbook, bo. I'm feeling rather generous at the moment. :D

[4th and Long]

Well, I have donated in the past...I'm just wondering if the practice needs to be formalized...

Money buys bandwidth and storage. Is that not the answer?
If moneys isnt really the isuue, I'd venture a guess and say that time is the issue.

[go bo]

Really? Cool. Give me your checkbook, bo. I'm feeling rather generous at the moment. :Dsure, i'll just set it on the monitor here...

[4th and Long]

sure, i'll just set it on the monitor here...
Good deal. I'll just grab it and ... *CLANK*

Oh sure. Pull the old, "leave the glass on the monitor so 4th will break his knuckles" joke.

Weisenheimer.

[go bo]

If moneys isnt really the isuue, I'd venture a guess and say that time is the issue.one of the mods could tell you for sure, but i guess i've seen it described as a bug in the software when they last upgraded and/or some technical problem that i have no idea what they're talking about...

but i'm pretty sure it's not the money that's causing the problems...

[mikey23545]

There's very few friggin' problems money doesn't solve....

[go bo]

Good deal. I'll just grab it and ... *CLANK*

Oh sure. Pull the old, "leave the glass on the monitor so 4th will break his knuckles" joke.

Weisenheimer.ROFL ROFL ROFL

see? never, ever trust anybody on the internet... (hee hee)

[go bo]

one of the mods could tell you for sure, but i guess i've seen it described as a bug in the software when they last upgraded and/or some technical problem that i have no idea what they're talking about... *edit* or something about the data base being too big?*edit*

but i'm pretty sure it's not the money that's causing the problems...oh, that's good...

now i'm hitting the quote button instead of the edit button...

i think i better go and dring another white russian for awhile...

[4th and Long]

one of the mods could tell you for sure, but i guess i've seen it described as a bug in the software when they last upgraded and/or some technical problem that i have no idea what they're talking about...

but i'm pretty sure it's not the money that's causing the problems...
If money is not the issue, then the obvious solution is to buy new software and upgrade, which leads me back to my point about time being an issue.

[go bo]

If money is not the issue, then the obvious solution is to buy new software and upgrade, which leads me back to my point about time being an issue.oh, now you're gonna go and use logic, huh?

you can lead a horse to water...

[4th and Long]

oh, now you're gonna go and use logic, huh?
Really doctor, your passion will be your undoing.
http://www.grudge-match.com/Images/spock.jpg
you can lead a horse to water...
Well ... I could ... if I owned a horse ... which I dont ...

[mikey23545]

If money is not the issue, then the obvious solution is to buy new software and upgrade, which leads me back to my point about time being an issue.

Well, I'm not trying to quarrel, but needing new software does sound like a money problem to me....

You green-blooded, inhuman...

[Phobia]

I'm as frustrated over this as the rest of you. I don't know the answers. I've tried to fix it. I don't know what to do. I think it's unfair to ask for donations when the product is performing shitty. Sorry I'm of no assistance.

[4th and Long]

Well, I'm not trying to quarrel, but needing new software does sound like a money problem to me....

You green-blooded, inhuman...
Again, if money is not the issue, if being the key word. Otherwise, I say we start a donation thread if we find out different.

And I am immensely pleased that my blood differs from yours, you red blooded, pink, suburbanite.

[4th and Long]

I'm as frustrated over this as the rest of you. I don't know the answers. I've tried to fix it. I don't know what to do. I think it's unfair to ask for donations when the product is performing shitty. Sorry I'm of no assistance.
Phil,

The point has escaped you. WE are asking to DONATE to the Planet. YOU are NOT asking for donations. Big difference bud.

[Iowanian]

The planet hasn't been the same since its Little Brother in NE came online.

Money didn't fix it last time.

[|Zach|]

Phil,

The point has escaped you. WE are asking to DONATE to the Planet. YOU are NOT asking for donations. Big difference bud.
It isn't a money issue...

[4th and Long]

The planet hasn't been the same since its Little Brother in NE came online.

Money didn't fix it last time.
For those of us not up to speed with that (me included) could you please elaborate?

[4th and Long]

It isn't a money issue...
Acording to Phil, in a way, it IS a money issue.
I'm as frustrated over this as the rest of you. I don't know the answers. I've tried to fix it. I don't know what to do. I think it's unfair to ask for donations when the product is performing shitty. Sorry I'm of no assistance.
Sounds to me like the software sucks.

Solution: New software

New software requires money.

[Iowanian]

For those of us not up to speed with that (me included) could you please elaborate?

There have been a couple of "Fund raisers" for the planet.

It hasn't done Jack Shit to improve performance from my perspective. I'd be happy to contribute if I was assured it would make a difference.

the Creator seems to have other things on his plate the past couple of....years.

[|Zach|]

Acording to Phil, in a way, it IS a money issue.

Sounds to me like the software sucks.

Solution: New software

New software requires money.
You are using huge leaps in logic.

One of them is that it is a software problem...

The other is that if it is a software problem it is money that is keeping the problem from not being a problem...

The next one is that if we had new software we wouldn't be in a bad position...just having software does not fix everything...someone has to do all of the backend work.

See where im going here?

[Phobia]

Here's what I know. The database is extraordinarily large. It should still function fine with a large database assuming you have the power to host it, which we do. The patriotsplanet site is irrelevent because it's an entirely differenct database and we're not bogging the server down.... When chiefsplanet is slow, patriotsplanet works fine.

If there is a database/PHP/Apache expert among our midst (and I believe there are), I'm going to kick Kyle in the nuts until he provides you access to fix the issues.

[|Zach|]

until he provides you access to fix the issues.
There it is folks...behold.

[Iowanian]

Is it possible to go in and nuke/trim some of the "worthless" threads and those with high volumes of Pics?

I know its blaspemy, but what would it do to trim the girly thread down to say....half its size?

[|Zach|]

Is it possible to go in and nuke/trim some of the "worthless" threads and those with high volumes of Pics?

I know its blaspemy, but what would it do to trim the girly thread down to say....half its size?
I am in favor of this.

[4th and Long]

So ... I get to go back to my, "time is the issue" stance and be correct?

[Bowser]

Is it possible to go in and nuke/trim some of the "worthless" threads and those with high volumes of Pics?

I know its blaspemy, but what would it do to trim the girly thread down to say....half its size?

Or even flush threads with 10 responses, or less?

[Phobia]

There have been a couple of "Fund raisers" for the planet.

It hasn't done Jack Shit to improve performance from my perspective. I'd be happy to contribute if I was assured it would make a difference.

the Creator seems to have other things on his plate the past couple of....years.

To be fair, the previous fundraisers were for hosting fees and vBulletin licensing. That money was consumed, has been consumed for quite some time.

[Phobia]

Is it possible to go in and nuke/trim some of the "worthless" threads and those with high volumes of Pics?

I know its blaspemy, but what would it do to trim the girly thread down to say....half its size?

Been tried. Every time I try to "trim" any threads, our database crashes.

[4th and Long]

To be fair, the previous fundraisers were for hosting fees and vBulletin licensing. That money was consumed, has been consumed for quite some time.
I'm glad you said that. I was beginning to worry that The Planet was run like the Missouri Department of Transportation for a second. Give 'em money for new roads and you get potholes for your trouble.

[Iowanian]

Thats fair.

I'm here enough to contribute and will...however...I'd feel alot better about it with a search function.

If It would help...You can nuke every Iowani-post over 1-2 years old...all of the pics posted...whatever.

I'm positive there are some "AOL" posts with alot of replies that say...nothing.

[Dr. Johnny Fever]

There's very few friggin' problems money doesn't solve....
Daniel Snyder would not agree.

[4th and Long]

Been tried. Every time I try to "trim" any threads, our database crashes.
As much as it pains me to ask this but, can't you delete the thread and let it start all over again? (i.e. The Babe Thread.)

[mikey23545]

Daniel Snyder would not agree.

Maybe I should have said "wisely spent money"...

[Phobia]

As much as it pains me to ask this but, can't you delete the thread and let it start all over again? (i.e. The Babe Thread.)

Wouldn't help. When I delete threads through the site browser that we all use, it maintains an entry in the database and I can actually go back at a later time and restore the thread. Essentially all that does is remove the display attribute. In order to actually nuke a thread, I need to do so from the Admin console. Every time I try to do anything (other than user admin) in the Admin console, I crash the database.

[mikey23545]

Is it possible to go in and nuke/trim some of the "worthless" threads and those with high volumes of Pics?

I know its blaspemy, but what would it do to trim the girly thread down to say....half its size?

Hey, if it would help I would advocate trashing the girly thread altogether.

Sweet Googly Moogly, like there aren't enough places on the web to find porn??!?!!?

[mikey23545]

mikey's right. Money can easily fix this.

mikey, I'm not sure what AustinChief's present annual salary is, but I'm sure if you were willing to donate that amount on an annual basis he'd be happy to quit his job and make the Planet his primary focus.

Sorry my attempt to help caused your caustic, smart-ass reply... Maybe you should sober up, or stay sober long enough to get over your hangover....

[4th and Long]

Wouldn't help. When I delete threads through the site browser that we all use, it maintains an entry in the database and I can actually go back at a later time and restore the thread. Essentially all that does is remove the display attribute. In order to actually nuke a thread, I need to do so from the Admin console. Every time I try to do anything (other than user admin) in the Admin console, I crash the database.
So let me get this straight.

In a nutshell, the software blows and there isnt jack you can do about it?

That about cover it?

[htismaqe]

FYI, there's a secondary issue here.

I'm not really sure that AustinChief wants it discussed in the open, so I'm not going to elaborate any more than to say that we have seen some traffic that would appear to be DoS attacks...

[keg in kc]

FYI, there's a secondary issue here.

I'm not really sure that AustinChief wants it discussed in the open, so I'm not going to elaborate any more than to say that we have seen some traffic that would appear to be DoS attacks...Oh jesus, don't tell me that shit's still going on.

[Phobia]

So let me get this straight.

In a nutshell, the software blows and there isnt jack you can do about it?

That about cover it?

No. vBull is the undisputed leader in message board software. We have a corrupt database.

[Phobia]

Oh jesus, don't tell me that shit's still going on.
No - not what you're implying. Just script kiddies.

[keg in kc]

No - not what you're implying. Just script kiddies.Okay, good. Well, not "good", you know what I mean...

[Mr. Laz]

Wouldn't help. When I delete threads through the site browser that we all use, it maintains an entry in the database and I can actually go back at a later time and restore the thread. Essentially all that does is remove the display attribute. In order to actually nuke a thread, I need to do so from the Admin console. Every time I try to do anything (other than user admin) in the Admin console, I crash the database.
would it be possible to backup and then wipeout the entire thing

fix the database and then start over



??


maybe try to import the old stuff back in later for search purposes

[Phobia]

Dunno Laz. That's all Kyle's department. He's answered the question on here before. There's some technical reason why it won't work. I'm kinda clueless there.

[Bowser]

What if we just boot all PatriotsPlanet people out of their digs, and into this one? They have three SB trophies in four years, the least we should have is a worry free database.

EAT IT, AMNORIX!!

[RINGLEADER]

So, after reading this thread I'm still not quite sure if money is or isn't the problem.

If it's money I'd be happy to help...but like the other guy said upthread, I'd want to know that it's going to fix the problems.

It sucks having to read Taco's website on draft day because this one doesn't work.

[|Zach|]

I think it seems obvious money is not the problem

[OldTownChief]

I think it seems obvious money is not the problem

After the last few days it seems like the search function wasn't either.

[Mile High Mania]

Well.. if this place ever shuts down again, feel free to set up camp over at on our fantasy boards.

[Amnorix]

What if we just boot all PatriotsPlanet people out of their digs, and into this one? They have three SB trophies in four years, the least we should have is a worry free database.

EAT IT, AMNORIX!!

Geez, talk about no love...


You can take away the PatriotsPlanet, but you can't take away those three Lombardis in my avatar...


:p:p:p

[RINGLEADER]

I think it seems obvious money is not the problem


:shrug:

Okay, I'm moving on...Someone let me know if Zach's wrong though because I'd be happy to ante up if you guys need it...

[Bowser]

Geez, talk about no love...


You can take away the PatriotsPlanet, but you can't take away those three Lombardis in my avatar...


:p:p:p

Those are very nice trophies, and I'm very envious.

Now pack your shit up, and tell your cronies at PP to do the same, cause we're coming in!






:evil:

[Mr. Laz]

Dunno Laz. That's all Kyle's department. He's answered the question on here before. There's some technical reason why it won't work. I'm kinda clueless there.
k....

i don't make any claims to be a computer expert or anything but it seems like 2 things can fix just about any problem that exists.

1. change servers and/or software

solution: money and/or time ... i imagine there are people around here would will help with one or the other.

2. data corruption

solution: delete that whole dam thing and start over ... kinda like reformatting your hard drive and installing your OS all over again.


i seem to recall some kind of issue about not being able to get access to the servers because of a lousy server company. In which case do solutions 1 AND 2.

[RINGLEADER]

k....

i don't make any claims to be a computer expert or anything but it seems like 2 things can fix just about any problem that exists.

1. change servers and/or software

solution: money and/or time ... i imagine there are people around here would will help with one or the other.

2. data corruption

solution: delete that whole dam thing and start over ... kinda like reformatting your hard drive and installing your OS all over again.


i seem to recall some kind of issue about not being able to get access to the servers because of a lousy server company. In which case do solutions 1 AND 2.


Well, in that vein, can't you just freeze the current database where it is, copy it, set up the "CLASSIC" Chiefsplanet with that data and then do what you say in point number 2 above.

That way you'll still be able to access the older threads (but maybe not write to them anymore), keep them for history's sake, and have a new database that isn't weighed down by all the other stuff.

Plus, the other upside, is someone will finally win the Last To Post threads...

[|Zach|]

The person in charge has to be willing to outsource the ability for this place to be helped.

[Bowser]

Well, in that vein, can't you just freeze the current database where it is, copy it, set up the "CLASSIC" Chiefsplanet with that data and then do what you say in point number 2 above.

That way you'll still be able to access the older threads (but maybe not write to them anymore), keep them for history's sake, and have a new database that isn't weighed down by all the other stuff.

Plus, the other upside, is someone will finally win the Last To Post threads...

If by chance that ever happens, I propose now that whoever starts the new Last to Post......thread be banned immediately, with no GoChiefs resurrection!

:cuss:

[Mr. Laz]

Well, in that vein, can't you just freeze the current database where it is, copy it, set up the "CLASSIC" Chiefsplanet with that data and then do what you say in point number 2 above.

That way you'll still be able to access the older threads (but maybe not write to them anymore), keep them for history's sake, and have a new database that isn't weighed down by all the other stuff.

Plus, the other upside, is someone will finally win the Last To Post threads...
yea... i was thinking kinda the same thing. the copy could even be moved to a different server so that it wouldn't bog down the new one.
would it be possible to backup and then wipeout the entire thing

fix the database and then start over??

maybe try to import the old stuff back in later for search purposes

[JakeT]

What DB is thing running on?

[Amnorix]

Those are very nice trophies, and I'm very envious.

Now pack your shit up, and tell your cronies at PP to do the same, cause we're coming in!






:evil:

ROFLROFLROFL

[RINGLEADER]

yea... i was thinking kinda the same thing. the copy could even be moved to a different server so that it wouldn't bog down the new one.


I've got about 150 servers sitting in my basement...I could spare one if you need it...

[|Zach|]

The person in charge has to be willing to outsource the ability for this place to be helped.

[siberian khatru]

I've got about 150 servers sitting in my basement

Right next to the gimp, eh Zed? :p

[OldTownChief]

Right next to the gimp, eh Zed? :p

ROFL The gimps sleepin

[Saulbadguy]

The database is huge. I haven't been to too many large messageboards that keeps its threads active for such a long time (a few years). If the database is indeed corrupt (probably from letting it get so huge and not maintaining it), it should be wiped out.

[Mile High Mania]

Might as well just destroy all threads and archives prior to 2004. Why not? Who really cares about that crap.

[Braincase]

How about a bake sale?

[Hammock Parties]

Might as well just destroy all threads and archives prior to 2004. Why not? Who really cares about that crap.

Alot of people do, actually. We should move it offsite.

That way we could actually search it! What an idea!

[Saulbadguy]

Well, in that vein, can't you just freeze the current database where it is, copy it, set up the "CLASSIC" Chiefsplanet with that data and then do what you say in point number 2 above.

That way you'll still be able to access the older threads (but maybe not write to them anymore), keep them for history's sake, and have a new database that isn't weighed down by all the other stuff.

Plus, the other upside, is someone will finally win the Last To Post threads...
If the database wasn't "corrupt", that could work.

[|Zach|]

Heh, this post might be even less helpful than my last one.
ROFL

[go bo]

Wouldn't help. When I delete threads through the site browser that we all use, it maintains an entry in the database and I can actually go back at a later time and restore the thread. Essentially all that does is remove the display attribute. In order to actually nuke a thread, I need to do so from the Admin console. Every time I try to do anything (other than user admin) in the Admin console, I crash the database.damn...

i just knew we shoulda went ahead and sent you to drivers' ed... :(

[go bo]

FYI, there's a secondary issue here.

I'm not really sure that AustinChief wants it discussed in the open, so I'm not going to elaborate any more than to say that we have seen some traffic that would appear to be DoS attacks...dos, eh?

i used to write litle "programs" in dos...

i was so proud that i could actually write batch files and the like...

ahhhh... those were the days... :D

[go bo]

No. vBull is the undisputed leader in message board software. We have a corrupt database.jeez, where's ellitiot ness when you really need him?

[Hammock Parties]

So basically we're stuck with a giant boil on our ass and there's no way to get rid of it short of cutting off our entire ass?

[go bo]

I've got about 150 servers sitting in my basement...I could spare one if you need it...hey! slavery was outlawed a long time ago...

[Saulbadguy]

hey! slavery was outlawed a long time ago...
ROFL!!

[Hammock Parties]

Go bo has such an odd sense of humor...

[Bowser]

The person in charge has to be willing to outsource the ability for this place to be helped.

So, in the end, it IS about the money.

[Mile High Mania]

So basically we're stuck with a giant boil on our ass and there's no way to get rid of it short of cutting off our entire ass?

You're still talking about the server issue, right?

[go bo]

Go bo has such an odd sense of humor...awww, sweetie...

i thought you'd never notice... *kiss, kiss*

[|Zach|]

So, in the end, it IS about the money.
No, I don't think so.

[Mr. Laz]

So, in the end, it IS about the money.

that could be a pride thing... wants to solve it by himself :shrug:



btw- no offense meant, solving computer problems by yourselve can be a challenge type thing

[Hammock Parties]

You're still talking about the server issue, right?

Yes.

[Mile High Mania]

Laz, it's probably your sig line on 150 different threads sucking the power out of the planet...

[Mr. Laz]

Laz, it's probably your sig line on 150 different threads sucking the power out of the planet...
ROFL

actually they aren't hosted by the chiefsplanet server

[PastorMikH]

The patriotsplanet site is irrelevent because it's an entirely differenct database and we're not bogging the server down.... When chiefsplanet is slow, patriotsplanet works fine.




How about we move everything from the Planet over to the Patriotsplanet, then move all their stuff here. Then they get the sucky performance and we get the smooth running site?


:)

[go bo]

ROFL

actually they aren't hosted by the chiefsplanet serverwell, from this side of the screen, it looks like your dushku girl pic isn't being hosted by anybody...

[Bowser]

How about we move everything from the Planet over to the Patriotsplanet, then move all their stuff here. Then they get the sucky performance and we get the smooth running site?


:)

ECHO, echo, echo.......


psst, I beat you to that one by about 30 posts or so, Mike!


;)

[PastorMikH]

ECHO, echo, echo.......


psst, I beat you to that one by about 30 posts or so, Mike!


;)



Well SORRRRRRYYYYYY! :p


After reading the first 50 posts I became bored and quit reading further.


Besides, people will listen to me that normally ignore you.:p:fire::D


j/k

[Bowser]

Well SORRRRRRYYYYYY! :p


After reading the first 50 posts I became bored and quit reading further.


Besides, people will listen to me that normally ignore you.:p:fire::D


j/k

ROFL

Touche'.

One day, by golly, I'll swing a heavy bat around this place.......

[Phobia]

ROFL

Touche'.

One day, by golly, I'll swing a heavy bat around this place.......

That's not any reason to threaten us with your wife....

[BigRedChief]

Here's what I know. The database is extraordinarily large. It should still function fine with a large database assuming you have the power to host it, which we do. The patriotsplanet site is irrelevent because it's an entirely differenct database and we're not bogging the server down.... When chiefsplanet is slow, patriotsplanet works fine.

If there is a database/PHP/Apache expert among our midst (and I believe there are), I'm going to kick Kyle in the nuts until he provides you access to fix the issues.

I've got my MCDBA and have run a PHP BB for years in the past. We had these same issues that this bb is experiencing. We just kept the database under 75 megs at it purred along. We went to the php site and chatted on the help page and resolved most of our issues pretty easily. They are pretty helpful over there. Most of our issues that we thought were going to be hell to fix were just minor tweaks.

Get yourself an alais/username and go to these sites http://php.resourceindex.com/Community/Bulletin_Boards/

ask around. You never know it may be something really simple.

[BigRedChief]

forgot to add that the phpbuilder.com was the best one IMHO. They are real helpful.

[Hammock Parties]

I think the issue is that they can't trim the database. It's corrupt.

[Bowser]

That's not any reason to threaten us with your wife....

Yeah, just remember YOU said that, and I'm an innocent bystander.





:D

[go bo]

Yeah, just remember YOU said that, and I'm an innocent bystander.





:Dheh heh heh, nobody's innocent... :fire:

[BigRedChief]

I think the issue is that they can't trim the database. It's corrupt.

If so I bet those gurus over at phpbuilder would appreciate a chance to show off their skills.

[Logical]

Acording to Phil, in a way, it IS a money issue.

Sounds to me like the software sucks.

Solution: New software

New software requires money.


The problem with that, if it is a problem is Kyle (AustinChief) has to spend a tremdous amount of time putting in all the hacks that make this site work the way it works, transfer the database and get everything running smoothly. Once you talk new software time becomes an issue as I understand it.

[Undertaker #59]

How about we move everything from the Planet over to the Patriotsplanet, then move all their stuff here. Then they get the sucky performance and we get the smooth running site?


:)


Oh sure. Then you'll just break our site too and we'll be stuck with TWO broken boards. :p

[chiefs4me]

Oh sure. Then you'll just break our site too and we'll be stuck with TWO broken boards. :p


yea, well, what can we say......we don't care about your site....ROFL

[htismaqe]

The problem with that, if it is a problem is Kyle (AustinChief) has to spend a tremdous amount of time putting in all the hacks that make this site work the way it works, transfer the database and get everything running smoothly. Once you talk new software time becomes an issue as I understand it.

That's one of the biggest issues.

About 80% of the things people "love" about this place are hacks created by Kyle.

He could upgrade the software, but people would bitch because they're missing their favorite "feature"...

[JakeT]

Guys I work for an Internet startup (yeah I know they still do exists) anyway we're doing a kind of google thing and we've got some really smart guys who are pretty cool -- I can ask them some questions that may help out.

They told me to find out what database the thing is running on - also said that most database can't handle more than 500 hits at the same time. And that searching text is very hard on the db -- so the db, and how it is set up is the Key.

Does that make sense to anyone?

[chiefz]

I'm as frustrated over this as the rest of you. I don't know the answers. I've tried to fix it. I don't know what to do. I think it's unfair to ask for donations when the product is performing shitty. Sorry I'm of no assistance.

Have you thought about pruning the forum?

I would imagine the SQL database here has to be tremendous...

Can you even optimize the tables anymore?

[Phobia]

Have you thought about pruning the forum?

I would imagine the SQL database here has to be tremendous...

Can you even optimize the tables anymore?

Asked and answered.

[Brock]

Should be a paysite. Keeps out the riff-raff.

[chiefz]

Asked and answered.

Well, I read some of it, if the database is in fact corrupted I don't see how SQL would no lock up completely with an error because the indexes do not match the length of the data files.

Have you by any chance found which table is the problem?

You might be able to alliviate some of the post database size by manually dropping some of the data through PHP My Admin, once you have the database selected find the "posts" table.

Not sure what it is with VBulletin but I would imagine it will be something_post.

Then sort the posts by post ID in ascending order.

Check the ones that you want gone (I would imagine it would be a ton) and select delete.

Once you get the table down smaller enough try optimizing the entire table to match the indexes back up.

I would STRONGLY recommend doing this after a complete backup with the size of this database.

[Phobia]

I don't know, chiefz. I'm not a db guy. This is Kyle's problem. The longer he lets it go, the more people are going to get frustrated. Frustrated people leave - which works to your advantage.

[Mark M]

Should be a paysite. Keeps out the riff-raff.

You elitist pig ...

MM
~~;)

[Brock]

If they really wanted to fix the problem, they'd just dump that pile of shit known as the DC forum, and ban anybody who can't stay off the political subjects.

[chiefz]

I don't know, chiefz. I'm not a db guy. This is Kyle's problem. The longer he lets it go, the more people are going to get frustrated. Frustrated people leave - which works to your advantage.

Phobia, I would think that people leaving would work to your disadvantage, unless you mean to my advantage personally and the last thing I want is is the Planet to die, its like my vaction spot. lol

At any rate, tell them to drop me an e-mail administrator@chiefshuddle.com and I can try and help them figure it out.

Again, I don't know squat about the build of the VBulletin DB but it is essentially just naming conventions, otherwise SQL is all the same.

Should be fairly easy to find a SQL map for VBullentin somewhere though I would imagine.

[mrbiggz]

Wouldn't help. When I delete threads through the site browser that we all use, it maintains an entry in the database and I can actually go back at a later time and restore the thread. Essentially all that does is remove the display attribute. In order to actually nuke a thread, I need to do so from the Admin console. Every time I try to do anything (other than user admin) in the Admin console, I crash the database.

It sounds like we need a new bboard designed from the ground up.

[BigRedChief]

Well, I read some of it, if the database is in fact corrupted I don't see how SQL would no lock up completely with an error because the indexes do not match the length of the data files.

Have you by any chance found which table is the problem?

You might be able to alliviate some of the post database size by manually dropping some of the data through PHP My Admin, once you have the database selected find the "posts" table.

Not sure what it is with VBulletin but I would imagine it will be something_post.

Then sort the posts by post ID in ascending order.

Check the ones that you want gone (I would imagine it would be a ton) and select delete.

Once you get the table down smaller enough try optimizing the entire table to match the indexes back up.

I would STRONGLY recommend doing this after a complete backup with the size of this database.

I was assuming that this has already been done. Why would you keep bb "stuff" longer than a year if you are having issues with the DB?

[Mr. Laz]

bump for all the doinks that are starting a new thread about this



:moon:

[Straight, No Chaser]

http://www.chiefsplanet.com/BB/showpost.php?p=2325827&postcount=24
<>snip<>
I have been working on it since yesterday afternoon. The problem is not the server or the software.. it is the size of the database... I have backed it up and am now pruning all the old threads... but unfortunately.. it is very time intensive.. so expect delays until it is done.

--Kyle

<>/snip<>

Get rid of the database. The best feature of the site is it's ability to display posts quickly... combined with the variety of individuals who provide [sometimes] insightful and timely information. The rest of the garbage is superfluous.


PHP stands for "Please Hope & Pray"


--->