2014-15 Season Recap Thread Disappeared/Deleted???

Here you'll find helpful tips regarding the operation of the Discussion Boards at First Tracks!! Online, as well as general announcements for our users.

2014-15 Season Recap Thread Disappeared/Deleted???

Postby Admin » Tue Jun 30, 2015 9:46 am

Tony Crocker wrote:
And perhaps admin could attend to FTO a bit more and tell us where the 2014-15 season recap thread went??? :stir:


No clue.
Image

Image
User avatar
Admin
Site Admin
 
Posts: 9969
Joined: Wed Sep 22, 2004 9:32 am
Location: Salt Lake City, Utah

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Tony Crocker » Tue Jun 30, 2015 11:13 am

So aren't you concerned that a thread can just disappear into thin air?

How often is the FTO server backed up? If there's a backup from late May or early June you might be able to retrieve the thread.
http://bestsnow.net
Ski Records
Season length: 21 months, Nov. 29, 2010 - July 2, 2012
Days in one year: 80 from Nov. 29, 2010 - Nov. 17, 2011
Season vertical: 1,610K in 2016-17
Season powder: 291K in 2011-12
User avatar
Tony Crocker
 
Posts: 9799
Joined: Thu Sep 23, 2004 10:37 am
Location: Avatar: Charlotte Bay, Antarctica 2011
Location: Glendale, California

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby jamesdeluxe » Tue Jun 30, 2015 1:31 pm

See what happens after the years of bellyaching and drama queenery about me a posting season recap thread during early April, as if that makes any difference? An unreliable OP takes over then deletes the entire thread!
User avatar
jamesdeluxe
 
Posts: 3319
Joined: Mon Oct 04, 2004 3:19 pm
Location: South Orange, NJ

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Admin » Tue Jun 30, 2015 2:07 pm

Tony Crocker wrote:So aren't you concerned that a thread can just disappear into thin air?

How often is the FTO server backed up? If there's a backup from late May or early June you might be able to retrieve the thread.


The forums' SQL database is backed up regularly. However, that backs up the entire database, not individual posts. Restoring from backup therefore means that the entire database is overwritten, so all subsequent posts (and all subsequent forum activity) created after the backup date will disappear. In other words, be careful what you wish for.

That said, I just checked the server logs and somehow, it seems that I did it:

Code: Select all
Admin   [IP addressed removed by Admin]   12 Jun 2015 03:56 pm   Deleted topic “14-15 Season Ski Day Count” written by » EMSC


At the very same time there's another entry created by my actions when I deleted a spam post written by "addseo1115", a spammer who apparently can't even conceal the intent adequately demonstrated by their username:

Code: Select all
Admin   [IP addressed removed by Admin]   12 Jun 2015 03:56 pm   Banned user for reason “Spam”» addseo1115


It appears that the topic was deleted rather than just the spam post. Whether this was through my own stupidity, or whether it's a flaw in Tapatalk (which I was almost assuredly using at the time), I don't know. In any event, I sincerely apologize to all those affected.

So, I apparently "Crockered." I guess that makes us even for this:

Code: Select all
Tony Crocker   [IP addressed removed by Admin]   19 Jun 2015 01:36 pm   Edited post “Jay Peak Summit: Most Snow in the Lower 48 in 2014-15???” written by » Admin
Image

Image
User avatar
Admin
Site Admin
 
Posts: 9969
Joined: Wed Sep 22, 2004 9:32 am
Location: Salt Lake City, Utah

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Marc_C » Tue Jun 30, 2015 3:18 pm

Admin wrote:Whether this was through my own stupidity, or whether it's a flaw in Tapatalk (which I was almost assuredly using at the time), I don't know.

What site admin in their right mind would be crazy enough to do site management via Crapatalk?
-marc
User avatar
Marc_C
 
Posts: 3173
Joined: Thu Mar 24, 2005 10:32 am
Location: A Sandy place south of a Great Lake

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Marc_C » Tue Jun 30, 2015 3:23 pm

