Forums - Admin permissions error

New Member Joined: Mar 05, 2004 Posts: 10

Kk ... got a new one

Have crawled all over the forums to see if I could find the answer without having to post ... but, either I'm not seeing it (very possible) or it hasn't been posted before.

Everything's been working tickety-boo until I wanted to set some of the Forums to private ... then I get a General Error

Quote:

General Error
Couldn't obtain forum list

DEBUG MODE

SQL Error : 1 Can't create/write to file '/root/tmp/#sql_4b5b_0.MYI' (Errcode: 13)

SELECT f.* FROM nuke_bbforums f, nuke_bbcategories c WHERE c.cat_id = f.cat_id ORDER BY c.cat_order ASC, f.forum_order ASC

Line : 203
File : /home/dreams/html/modules/Forums/admin/admin_forumauth.php

There's just enough english there to thoroughly confuse me *wry grin* ...
I suspect that the issue is with ...

Quote:

'/root/tmp/#sql_4b5b_0.MYI'

... where it perhaps ought to be '/tmp/...'. But not certain if this is something I can fix via FTP, or if it needs adressing from the MySQL end.

Or even if I'm way off base ... assistance would be welcome.

Thanks in advance Smile

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

For one reason or another, you have some database tables that have become 'broken' and need to be repaired. The MYI means your MySQL Index table. The easiest way is to use phpMyAdmin and just click on the repair option. But, if I remember right, your host hasn't installed that yet, correct? Try getting hold of your host and tell then to run a MySQL Repair on all tables in your database. if none of those options work, get back with me and I will write you a short script that should fix it.

Posted: Fri Apr 02, 2004 6:38 pm

Thanks Raven Very Happy

I will do, won't be able to reach my server admin till sunday my time (monday his).

Will let you know if he can't resolve it.

Posted: Fri Apr 02, 2004 7:06 pm

Quote:

SQL Error : 1 Can't create/write to file '/root/tmp/#sql_4b5b_0.MYI' (Errcode: 13)

I just noticed this. This is a Permission Denied error to that file. Now, it is possible that the corruption of the index file is causing this, but it may be more than that. Your host should be able to fix it though.