I just started having this trouble when i added a few new modules to my site and moved a few blocks around. Not sure what to make of it or what causes it. But the site will go on the blink for no reason and I lose the index.php. I can access the modules with a menu bar on the top but all the blocks disappear and then in about 20 minutes they are back and everything works fine.
php debug gives me a error in red and then later corrects itself.
SELECT DISTINCT i.instanceid, b.*, i.* FROM crw_block_instance i, crw_newblocks b, crw_block_module_link m WHERE m.block_id=i.instanceid AND i.instanceid IN (74,65,62,54,36,16,42,73,61,63,44,72,25,69,21,20,17,10,30,3,68,67,24,22,31,1,19,14,13,64,57,56,48,47,46,78,77,38,37,49,79) AND i.visible=1 AND i.bid=b.bid AND b.isactive=1 AND m.module_id=0 AND m.pageid IN (0, 1) ORDER BY i.weight,i.instanceid
Error number: 1
Error message: Can't create/write to file '/var/tmp/#sql_8b77_0.MYI' (Errcode: 2)
( 0.012934)
I'm using XOOPS 2.2.3
my theme is the default that came with the package.
If more info is needed just tell me what and i will get it for you.