Admin wrote:The forums' SQL database is backed up regularly. However, that backs up the entire database, not individual posts. Restoring from backup therefore means that the entire database is overwritten, so all subsequent posts (and all subsequent forum activity) created after the backup date will disappear.

If you could restore the backup db to a different environment than production, then the SQL to extract that thread and then merge it into the production db is pretty simple (assuming one knows the table schema of the discussion db). The script might have to monkey with UIDs a bit but even that isn't too difficult.
-marc
User avatar
Marc_C
 
Posts: 3173
Joined: Thu Mar 24, 2005 10:32 am
Location: A Sandy place south of a Great Lake

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Admin » Tue Jun 30, 2015 3:42 pm

Marc_C wrote:
Admin wrote:The forums' SQL database is backed up regularly. However, that backs up the entire database, not individual posts. Restoring from backup therefore means that the entire database is overwritten, so all subsequent posts (and all subsequent forum activity) created after the backup date will disappear.

If you could restore the backup db to a different environment than production, then the SQL to extract that thread and then merge it into the production db is pretty simple (assuming one knows the table schema of the discussion db). The script might have to monkey with UIDs a bit but even that isn't too difficult.

That would require building a test environment, and merging the databases is beyond my pay grade.
Image

Image
User avatar
Admin
Site Admin
 
Posts: 9969
Joined: Wed Sep 22, 2004 9:32 am
Location: Salt Lake City, Utah

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Tony Crocker » Tue Jun 30, 2015 3:56 pm

admin wrote:So, I apparently "Crockered." I guess that makes us even for this:

Uhh, not exactly. I deleted ONE post, realized the error within minutes, reposted it according to what I remembered, and sent admin an e-mail heads-up in case I forgot something so he could fix it.

Admin deleted an entire thread with posts from at least 4 users (I think) on June 12 and never realized that he even made the mistake. One week ago I inquired privately in an e-mail titled "Am I Hallucinating, Getting Senile?" which James corroborated the next day and admin ignored until posted publicly here yesterday.

At any rate I'm relieved it was human error and not a software bug or a hacker.

MarcC wrote:What site admin in their right mind would be crazy enough to do site management via Crapatalk?

I agree with this. Sometimes Tapatalk works about as well as an Internet browser, sometimes definitely not. The only feature it ever saves me is having to log in.

MarcC wrote:If you could restore the backup db to a different environment than production, then the SQL to extract that thread and then merge it into the production db is pretty simple (assuming one knows the table schema of the discussion db). The script might have to monkey with UIDs a bit but even that isn't too difficult.

admin wrote:That would require building a test environment, and merging the databases is beyond my pay grade.
I can't speak for James, EMSC, etc., but if it's lot of work to do the restore I have no problem with reposting my part of the lost thread.
http://bestsnow.net
Ski Records
Season length: 21 months, Nov. 29, 2010 - July 2, 2012
Days in one year: 80 from Nov. 29, 2010 - Nov. 17, 2011
Season vertical: 1,610K in 2016-17
Season powder: 291K in 2011-12
User avatar
Tony Crocker
 
Posts: 9799
Joined: Thu Sep 23, 2004 10:37 am
Location: Avatar: Charlotte Bay, Antarctica 2011
Location: Glendale, California

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Admin » Tue Jun 30, 2015 4:49 pm

With my lack of SQL knowledge it would require either hiring a developer or investing 20 or 30 hours of my time, by my estimation, still with no guarantee of success.

And I've been really, really bad lately at reading or maintaining my email.

Finally, regarding Tapatalk I've never had any problems before with using it to moderate, and if I'm away from my PC it's much easier on a mobile device to use that app. I don't even know if that caused or contributed to the mishap, it's merely speculation that it may have been involved. It could have simply been pilot error :oops:.
Image

Image
User avatar
Admin
Site Admin
 
