recent error when trying to change forums permissions

Posted: Thu Oct 19, 2006 7:19 pm

I have begun getting this error:

Code:

Couldn't obtain forum list





DEBUG MODE





SQL Error : 1 Can't create/write to file '/tmp/#sql_40ba_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 : 169


File : admin_forumauth.php

This began after the server crashed and the admin had to rebuild everything. I have reinstalled all the forum module files included in RNV20202 and ran the upgrades to get phpbb up to .21 -- still getting this error when trying to change the permissions of a forum.

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

We have covered this many times in the forum, but for the sake of expediency, I will repeat it here Smile

.MYI is your MySQL Index table and that error means the Index is corrupted. Use phpMyAdmin and run a REPAIR on that table and then on your database.

Posted: Fri Oct 20, 2006 1:06 pm

Sorry, I did a search - guess I didn't use the correct parameters in my search.

Thanks R.

Posted: Fri Oct 20, 2006 2:57 pm

I wasn't chastising you Smile

- I search for myi

Posted: Fri Oct 20, 2006 4:12 pm

Apparently, we still have server issues as I cannot access the db using phpmyadmin. I am getting an error.

Code:

Warning: session_write_close(): open(/tmp/sess_3c064f727080aba3ef9529c341690c3d, O_RDWR) failed: Permission denied (13) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44





Warning: session_write_close(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44





Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php:44) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 101

Posted: Fri Oct 20, 2006 5:11 pm

Also, I dumped the db and found some weird stuff.

Here is an example of what I am finding:

LOCK TABLES `nuke_bbwords` WRITE;
/*!40000 ALTER TABLE `nuke_bbwords` DISABLE KEYS */;

INSERT data is here

/*!40000 ALTER TABLE `nuke_bbwords` ENABLE KEYS */;
UNLOCK TABLES;

What is this all about?

Posted: Fri Oct 20, 2006 8:51 pm

Ezekiel wrote:

Apparently, we still have server issues as I cannot access the db using phpmyadmin. I am getting an error.

Code:

Warning: session_write_close(): open(/tmp/sess_3c064f727080aba3ef9529c341690c3d, O_RDWR) failed: Permission denied (13) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44





Warning: session_write_close(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44





Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php:44) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 101

That looks like a permissions and/or path error on the tmp file. Your host needs to help you fix this.

Posted: Sat Oct 21, 2006 12:00 am

That is what I figured. He is out of town right now. Since he is hosting us for free I guess I can't complain too much.

Posted: Sun Oct 22, 2006 4:59 pm

My guess is that /tmp has run out of space Smile

Posted: Sun Oct 22, 2006 5:44 pm

Err(13) is not usually the disk is full error. Try using .htaccess and setting another directory for tmp that you know you have access to.

Posted: Tue Oct 24, 2006 12:04 pm

This problem has been resolved. The issues werer server-side. His security system was set up wrong and it wasn't allowing nuke to write to certain files. He also had a problem when he re-installed cpanel which would not allow me to repair the tables. Once both of these server problems were rectified, I repaired the tables and all is well now.

Thanks for your help.