SpecialAttack.net
https://forum.specialattack.net/

Crashed sql table in hlstats
https://forum.specialattack.net/viewtopic.php?t=2698
Page 1 of 1

Author:  [SpA]Blackhawk [ 30 May 2008, 01:38 ]
Post subject:  Crashed sql table in hlstats

sql broken:
Quote:
Database Error

Server Address: localhost
Server Username: hlstats

Error Diagnostic:
Bad query.

Server Error: (145) Table './hlstats/hlstats_Events_Frags' is marked as crashed and should be repaired
Coming in the player info page. Just wanted to note that. :)

Author:  [SpA]SaintK [ 30 May 2008, 06:37 ]
Post subject:  Re: Crashed sql table in hlstats

Hi,

Thanks for the report, i had not seen this error yet!

Currently looking into running a repair script on the database to fix the issue.

Stay tuned...!

Author:  [SpA]SaintK [ 30 May 2008, 06:39 ]
Post subject:  Re: Crashed sql table in hlstats

Hi,

The repair script has finished. Can you check if it's fixed? (I forgot to check were the error was excactly before i started repairing :P)

Cheers,

Author:  needy [ 30 May 2008, 08:19 ]
Post subject:  Re: Crashed sql table in hlstats

[SpA]SaintK wrote:
Hi,

The repair script has finished. Can you check if it's fixed? (I forgot to check were the error was excactly before i started repairing :P)

Cheers,
It's working now :)

Author:  [SpA]Blackhawk [ 30 May 2008, 13:55 ]
Post subject:  Re: Crashed sql table in hlstats

As needless stated it's working again. :)

Author:  [SpA]Blackhawk [ 26 Jul 2008, 14:11 ]
Post subject:  Re: Crashed sql table in hlstats

Hmm.. I dunno what the problem now is, but my stat-page now misses the most of its data: http://stats.specialattack.net/?mode=pl ... ayer=58910

Author:  [SpA]SaintK [ 26 Jul 2008, 17:02 ]
Post subject:  Re: Crashed sql table in hlstats

[SpA]Blackhawk wrote:
Hmm.. I dunno what the problem now is, but my stat-page now misses the most of its data: http://stats.specialattack.net/?mode=pl ... ayer=58910

I forgot to run a repair on the DB after white crashed. It's running now (should be fixed after).

Cheers

Author:  [SpA]Blackhawk [ 27 Jul 2008, 16:34 ]
Post subject:  Re: Crashed sql table in hlstats

What about putting an auto-repair in the restartscripts? :)

Page 1 of 1 All times are UTC+02:00

Powered by phpBB® Forum Software © phpBB Limited