Posts: 9969
Joined: Wed Sep 22, 2004 9:32 am
Location: Salt Lake City, Utah

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Marc_C » Tue Jun 30, 2015 5:38 pm

Admin wrote:That would require building a test environment, and merging the databases is beyond my pay grade.

Yeah, I figured the test environment would be the big issue. Theoretically you could do it on a PC, but you'd obviously need to set up a db server; because of what those animals do, I'd opt to do it on either a machine that you'd be willing to do a full restore or disk wipe on after you're done or on a virtual machine.

I used the term merge pretty loosely - actually you'd be doing a select from the restored db and an insert into the real db. At it's most simple, it would look something like:
INSERT INTO table2.production.db
SELECT * FROM table1.restored.backup.db;

Here's where it can get complex:
This might need to be done with multiple tables on the assumption that the forum db is a normalized db. It might require join(s) or relaxing unique key constraints, manipulating UIDs - all depends on the schema. I'd be surprised if someone who knows SQL would estimate this at longer than 2 hrs for the basic development and testing unless there's something really funky in the forum db that I'm missing. Most SQL developers I know would do it for a couple of six-packs.

Still, there's the whole ROI question of recovering this one thread.
-marc
User avatar
Marc_C
 
Posts: 3173
Joined: Thu Mar 24, 2005 10:32 am
Location: A Sandy place south of a Great Lake

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Admin » Tue Jun 30, 2015 5:41 pm

The thing is, with no disrespect to those who posted to that topic, it's not that big a deal and not worth recreating. And that 20-30 hour estimate was based on my time, not that of someone (who I would have to find, BTW) who actually knows what they're doing.
Image

Image
User avatar
Admin
Site Admin
 
Posts: 9969
Joined: Wed Sep 22, 2004 9:32 am
Location: Salt Lake City, Utah

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Tony Crocker » Tue Jun 30, 2015 10:32 pm

admin wrote:The thing is, with no disrespect to those who posted to that topic, it's not that big a deal and not worth recreating.

Agree, even if it's 2 hours of work, better for us just to recreate the thread.
MarcC wrote:Most SQL developers I know would do it for a couple of six-packs.

Given admin's workload at his day job, I think it would be worth his while to find such an individual who could be "on call" for more serious crises like last season's hack.
http://bestsnow.net
Ski Records
Season length: 21 months, Nov. 29, 2010 - July 2, 2012
Days in one year: 80 from Nov. 29, 2010 - Nov. 17, 2011
Season vertical: 1,610K in 2016-17
Season powder: 291K in 2011-12
User avatar
Tony Crocker
 
Posts: 9799
Joined: Thu Sep 23, 2004 10:37 am
Location: Avatar: Charlotte Bay, Antarctica 2011
Location: Glendale, California

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Marc_C » Thu Jul 02, 2015 9:00 am

What flavor of SQL is the forum using?
-marc
User avatar
Marc_C
 
Posts: 3173
Joined: Thu Mar 24, 2005 10:32 am
Location: A Sandy place south of a Great Lake

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby Admin » Thu Jul 02, 2015 12:50 pm

Marc_C wrote:What flavor of SQL is the forum using?


I'd prefer not to publish that information publicly.
Image

Image
User avatar
Admin
Site Admin
 
Posts: 9969
Joined: Wed Sep 22, 2004 9:32 am
Location: Salt Lake City, Utah

Re: 2014-15 Season Recap Thread Disappeared/Deleted???

Postby jamesdeluxe » Thu Jul 02, 2015 1:39 pm

Admin wrote:
Marc_C wrote:What flavor of SQL is the forum using?

I'd prefer not to publish that information publicly.


Fine. How about your social security number?
User avatar
jamesdeluxe
 
Posts: 3319
Joined: Mon Oct 04, 2004 3:19 pm
Location: South Orange, NJ

Next

Return to F.Y.I.

Who is online

Users browsing this forum: No registered users and 1 guest


All content herein copyright © 1999-2017 First Tracks!! Online Media

Forums Terms & Conditions of Use

cron