The old "database disk is malformed" strikes again

I started using MUSHClient a bit more than a year now and it has worked perfectly without a flaw since the first time. But then, a couple of months back, it simply crashed, leaving behind a message that goes like this:

SQL Error on statement: "DROP TABLE IF EXISTS control; CREATE TABLE control (name VARCHAR(10)NOT NULL PRIMARY KEY, value INT NOT NULL);"
database disk image is malformed

Now, I am an experienced builder, but I don't have a damn clue about programming or coding, since I never dabbled in that. I believe this is a newbie bug or something, I am just too dumb to see it.

Thanks in advance!

Based on a very quick google to verify my first thoughts, this sounds a lot like hard drive corruption. Might be something as simple as checking your drive for errors and attempting to recover bad sectors could fix it but the good news is it's def not a newbie error and isn't likely to be caused by anything you've done.

Sounds like your MUSHclient global preferences file has become corrupted. How, I don't know. Maybe the power went off at an inopportune moment.

You could try to do an integrity check:

http://www.gammon.com.au/forum/?id=9262&reply=12#reply12

I strongly suspect that this (database) file is the problem:



That is in the MUSHclient installation directory. It doesn't have anything earth-staggeringly useful in it, just your world screen positions, global preferences, things like that.

I suggest you close MUSHclient, then make a copy of that file, and then delete it (or just rename it to something else). It should be re-created next time the client starts, and your problems should go away.

I strongly recommend making backups, next time you may lose an important world file with your passwords and things in it.

Thank you both for contributing and thank you Nick for finding the problem! ^_^