I was fixing a couple things on my website today and noticed that the blocks weren't displaying in the blocks administration menu. I did a quick search online here and found out that this is probably an SQL error. I ran the SQL debugger and came up with the following error:

SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND m.module_id IN (0,-1) AND b.bid IN (15,25,7,24,1,5,28,2,23,22,21,20,19,18,17,16,14,13,12,11,10,9,8,6,3) ORDER BY b.side,b.weight,b.bid
Error number: 1030
Error message: Got error 28 from table handler

The only think I'm not sure on is where to go from here. Previous posts mentioned that permissions were incorrect for a temporary directory, but I couldn't make heads or tails of the error message above. Can anyone lend a hand in deciphering that error message?

Oh, I should also mention that the blocks display fine on the website. No problems there at all. The only problem is in the administration area.

I too also seem to be having this error!

Don't know how to fix it, but hopefully someone else will!

I'm having exactly the same problem, and I'm sure my permissions are set right. I'm really new to this, and am and MySQL aren't rerally on speaking terms yet. Can anyone help?