Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's v7.0 Customized Distro
Author Message
Maeve
New Member
New Member


Joined: Mar 05, 2004
Posts: 10

PostPosted: Fri Apr 02, 2004 5:59 pm Reply with quote

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

_________________
* Staring up a steep learning curve with glazed eyes and a bewildered expression * 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Fri Apr 02, 2004 6:26 pm Reply with quote

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.
 
View user's profile Send private message
Maeve
PostPosted: Fri Apr 02, 2004 6:38 pm Reply with quote

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.
 
Raven
PostPosted: Fri Apr 02, 2004 7:06 pm Reply with quote

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.
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's v7.0 Customized Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©