Losing buffs when zoning

[Esildor]

This issue appeared last night, never had this problem before.

Any ideas?

I did some searching, people talking about source issues .. but I haven't updated my source since I first compiled back in March, could that be it?

[Esildor]

character_buffs table needed repaired :l

[Scorpious2k]

Don't you love the easy fixes?

[Esildor]

Originally Posted by Scorpious2k

Don't you love the easy fixes?

Seriously!

Seems a good idea to TRY and run a backup whenever you have an odd issue, tells you if a table is borked then :P

[rlie_0]

Id like to say Ive ran into the same problem, any fixes out there for this problem?

[KLS]

Assuming you've repaired already and it still keeps happening.

Try switching the table to innodb, dunno why peq dumps this as mysiam since it's so write heavy.

If you still have frequently crashing tables you might look into:

* The server being stopped suddenly may corrupt a table.
* MySQL may not be configured with enough memory, if it tries to allocate a buffer during a write and can't that may cause corruption.
* Anti-virus software may be interfering with normal MySQL operation.

[Esildor]

Originally Posted by KLS

* The server being stopped suddenly may corrupt a table.

This was definitely my problem. Power went out :P

Those East Coast storms though!