I must say that i hate these "out of clean space" problems, but here we go:
When i logged on to my site today i noticed that there are no blocks displayed in the left column (it displays empty) of all modules except weblog, news and smartfaq module which has
dissappeared completely.
I ran an MySQL database check which found some "unclosed tables" errors which were fixed with no problems except this one:
error : 13 when fixing table
error : Can't copy datafile-header to tempfile, error 9
status : Operation failed
But maybe even more important is the red part of MySQL debug output for the troubled modules:
[color=CC0000]SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,38) AND b.bid IN (8,7,27,3,2,1,11,42,10,145,31,50,30,41,59,71,49,48,47,6,46,36,128,130,29,146,28,178,25,24,122,4,16,15,70,154,9,43,151,124,126,125,23,22,21,12,5,162,133,138,136,18,135,82,88,134,132,19,20,17,129,156,155,153,152,127,62,123,131,137,188,187,186,185,184,183,182,181,180,157,179,175,174,173,172,171,170,169,167,166,165,164,163,161,160,159,158,168,176,190,191,192) ORDER BY b.weight,b.bid
Error number: 1
Error message: Can't create/write to file '/tmp/#sql_f5b_0.MYI' (Errcode: 13)[/color]
Yesterday i tried to changed my password in cpanel which obviously affected the MySQL password as well. I tried to edit the mainfile.php to put the new password in, but it never let me save the change. It instead named the file mainfile.part.php. I finally decided to switch everything back to the old password and renamed mainfile.part.php back to mainfile.php and everything worked again. I am not sure if there might be a conenction between that and this today.
Just to note, i checked the blocks adim preferences and they are the same except that in these modules it also shows none of the blocks even though the options for them are set to be displayed in those mods.
It is a very bad situation as these days are the most active days in the history of my site (most new registrations, members, posts, traffic...everything). I can't afford for such disfunctionalities.
So, please, anyone who might know anything that may help or solve this situation, respond.
I appreciate it.
Thank you
Daniel
