Check youry my.cnf file. You have the temp directory set to /root/tmp instead of /tmp. If this is not the case, add an entry to redefine the temp directory.
Bob Nelson wrote: >I'm encountering a situation with MySQL that's really driving me crazy and I >have been unable to locate a solution. I'm hoping that someone on the >mailing list can provide some guidance... > >I'm attempting to use a piece of php software (phpBB) which is talking to a >dedicated MySQL server via TCP. The MySQL install is the Mandrake 8.2 >default (3.23.47). > >Okay, here's the error I receive using their debug mode... > >Couldn't obtain forum list >DEBUG MODE >SQL Error : 1 Can't create/write to file '/root/tmp/#sql1f77_259_0.MYI' >(Errcode: 13) >SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE c.cat_id = f.cat_id >ORDER BY c.cat_order ASC, f.forum_order ASC >Line : 166 >File : /var/www/html/phpBB2/admin/admin_forumauth.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
