4
SELECT b.* FROM xoops_block_module_link m LEFT JOIN xoops_newblocks b ON b.bid=m.block_id LEFT JOIN xoops_group_permission l ON l.gperm_itemid=b.bid WHERE l.gperm_name = 'block_read' AND gperm_modid = 1 AND (l.gperm_groupid=1 OR l.gperm_groupid=2) AND b.isactive=1 AND b.visible=1 AND (m.module_id=0 OR m.module_id=-1) ORDER BY b.weight,b.bid
Error number: 2000
Error message: Can't create/write to file '/var/tmp/#sql5f6_229869_0.MYI' (Errcode: 13)
thats what i got with debug on.
i have 2 XOOPS installed, both have same problem.
i'm using 2.02 ....