18
I have 2 XOOPS site at one server
one is 2.0.6 and its running since some months ago (psico.net/cuidar)
the other is 2.0.7.3 and it was instaled some days ago
both of them are fresh installs, and have no extra modules.
All my blocks are gone and I got the same error
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,-1) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15) ORDER BY b.weight,b.bid
Error number: 1030
Error message: Got error 28 from table handler
I went to phpmyadmin and then to those tables (newblocks , block_module_link) and clicked at the "repair" funcion
Now both sites are ok.
I got scared because of this problem.
I wonder how this can be caused... at other site someone speculate about server overload
here I did not found any explications of this problem
do you know why this happens?