Fixed! The /tmp dir is not the one I thought it was. It's at the root directory of the entire web site. Doh...., the file paths it gave me were the absolute paths relative to server root, not the /tmp that was in my /home/public_html/.... etc directory. It now works, but I truly didn't change it. The security module may have done something.
I'm wondering if it's secure to have the /tmp dir writeable for everyone. Drupal gives me the error unless it is. Or, perhaps I need to figure out the group that mysql is part of. The only groups I have are: root bin daemon sys adm disk wheel
Regards, Bill
William A. Prothero http://earthednet.org/
On Dec 17, 2010, at 11:22 AM, Jarry wrote:
On 17. 12. 2010 20:04, prothero wrote:
Folks: Not only do I get this error code, but several modules on my site have stopped working. The only thing I did was install the security module and mess with permissions on the /tmp folder. Sheesh! Very frustrating. Bill
I do not think you could mess your site just with changing /tmp permissions and reverting it back. I just tried it in one of my vservers (did backup before, of course), and site is working. You must have changed something else too...
btw, my /tmp is "drwxrwxrwt 4 root root". Check yours!
Jarry
--message: user warning: Can't create/write to file '/tmp/#sql_3cb2_0.MYI' (Errcode: 13) query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'solarsentinel' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/wap/public_html/modules/block/block.module on line 433 --end message.
I understand that the error is in permissions for the /tmp directory. I got this error when I changed permissions, but now when I do chmod -R 0777 (as a test), I still get the error. This should set the permissions to "Everybody can do anything". What's up? I'm not a unix expert, but not a novice either and this confuses me. Does the "#" char at the start of the file name mean the file is invisible, ??
-- _______________________________________________________________ This mailbox accepts e-mails only from selected mailing-lists! Everything else is considered to be spam and therefore deleted. -- [ Drupal support list | http://lists.drupal.org/ ]