phpwiki-talk

[Phpwiki-talk] phpwiki error message

[Dwayne H. <dho...@ha...>]

We have a php wiki set up.  It is running on a mysql database.  Has been 
working great with no problems until yesterday afternoon.  Now we get 
the following error message: 

Fatal PhpWiki Error
lib/WikiDB/backend/PearDB.php:778: 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 '/tmp/#sql445e_1033_0.MYI' (Errcode: 13)])

I googled and found other wiki's with the same problem but no fix.  Any 
help would be great.   We are using php version 4.3.4, and mysqld 
version 4.0.18, with a custom kernel 2.6.6.


thanks,

ddh

Re: [Phpwiki-talk] phpwiki error message

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

I did a Google search on "mysql errcode 13". It is "permission denied: " 
http://dev.mysql.com/doc/mysql/en/perror.html.

Thus, maybe that temp file exists, but has the wrong permissions somehow.

Dan

Dwayne Hottinger wrote:

> We have a php wiki set up.  It is running on a mysql database.  Has 
> been working great with no problems until yesterday afternoon.  Now we 
> get the following error message:
> Fatal PhpWiki Error
> lib/WikiDB/backend/PearDB.php:778: 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 '/tmp/#sql445e_1033_0.MYI' (Errcode: 13)])
>
> I googled and found other wiki's with the same problem but no fix.  
> Any help would be great.   We are using php version 4.3.4, and mysqld 
> version 4.0.18, with a custom kernel 2.6.6.
>
>
> thanks,
>
> ddh
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk

Re: [Phpwiki-talk] phpwiki error message

[Dwayne H. <dho...@ha...>]

Dan Frankowski wrote:

> I did a Google search on "mysql errcode 13". It is "permission denied: 
> " http://dev.mysql.com/doc/mysql/en/perror.html.
>
> Thus, maybe that temp file exists, but has the wrong permissions somehow.
>
> Dan
>
> Dwayne Hottinger wrote:
>
>> We have a php wiki set up.  It is running on a mysql database.  Has 
>> been working great with no problems until yesterday afternoon.  Now 
>> we get the following error message:
>> Fatal PhpWiki Error
>> lib/WikiDB/backend/PearDB.php:778: 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 '/tmp/#sql445e_1033_0.MYI' (Errcode: 13)])
>>
>> I googled and found other wiki's with the same problem but no fix.  
>> Any help would be great.   We are using php version 4.3.4, and mysqld 
>> version 4.0.18, with a custom kernel 2.6.6.
>>
>>
>> thanks,
>>
>> ddh
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by Oracle Space Sweepstakes
>> Want to be the first software developer in space?
>> Enter now for the Oracle Space Sweepstakes!
>> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
>> _______________________________________________
>> Phpwiki-talk mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
>
Why would a tmp file get the wrong permissions?  How do I go about 
fixing such?

ddh

Re: [Phpwiki-talk] phpwiki error message

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

Dwayne Hottinger wrote:

> Why would a tmp file get the wrong permissions?


I don't know. Scary.

>   How do I go about fixing such?


If it were me, I'd probably look at the temp file, see if I can figure 
out what's going on. There's no way to tell you how to do this. Find out 
what a .MYI file is. It has something to do with MySQL. Google for your 
problem. For example, try to find a corresponding .MYI file in your 
MySQL directories.

If I couldn't figure it out, I'd probably shut down mysql, then sudo rm 
the temp file, then start up mysql again. This might ruin your system, 
no guarantees. If it were me, that's what I'd do, though.

Dan

Re: [Phpwiki-talk] phpwiki error message

[Reini U. <ru...@x-...>]

Dwayne Hottinger schrieb:
> We have a php wiki set up.  It is running on a mysql database.  Has been 
> working great with no problems until yesterday afternoon.  Now we get 
> the following error message:
> Fatal PhpWiki Error
> lib/WikiDB/backend/PearDB.php:778: 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 '/tmp/#sql445e_1033_0.MYI' (Errcode: 13)])
> 
> I googled and found other wiki's with the same problem but no fix.  Any 
> help would be great.   We are using php version 4.3.4, and mysqld 
> version 4.0.18, with a custom kernel 2.6.6.

That's entirely an mysql problem, not php and not phpwiki.

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
http://phpwiki.org/