3
Good Day, XOOPS the Community.
Guys, I've turned on the debugging for mysql/blocks and I actually received this error message in a pop up box.
SELECT b.* FROM anggarda_newblocks b, anggarda_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) ORDER BY b.weight,b.bid
Error number: 1
Error message: Can't create/write to file '/tmp/#sql_1009_0.MYI' (Errcode: 13)
I'll appreciate it gladly if someone could tell me what is wrong and therefore remedy the problem.
UPDATE:
I've since updated and isolated the problem. It would seem that "perror 13" returns "right permissions".
I check and it would seem that the user that started the MySQL server doesn't have rights to write to the tmpdir that was designated in my.cnf
I've since changed the permission and everything is in order.
I hope that the above information will help someone.
Regards.