Frickin MySQL, stats or here...

Post by **Akira** » Wed Mar 23, 2005 11:20 am

Either way, I hate it.

Server stats, nothing had changed on server at all, nothing. But stats no longer work.

Error: Fatal Session Error: 137: Can't open file: 'pstats_sessions.MYI' (errno: 145)

I searched on "Fatal Session Error" on psychostats.com forums, and a few people have encountered, but no fixes! All database files are there, nothing changed, permissions fine etc....

Ugh!

Post by **Serpent** » Wed Mar 23, 2005 11:55 am

just a shot in the dark, but having had table corruption in the past, i would recommend running myisamchk on all of the tables.... in all of the databases for that matter, if the phpbb is using mysql off the same server that the stats for CS:S are...

i can offer exact syntax if need be, if you arent familiar with it...

Post by **Akira** » Wed Mar 23, 2005 12:01 pm

Thanks Serpent. I finally stumbled across something similar someone had posted about, and I now know the "repair table" command.

It is fixed now. Stats working: http://server.campquake.net