This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: Re: [Slashcode] Blocks vanished? what the hell? From: Patrick Galbraith <patrick.galbraith@andover.net> Date: Wed, 01 Mar 2000 06:56:30 +0000 Rodney Caston wrote: > mysql> select * from blocks; > ERROR 1030: Got error 127 from table handler > > ^ hows that for fun... > > any ideas how to fix this mess? > > On Tue, 29 Feb 2000, Rodney Caston wrote: > > > I've been running slashcode w/o trouble for a few weeks, but today I > > found my site to be in ruins, for some reason all the data for every one > > of my 'blocks' is gone, in the admin.pl the list is blank, all data seems > > missing, and so it cant rebuild the mainpage correctly either. > > > > any thoughts? I have no idea why this happened. The only thing that I can think of is that your blocks table may be corrupt. Try shutting down your database, go into the directory you have your datafiles in, and run "isamchk -r blocks". If the table is corrupted, this may fix it. Otherwise, you may have bigger problems with your database. On a side note: it's always a good policy to do a database backup - depending on how often things on your site change, use mysqldump to dump all the data in all your tables, or at least the tables that have changed. Good luck with fixing it, ===