Welcome Guest Search | Active Topics | Members

Random Post thread offline :( Options
Steviepunk
Posted: Thursday, September 18, 2008 1:38:08 PM

Rank: Admin

Joined: 8/26/2002
Posts: 3,467
Location: United Kingdom
Looks like some data problem with that thread, so it can't be accessed just now.  all others seem fine though.

Will investigate.
rogem002
Posted: Thursday, September 18, 2008 3:42:00 PM

Rank: Martian Estate Agent

Joined: 9/14/2003
Posts: 3,358
Location: United Kingdom
Your running out of RAM buddy or someone found that unpatched bug in this forum software. Try adjusting the SQL query :)


Full On Design
Steviepunk
Posted: Thursday, September 18, 2008 4:39:32 PM

Rank: Admin

Joined: 8/26/2002
Posts: 3,467
Location: United Kingdom
it's not the forum software.  There are literally two rows in the database that cannot be accessed, even using the SQL manager and a basic Select statement. The two are old posts from before the forum upgrade, so not sure why they'd corrupted now.
rogem002
Posted: Thursday, September 18, 2008 9:15:09 PM

Rank: Martian Estate Agent

Joined: 9/14/2003
Posts: 3,358
Location: United Kingdom
Why not just go into the physical file and see whats up? or just make a backup then restore it. 2 posts is only 2 posts.


Full On Design
Steviepunk
Posted: Thursday, September 18, 2008 10:51:21 PM

Rank: Admin

Joined: 8/26/2002
Posts: 3,467
Location: United Kingdom
ok, problem solved now.  Couldn't do much about it while I was at work.

As for going into the physical file, that's not something you do with an SQL database (except as last resort) Wink
rogem002
Posted: Thursday, September 18, 2008 11:15:43 PM

Rank: Martian Estate Agent

Joined: 9/14/2003
Posts: 3,358
Location: United Kingdom
What was the problem? Did cyber bunnies leave their droppings in it?


Full On Design
Steviepunk
Posted: Thursday, September 18, 2008 11:36:03 PM

Rank: Admin

Joined: 8/26/2002
Posts: 3,467
Location: United Kingdom
something like that, was probably a table index that corrupted.
A backup and restore sorted it, but I needed time to take everything offline so I could get a DB lock for the restore.
little_vache
Posted: Saturday, September 20, 2008 8:35:13 PM

Rank: I'm a girl so you all stop thinking i'm a guy

Joined: 11/7/2003
Posts: 3,983
Location: USA
was that why i couldn't read any of the text that had been posted?
rogem002
Posted: Saturday, September 20, 2008 9:10:07 PM

Rank: Martian Estate Agent

Joined: 9/14/2003
Posts: 3,358
Location: United Kingdom
Yeah! I'm betting someone tried to find the forums secret gold and fired cannons in the wrong direction.


Full On Design
Steviepunk
Posted: Sunday, September 21, 2008 12:57:28 AM

Rank: Admin

Joined: 8/26/2002
Posts: 3,467
Location: United Kingdom
little_vache wrote:
was that why i couldn't read any of the text that had been posted?


yeah, the DB was erroring when trying to get the post list.
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.