Bridge Commander Central
Recreational Forums => Forum Discussion => Topic started by: Sean on December 29, 2009, 06:43:34 PM
-
Hi All
As I'm sure you are aware, BCC has had a few technical issues recently, in particularly due to the size of the database.
Over the next week or so, I will be speaking to the staff to agree a few actions which will hopefully result in the forum and database becoming more stable. This will most likely involve removing inactive users with 0 posts and also the removal of unused boards and old posts.
As a result some of your post counts may be affected.
We will not be removing any posts which have been posted in during 2008 and 2009.
Thank you for your time
BCC Admin Team
-
Any idea which boards are going?
In b4 ZOMG MY P0ST COUNT!!!111!!one
Edit: Also, is it time for another voluntary PM in/outbox cleanup? I have already done so.
-
heh interesting.... well I hope the forums do become more stable after that, however be sure you aren't getting rid of any technical or other bc related posts that people may want to read to fix issues. (but I'm sure you know this already)
-
Lets just hope, it?ll fix the problems!
-
it would be a shame to lose anything in the BC Modding, Scripting, Bridges, and Tech Support...
is there no other alternative other than deleting posts?
-
well if we have to delete some of those posts... maybe saving them and then reentering some of the important info onto the wiki may help...
-
well if we have to delete some of those posts... maybe saving them and then reentering some of the important info onto the wiki may help...
I second that, that sounds like a good idea if theres no other alternative.
-
compress some in txt format and post them somewhere on the site, might save space
-
Maybe you might try to separate the modding forum in too 4 smaller sub forums. Like clicking on bc modding, and then the next page that pops up would have a forum listed Ent/TOS TMP TNG/VOY/DS9 and BEYOND. And to help, the authors of each topic could pm you there link to there topic and state witch forum they belong to. THis way when your looking for a ship wip's it will be easer to find and it will be more orginized for later cleaning. That and it would force modder'ss that have one wip's topic to post in there own topic in each sub forum so later when cleaning happends, old post can be cleaned.
-
Also, is it possible to post pictures of ships, etc off-site and just post a link to the picture? I know that pictures use up a lot of space.
-
Also, is it possible to post pictures of ships, etc off-site and just post a link to the picture? I know that pictures use up a lot of space.
It's the size of the database thats the problem. Hosting pics off-site wouldn't really help, and would just slow down the loading of pages. Well over half the users on here haven't posted anything.
How about also removing users who haven't visited in over a year as well as those with no posts? Also, now that we have a wiki site, could pics and things of old WIP's (say the from 2007 backwards, which accounts for the last 4 pages of BC Modding, so maybe about 10% of the total posts visible to all) as well as the solved tech support issues not be shifted there?
-
Cant be just compressed the old posts. To be zipped?
-
also if there was a way to temperarly give the power to the owner of a topic to remove uneeded post they could do there own house cleaning. Much like in the pm page for your mail. Also there could be an arcives forum. Expanding on what Limey, any topics older then 2008 could be moved to an arcives forum, ore even a topic. All that would be needed to be saved from a dead topic older then 2008 would be any updates major updates, so you have lets say 4 post as an example, the starting of the project, the finshed model, the textered model, and the in game test. So lets say that topic from 2007 had 37 pages for one mod, removing everything but the core mod would drop it to 1 page. Then move it out of the active modding forum and place it in an arcive forum or topic. You could have a masted post if you used it in a topic that would have the mod name, maker and date, and next to that have the page number so lets say you want to see mod x in the arcives topic, i would go to the first post, find mod x and see the page number and then i could skip ahead to that page.so it would be condencing 100 topics to 1.
-
why not store it on my site?, i have alot of space
-
Hi all
Thanks for all of your suggestions. Just to clear up whats been done so far, and what we still need to do.
Done So far
- Removed Members that have never activated their accounts (currently 63)
- Removed Members that have never logged in (just over 100 of these)
- Removed 205 pages of moderation logs
- Removed 48061 pages of forum error logs
- Removed Archive Forum for removed posts
- Removed unused Member Groups
Need to do
- Remove inactive users (those not logged in for 365 days
- Remove old modding posts prior to 2008
- Remove current affairs board
I will not start removing anything from the modding boards until 07-Jan-2010. If you wish to back anything up to BC WIKI, then you are free to do so.
Please note i will not be removing any FAQs, Tutorials, How to's or "Help me fix a problem" threads.
Thanks
-
do we need to touch any of the forums; is all that has been cleared out enough for stability now? id really hate to lose any BC-related threads...
-
- Remove inactive users (those not logged in for 365 days
Wouldn't that be a bad idea? I know a few members here have come back after a much longer absence than that.
-
you should make all of the old forums in txt and have them available as dls on bcfiles, like a tech support section.
also you should put some news on bcfi8les to people who lurk around there, I saw MRJOHN there, 2 weeks ago, but he is never here.
-
I would say those with fewer than 20 posts who've not logged in to the forum atleast once in the past year. They obviously aren't interested. See where that gtes things.
-
what about the unlucky sods who are currently enlisted in the army?
-
I would say those with fewer than 20 posts who've not logged in to the forum atleast once in the past year. They obviously aren't interested. See where that gtes things.
an email asking all members to sign in has been sent. anyone who has not signed in by 07-Jan-2010 will be removed. To start we will be following the above suggestion. If that does not increase the efficiency we will have to look at other inactive users.
Some users have not signed in for over 3 years. Im sure if they wish to post again they can just re-sign up. Better to have a functioning forum than one with lots of members with database issues.
Thanks again
Sean
-
Now i figure you must be using MySQL for database, and when that database becomes unstable, we're talking about alot of data.
Generally I usually do the same as you will be doing. Take out old users, and remove dead posts.
Also: Are you using pictures from the database, or are they uploaded as physical files? If any files are generated from the database this will take alot out of the database, and you should start making people upload them physically instead...
Of cause you already know all this, but I figure that others might like to know.
-
I would say those with fewer than 20 posts who've not logged in to the forum atleast once in the past year. They obviously aren't interested. See where that gtes things.
an email asking all members to sign in has been sent. anyone who has not signed in by 07-Jan-2010 will be removed. To start we will be following the above suggestion. If that does not increase the efficiency we will have to look at other inactive users.
Some users have not signed in for over 3 years. Im sure if they wish to post again they can just re-sign up. Better to have a functioning forum than one with lots of members with database issues.
Thanks again
Sean
Except said email used a date format that is backards from the usual m/d/y and may lead some to believe that 7/1/10 is actually July 1st, 2010.
-
Except said email used a date format that is backards from the usual m/d/y and may lead some to believe that 7/1/10 is actually July 1st, 2010.
Known to the rest of the world as the "normal" date format. One that actually makes sense and is meaningful (little endian) as opposed to the format that I believe is only (exclusively) used in America.
I had a thought earlier. What about culling all posts with less than, say, 10 characters. Cos, let's face it, there's no way a post that short could possibly be in the slightest bit constructive, and I reckon a not-insignificant number of posts fit the bill.
-
unless it's a model update where someone has made a short bit of text (update) and the rest is attachments..
-
unless it's a model update where someone has made a short bit of text (update) and the rest is attachments..
Then a check can be done to see if the post has attachments. To quote a certain meerkat, "Simples! *Squeak*".
-
an email asking all members to sign in has been sent. anyone who has not signed in by 07-Jan-2010 will be removed.
just to keep you all updated, As of today, i have removed any inactive users who had a post count of less than 20 and have not posted in 365 days. This has removed 42 pages worth of inactive users. Rough count is 1260 inactive.
-
I imagine most of that may have been spambots of some description anyway so I wouldn't lose sleep over it.
-
I imagine most of that may have been spambots of some description anyway so I wouldn't lose sleep over it.
LOL some of them were lol.
Anyway just another update, have cleared any posts from 2006-2007 that were only old WIP threads. any useful info on problems and help are still there.
-
Don't suppose community links could be moved to the very bottom like before? It looks disproportionate at the minute.
Edit: Thats better. :)
-
Don't suppose community links could be moved to the very bottom like before? It looks disproportionate at the minute.
Edit: Thats better. :)
Realised when i came back to the main index that i had mis placed it. Thanks for the input
-
what about the unlucky sods who are currently enlisted in the army?
i second that concern. also what about those people that are newly joined?
how about getting rid of such posts like the "love/hate" one, if it means keeping important BC related ones i'm sure no one will miss these sort of topics.
-
how about getting rid of such posts like the "love/hate" one, if it means keeping important BC related ones i'm sure no one will miss these sort of topics.
i dont agree with that... the General Discussion forum, and the stickied threads, are all very much active... and if this were to be a BC-only forum, it would make things alot harder on the staffers to keep it like that... besides, the non-BC threads/forums keep it more interesting, and the General Discussion threads are sort of like an "off-time" relaxed area...
-
hmm have there been some post/thread purgings lately?
-
why do you ask?
-
20 of my posts when bye bye
just got me curious.
-
Oh dear, I've heard stories about you and what happened when your post count dropped on BCU.
-
:facepalm: no need for that....
-
20 of my posts when bye bye
just got me curious.
right - in the General Discussion Forum, every thread that winds up on page 2 (threads not responded to for like usually 6 months ago) gets deleted... this is so as to do our best to not overload the current server (thus a forum crash which has happened a number of times in BCC's history), hence the point of this thread you bumped...
the last thread deleted was a 10 page one, the "Remember BCU" thread, which was 10 pages long... when a new thread is made in that forum, the oldest one goes bye-bye...
i also lost many postcounts as a result of saying bye-bye to that thread, but you dont see me wondering or worrying; alot of us who posted in that thread lost a number of postcounts (and alot of us did ;)) :P
Oh dear, I've heard stories about you and what happened when your post count dropped on BCU.
heh neb also asked for an explanation back then too lol :P
remember - you are not your postcount... the higher your postcount doesnt make you "cooler"... jeez, neb - i would have thought you would have learned that by now waaaaay after BCU, do you really track your postcount lol j/k :P
it's not about numbers, it's about substance... dammit, neb, i thought we grained that into your skull years ago lol *kicks neb*
LOL WOW COOL
*ducks the revolver*
-
*fires off revolver* only asked for an explanation.... though I would have thought to at least keep that one thread... all others are subject for deletion :P
-
hmmm it just occurred to me that i can manually change someone's postcount here now :evil:
i wonder if i could put someone's postcount to -5000? hehe *looks at neb* :P
or perhaps if im in a good mood, i could put it to 50000 lol :D
-
LOL na I don't think you could put a - ... sov already tried that over at BCS.
-
hmmm it just occurred to me that i can manually change someone's postcount here now :evil:
i wonder if i could put someone's postcount to -5000? hehe *looks at neb* :P
or perhaps if im in a good mood, i could put it to 50000 lol :D
I think someones gone mad with power.... :evil:
-
That can always be fixed neb.
-
:funny zing!
*cookied*
-
LOL *laughs for the hell of it*
-
I'm sure we could persuade SFHQ to fix that for ya over at 9th FLT too. :P
-
speaking of SFHQ he'd make a good webmaster here.
-
Whats wrong with the current one?
-
BCC doesnt have a full-time "Webmaster"... any problems (crashes) with the site currently falls on Mark's shoulders, but he is only available if there is an emergency...
as far as daily maintenance, or adding new smf mods, or other general webmastering stuff, we currently dont have anyone for that...
-
speaking of SFHQ he'd make a good webmaster here.
maybe that's not a bad idea neb
-
And for your needs, due to smf sometimes being a pain in the ass, the webmaster should have some knowledge in php.
-
speaking of SFHQ he'd make a good webmaster here.
And for your needs, due to smf sometimes being a pain in the ass, the webmaster should have some knowledge in php.
I do believe SFHQ is God with php. :P
-
i agree BCC needs a full-time webmaster... there will prolly be one appointed at some time in the future...