OOAK Table Tennis Forum


A truly International Table Tennis Community for both Defensive and Offensive styles!
Live Table Tennis Videos Table Tennis News Live OOAK Forum Links About OOAK Table Tennis Forum OOAK Forum Memory
It is currently 23 Nov 2017, 22:09


Don't want to see any advertising? Become a member and login, and you'll never see an ad again!



All times are UTC + 9:30 hours




Post new topic Reply to topic  [ 18 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: A serious forum issue
PostPosted: 12 Jun 2017, 11:38 
Offline
Dark Knight
Dark Knight
User avatar

Joined: 13 Dec 2006, 12:34
Posts: 31564
Location: Adelaide, AU
Has thanked: 1506 times
Been thanked: 967 times
Blade: Trinity Carbon
FH: Victas VS > 401
BH: Dornenglanz OX
Hey guys

There seems to have been some hick up with server, and as a result some users have had their account deleted! :( :( :(

There is no malware on the site (I've checked), nor was this done by any admin/moderator, because these action are all logged.

I'm trying to get to the bottom of it, but fixing a mysql database is something I know very little about.
I know there problem occurred around Jun 10th, not sure if it happened only once, or multiple times.

If anyone has any tips, or has experience with this type of thing, please post, PM or Email me at: haggisv dot internode dot on dot net (removed the dots & spaces).

I do have backups of the database, but of course it would mean some of the latest posts would be lost :( :( :(

_________________
OOAK Table Tennis Shop | Table Tennis Reviews / Articles | Table Guide | Robot Guide | Re-Impact Blades
Setup1: Re-Impact Smart, Viper OX, Victas VS 401 Setup2: Re-Impact Barath, Dtecs OX, TSP Triple Spin Chop 1.0mm Setup3: Re-Impact Dark Knight, Hellfire OX, 999 Turbo
Recent Articles: Tenergy Alternatives | Tenergy Rubbers Compared | Re-Impact User Guide | Novel way to glue OX pips


Top
 Profile  
 

PostPosted: 12 Jun 2017, 21:38 
Offline
Senior member

Joined: 10 May 2011, 17:24
Posts: 188
Has thanked: 7 times
Been thanked: 10 times
I left clicked on Robot Blocker but the message:The requested user dose not exist!?

All his previous messages also disappear from my message list. Is this part of the problem? :(

_________________
Spin Lord First Strike: FH G Dtec ox, BH Golden Arch 8, 2.15mm


Top
 Profile  
 
PostPosted: 13 Jun 2017, 02:50 
Offline
CTRL_ALT_Loop
CTRL_ALT_Loop
User avatar

Joined: 28 Nov 2011, 08:20
Posts: 1354
Location: Egersund, Norway
Has thanked: 135 times
Been thanked: 137 times
In MS SQL server there is a "recovery mode" which makes this possible (though tedious, IIRC). I never had the opportunity to use it myself, but I attended a course where it was shown "live", recovering something like 5 records in a single table. Had to fiddle with transaction IDs or some other sequence numbers in conjunction with timestamps to get it right.
For MySQL I heard of "binary logs" which, as far as I recall, is supposed to offer similar rescue options.

In either case, to perform reliably I suspect that the option has to be swithced on before the accident (preferably from the last backup) and running continuously up to the point of recovery, without log purges.

I believe that this kind of option will be disabled by default, to give better performance and less storage space "wasted". Did you (or the people running the web/DB host) by any chance enable it?

Edit: See this discussion on stackoverflow. The post about recovering MyISAM files may apply to your database...


Top
 Profile  
 
PostPosted: 13 Jun 2017, 11:06 
Offline
Dark Knight
Dark Knight
User avatar

Joined: 13 Dec 2006, 12:34
Posts: 31564
Location: Adelaide, AU
Has thanked: 1506 times
Been thanked: 967 times
Blade: Trinity Carbon
FH: Victas VS > 401
BH: Dornenglanz OX
jixiaolan kc wrote:
I left clicked on Robot Blocker but the message:The requested user dose not exist!?

All his previous messages also disappear from my message list. Is this part of the problem? :(

Yes unfortunately it is. Robot Blocker and Danthespearton are the two that I know off that were affected. Really sorry guys... I'm doing my best to sort this. :( :( :(

_________________
OOAK Table Tennis Shop | Table Tennis Reviews / Articles | Table Guide | Robot Guide | Re-Impact Blades
Setup1: Re-Impact Smart, Viper OX, Victas VS 401 Setup2: Re-Impact Barath, Dtecs OX, TSP Triple Spin Chop 1.0mm Setup3: Re-Impact Dark Knight, Hellfire OX, 999 Turbo
Recent Articles: Tenergy Alternatives | Tenergy Rubbers Compared | Re-Impact User Guide | Novel way to glue OX pips


Top
 Profile  
 
PostPosted: 13 Jun 2017, 11:18 
Offline
Dark Knight
Dark Knight
User avatar

Joined: 13 Dec 2006, 12:34
Posts: 31564
Location: Adelaide, AU
Has thanked: 1506 times
Been thanked: 967 times
Blade: Trinity Carbon
FH: Victas VS > 401
BH: Dornenglanz OX
keme wrote:
In MS SQL server there is a "recovery mode" which makes this possible (though tedious, IIRC). I never had the opportunity to use it myself, but I attended a course where it was shown "live", recovering something like 5 records in a single table. Had to fiddle with transaction IDs or some other sequence numbers in conjunction with timestamps to get it right.
For MySQL I heard of "binary logs" which, as far as I recall, is supposed to offer similar rescue options.

In either case, to perform reliably I suspect that the option has to be swithced on before the accident (preferably from the last backup) and running continuously up to the point of recovery, without log purges.

I believe that this kind of option will be disabled by default, to give better performance and less storage space "wasted". Did you (or the people running the web/DB host) by any chance enable it?

Edit: See this discussion on stackoverflow. The post about recovering MyISAM files may apply to your database...

Thanks keme, I'll look into that. :up:

I think me best bet is to recover their profiles and posts from a backup... it will take me a while to work out how to do this, because as most of you know, I'm no great programmer, and I'm a noob when it comes to databases. :(
It is quite possible that all the posts are still in the database, but somehow the member profile got deleted... so if I can restore the profile, the posts might link up automatically.

When this forum was started, over 10 years ago, I never thought I'd ever be managing a site this big. Only when issues like this happen, you realise you're out of your depth... but what else can I do? :( :( :(

_________________
OOAK Table Tennis Shop | Table Tennis Reviews / Articles | Table Guide | Robot Guide | Re-Impact Blades
Setup1: Re-Impact Smart, Viper OX, Victas VS 401 Setup2: Re-Impact Barath, Dtecs OX, TSP Triple Spin Chop 1.0mm Setup3: Re-Impact Dark Knight, Hellfire OX, 999 Turbo
Recent Articles: Tenergy Alternatives | Tenergy Rubbers Compared | Re-Impact User Guide | Novel way to glue OX pips


Top
 Profile  
 
PostPosted: 13 Jun 2017, 11:33 
Offline
003 Style Master
003 Style Master
User avatar

Joined: 27 Apr 2011, 20:23
Posts: 2008
Location: South Australia
Has thanked: 218 times
Been thanked: 228 times
Blade: Donic Appelgren AllplayV1
FH: Donic Baracuda
BH: Xiom Vega Europe DF
You can just keep doing the best you can. :up: :up:

Its a great forum and sometimes things just happen.

_________________
Donic Appelgren Allplay Senso V1, Donic Baracuda 2.0mm ,BH Xiom Vega Europe DF 2.0mm
Yasaka Extra, Nil, Nil
Sunflex Hurricane, Milky Way 955 LP OX , 729 802-40 2.0


Top
 Profile  
 
PostPosted: 13 Jun 2017, 16:12 
Offline
CTRL_ALT_Loop
CTRL_ALT_Loop
User avatar

Joined: 28 Nov 2011, 08:20
Posts: 1354
Location: Egersund, Norway
Has thanked: 135 times
Been thanked: 137 times
Cobalt wrote:
You can just keep doing the best you can. :up: :up:

Its a great forum and sometimes things just happen.

I second that. We're still around. The lost parts may be missed, but the forum does not collapse. Make the best of what you/we have, and carry on.


Top
 Profile  
 
PostPosted: 14 Jun 2017, 06:30 
Offline
Do you feel lucky (young) punk?
Do you feel lucky (young) punk?
User avatar

Joined: 27 Mar 2007, 12:57
Posts: 5417
Location: USA
Has thanked: 67 times
Been thanked: 122 times
Robot Blocker, Hello new guy. Congrats of your first post!

:rofl:


Top
 Profile  
 
PostPosted: 14 Jun 2017, 09:39 
Offline
Dark Knight
Dark Knight
User avatar

Joined: 13 Dec 2006, 12:34
Posts: 31564
Location: Adelaide, AU
Has thanked: 1506 times
Been thanked: 967 times
Blade: Trinity Carbon
FH: Victas VS > 401
BH: Dornenglanz OX
There... They're looking a little less 'new' now at least. :oops:

Robot Blocker and Danthespearton: I've discovered that all your posts (and presumably also your PMs) are still in the database, so nothing is lost. :whew: :whew: :whew:
You can see Robot Blocker's posts here: search.php?author_id=414&sr=posts, and Danthespearton's posts here: search.php?author_id=14116&sr=posts
I've just got to work out how to link them back to your accounts.

I also can't help but wonder if anyone else is missing...if you notice that you get an error on when clicking on someone's username, please report it here, so that I can sort those out as well. :(

_________________
OOAK Table Tennis Shop | Table Tennis Reviews / Articles | Table Guide | Robot Guide | Re-Impact Blades
Setup1: Re-Impact Smart, Viper OX, Victas VS 401 Setup2: Re-Impact Barath, Dtecs OX, TSP Triple Spin Chop 1.0mm Setup3: Re-Impact Dark Knight, Hellfire OX, 999 Turbo
Recent Articles: Tenergy Alternatives | Tenergy Rubbers Compared | Re-Impact User Guide | Novel way to glue OX pips


Top
 Profile  
 
PostPosted: 15 Jun 2017, 17:52 
Offline
Dark Knight
Dark Knight
User avatar

Joined: 13 Dec 2006, 12:34
Posts: 31564
Location: Adelaide, AU
Has thanked: 1506 times
Been thanked: 967 times
Blade: Trinity Carbon
FH: Victas VS > 401
BH: Dornenglanz OX
I believe I've worked out how to fix it. I've fixed Robot Blocker's account, and I can see his posts and PMs again so I'm assuming it's all working, I just need for him to confirm before I can fix other accounts.

_________________
OOAK Table Tennis Shop | Table Tennis Reviews / Articles | Table Guide | Robot Guide | Re-Impact Blades
Setup1: Re-Impact Smart, Viper OX, Victas VS 401 Setup2: Re-Impact Barath, Dtecs OX, TSP Triple Spin Chop 1.0mm Setup3: Re-Impact Dark Knight, Hellfire OX, 999 Turbo
Recent Articles: Tenergy Alternatives | Tenergy Rubbers Compared | Re-Impact User Guide | Novel way to glue OX pips


Top
 Profile  
 
PostPosted: 15 Jun 2017, 20:37 
Offline
The Pied Pipper
The Pied Pipper
User avatar

Joined: 13 Jun 2017, 23:16
Posts: 1271
Location: Somewhere out there!
Has thanked: 63 times
Been thanked: 29 times
Alex you're a star, thanks mate, i didn't actually have to log out, i just went to messages and voila!!!

You know more than you let on!!! :lol: :lol:

_________________
_________________
Think, before you drink, before you write!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 18 posts ]  Go to page 1, 2  Next



All times are UTC + 9:30 hours


Who is online

Users browsing this forum: No registered users and 1 guest


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 post attachments in this forum

Search for:
Jump to:  
Copyright 2012 OOAK Table Tennis Forum. The information on this site cannot be reused without written permission.

Powered by phpBB® Forum Software © phpBB Group




Don't forget to 'LIKE' our forum on Facebook if you enjoy the content: