Re: [Phpwiki-talk] HELP: Can't create/write to file

[Dan F. <dfr...@cs...>]

Arthaey Angosii wrote:

>(Note: I also posted this to the Sourceforge support forum, but you've
>all said the mailing list gets read more often.)
>
>Everything was working fine with my PhpWiki installation. But today I
>installed phpMyAdmin so I could look at the MySQL tables more easily,
>and after I got that working, the wiki no longer loads. Instead, I get
>this error:
>
><begin error>
>
>Fatal PhpWiki Error
>
>lib/WikiDB/backend/PearDB.php:779: Fatal[256]: wikidb_backend_mysql:
>fatal database error
>
>    * DB Error: unknown error
>    * (SELECT linkee.id as id, linkee.pagename as pagename,
>linkee.hits as hits, linkee.pagedata as pagedata FROM link, page AS
>linker, page AS linkee WHERE linkfrom=linker.id AND linkto=linkee.id
>AND linker.pagename='HomePage' ORDER BY linkee.pagename [nativecode=1
>** Can't create/write to file '/root/tmp/#sql_f5b_0.MYI' (Errcode:
>13)])
>    *
>  
>

I do not know what this error means exactly. However, I'll say this:

1. I think MySQL is sad, not Phpwiki.
2. I Googled for mysql "Can't create/write to file" and found this page. 
Maybe it helps:

http://dev.mysql.com/doc/mysql/en/Cannot_create.html

It says to use "perror" to find out about the error code. I did it with 
yours:

% perror 13
Error code  13:  Permission denied

Thus, probably that file doesn't have permissions to be read by the user 
who's making the Phpwiki request (probably the user running your Apache 
process).

Look into file permissions.

Dan

>
>Warning: Unknown(): A session is active. You cannot change the session
>module's ini settings at this time. in Unknown on line 0
>
></end error>
>
>I'm not very familiar with sql, so any hints on where to start looking
>for the cause of this would be greatly appreciated!
>
>
>  
>