Forum Index > Support & Feedback > Database error message
Previous :: Next Topic  
Author Message
Tom
Admin



Joined: 15 Dec 2001
Posts: 15151 | TRs

Tom
Admin
PostTue Jul 26, 2016 12:11 pm 
Reply to topic Reply with quote
Looks like we are experiencing a database issue that is generating error messages.  So far I've noticed this prevents editing posts or viewing PMs.  We are looking into it.
Back to top
View user's profile Search for posts by this user Visit poster's website Send private message Send e-mail Reply to topic Reply with quote
Tom
Admin



Joined: 15 Dec 2001
Posts: 15151 | TRs

Tom
Admin
PostTue Jul 26, 2016 12:12 pm 
Reply to topic Reply with quote
Seems deleting posts is a problem as well.
Back to top
View user's profile Search for posts by this user Visit poster's website Send private message Send e-mail Reply to topic Reply with quote
Ski
><((((>



Joined: 27 May 2005
Posts: 8307 | TRs
Location: tacoma
Ski
><((((>
PostTue Jul 26, 2016 7:24 pm 
Reply to topic Reply with quote
ran into it earlier today attempting to edit a post.

--------------
"I shall wear white flannel trousers, and walk upon the beach. 
I have heard the mermaids singing, each to each."
Back to top
View user's profile Search for posts by this user Send private message Send e-mail Reply to topic Reply with quote
Ski
><((((>



Joined: 27 May 2005
Posts: 8307 | TRs
Location: tacoma
Ski
><((((>
PostTue Jul 26, 2016 7:25 pm 
Reply to topic Reply with quote
^ and just got it again trying to edit that one.  huh.gif

--------------
"I shall wear white flannel trousers, and walk upon the beach. 
I have heard the mermaids singing, each to each."
Back to top
View user's profile Search for posts by this user Send private message Send e-mail Reply to topic Reply with quote
Bloated Chipmunk
Farblondjet



Joined: 29 Jan 2007
Posts: 2633 | TRs
Location: Margaritaville
Bloated Chipmunk
Farblondjet
PostTue Jul 26, 2016 7:50 pm 
Reply to topic Reply with quote
Yeah, I tried to quote someone's post & got an error msg.   irked.gif

--------------
Home is where the hiking is. 

"Peaks that have come and gone four times should halt a man in his steps." -- William O. Douglas

A balanced diet is a margarita in each hand.
Back to top
View user's profile Search for posts by this user Visit poster's website Send private message Send e-mail Reply to topic Reply with quote
Tom
Admin



Joined: 15 Dec 2001
Posts: 15151 | TRs

Tom
Admin
PostTue Jul 26, 2016 8:19 pm 
Reply to topic Reply with quote
Put in a temporary fix.  Hopefully this will minimize the error messages.
Back to top
View user's profile Search for posts by this user Visit poster's website Send private message Send e-mail Reply to topic Reply with quote
Tom
Admin



Joined: 15 Dec 2001
Posts: 15151 | TRs

Tom
Admin
PostTue Aug 02, 2016 7:09 pm 
Reply to topic Reply with quote
Unfortunately we had a major database crash on Saturday, a few days after the first problems surfaced.  Not sure what caused this but we suspect it was related to our web host upgrading the database software earlier in the week.  We've restored the database from our Saturday morning backup onto a new server and crossing our fingers this will fix the problems.  If not we may need to shut the site down until we can upgrade our forum software.
Back to top
View user's profile Search for posts by this user Visit poster's website Send private message Send e-mail Reply to topic Reply with quote
Ski
><((((>



Joined: 27 May 2005
Posts: 8307 | TRs
Location: tacoma
Ski
><((((>
PostTue Aug 02, 2016 7:58 pm 
Reply to topic Reply with quote
thanks Tom! up.gif

--------------
"I shall wear white flannel trousers, and walk upon the beach. 
I have heard the mermaids singing, each to each."
Back to top
View user's profile Search for posts by this user Send private message Send e-mail Reply to topic Reply with quote
mtn.climber
Member
Member


Joined: 29 Jul 2008
Posts: 1087 | TRs
Location: The Lost Horizon
mtn.climber
Member
PostTue Aug 02, 2016 9:59 pm 
Reply to topic Reply with quote
Are the missing posts gone for good, or can they be retrieved?  Just before the crash, I posted a TR of 7FJ and now it's missing.  It was posted long enough before the total crash that a reply had also been posted.

--------------
Reach for the sky, cuz tomorrow may never come.

Live the life of love.  Love the life you live.
Back to top
View user's profile Search for posts by this user Send private message Send e-mail Reply to topic Reply with quote
Tom
Admin



Joined: 15 Dec 2001
Posts: 15151 | TRs

Tom
Admin
PostTue Aug 02, 2016 10:17 pm 
Reply to topic Reply with quote
Unfortunately it can't be retrieved.  The posts text table is the one that crashed, and there was no way to recover it other than from the backup made earlier that morning.  You could see if google cached the TR before the site went down.

"search google for some exact phrase in quotes followed by" site:nwhikers.net
Back to top
View user's profile Search for posts by this user Visit poster's website Send private message Send e-mail Reply to topic Reply with quote
NacMacFeegle
Member
Member


Joined: 16 Jan 2014
Posts: 2504 | TRs
Location: United States
NacMacFeegle
Member
PostTue Aug 02, 2016 10:37 pm 
Reply to topic Reply with quote
Well done getting the site up and running again!  up.gif

--------------
Read my hiking related stories and more at http://illuminationsfromtheattic.blogspot.com/
Back to top
View user's profile Search for posts by this user Visit poster's website Send private message Send e-mail Reply to topic Reply with quote
Magellan
Brutally Handsome



Joined: 26 Jul 2006
Posts: 13113 | TRs
Location: Inexorable descent
Magellan
Brutally Handsome
PostTue Aug 02, 2016 10:39 pm 
Reply to topic Reply with quote
You don't know what you got until it's gone.
Back to top
View user's profile Search for posts by this user Send private message Send e-mail Reply to topic Reply with quote
bk
Member
Member


Joined: 01 Jun 2012
Posts: 124 | TRs

bk
Member
PostWed Aug 03, 2016 1:08 am 
Reply to topic Reply with quote
More Ideas for Retrieving Lost Pages:

1) Google shows the old Trip Report index page linking to the old Seven Fingered Jack report. The 7FJ is erased (lost) from the main link's current version, so choose the cached version of the Google result (down-triangle-drop-down-menu to the right of the green text; click and choose "cached") and, in the cache, you see 7FJ's link used to be this:http://www.nwhikers.net/forums/viewtopic.php?t=8021681: Now an error message. Does its cache exist? (That is, a non-errored-version of the cache?; in this case, the answer is "yes, if you're quick about it.")

2) Search Google for ideas: You'll see more options beyond just Google cache and the Wayback Machine.

3) The third or fourth search-result hit brings you to searchengineshowdown. Lots of ideas. Try each one. (Plugging in what we now know used to be the url for the 7FJ page: http://www.nwhikers.net/forums/viewtopic.php?t=8021681 )

4) In the case of the Seven Fingered Jack report, it is referenced in the Yahoo results. The link, itself, is a nwhiker-error-page, but click the inconspicuous drop-down menu (carat symbol) to the right of the green text and choose "cache" (just like for Google cache, but Yahoo cache).

5) The Seven Fingered Jack report is there in all of its original beauty in Yahoo's cache. (But not sure how long it will last !! before the cache gets overwritten by the more recent error-version of the page [that contains just a nwhikers.net error message]! ) (Come to think of it, the good-version-of-the-cache might be there a long time assuming search-robots only travel along existing, valid links . . . and since there is no live, valid link pointing to the 7FJ page anymore . . . maybe there's no risk of a web-bot trying to re-surf to the 7FJ page to update its cache page with the current error-page. Maybe. Maybe not.)

6) The cache (for Yahoo, anyway) shows the nice-looking, end-result page in the nwhiker.net-format that the end-reader is normally used to seeing . . . but in terms of moving the cached-stuff back into the nwhiker poster's-format (using nwhikers.net tags, like [img] [/img], etc.), that looks like it might have to be done by hand, again. At least you'll have the visual reminder of the previous layout and will be able to copy and paste the text parts.

You can probably skip some steps (like the roundabout Google steps) and just use searchengineshowdown directly to find cached versions using Tom's technique: "search phrase followed by" site:nwhikers.net (assuming that syntax works in other search engines, like Yahoo, etc.)

It would be interesting to see a list of topics that were edited those last 24-hours before the crash (that would have been lost to the daily back-up) to see if they're any other caches that should be explored and retrieved in a timely manner. Not sure if such a list exists.
Back to top
View user's profile Search for posts by this user Send private message Send e-mail Reply to topic Reply with quote
  Display:     All times are GMT - 8 Hours
Forum Index > Support & Feedback > Database error message
  Happy Birthday jackchinook, MLHSN, JoeFrei, bigskywalker!
Jump to:   
Search this topic:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
   Use Disclaimer Powered by phpBB Privacy Policy