mySQL error: Can't create/write to file '/tmp....MYI' (Errcode: 17)

[SnT2k]

it was running fine a while ago but suddenly:

mySQL query error: SELECT m.*, mem.id, mem.name FROM ibf_admin_logs m, ibf_members mem
					WHERE  m.member_id=mem.id ORDER BY m.ctime DESC LIMIT 0, 5

mySQL error: Can't create/write to file '/tmp/#sql_122a_0.MYI' (Errcode: 17)
mySQL error code: 
Date: Tuesday 05th of April 2005 09:10:13 AM

I chmodded my /tmp to 777 yet the same thing happened. Any other solutions? (or is it from the admin's side?)
I also tried repairing the database btw...

 

[yhap2003]

I have the same problem, here's my error:

mySQL query error: SELECT m.*, mem.id, mem.name FROM ibf_admin_logs m, ibf_members mem
WHERE m.member_id=mem.id ORDER BY m.ctime DESC LIMIT 0, 5

mySQL error: Can't create/write to file '/tmp/#sql_eeb_0.MYD' (Errcode: 2)
mySQL error code:
Date: Tuesday 05th of April 2005 10:31:06 AM

Help plz??

 

[talomo]

I have the same problem on my site too.

 

[dbforum]

Have same sort of problem with php sessions:

Warning: session_start(): open(/tmp/sess_22cc3c6524d2d908d6abfa98c9d2d8a0, O_RDWR) failed: 
No such file or directory (2) in /home/dbforum/public_html/phpwcms/login.php on line 28

 

[Corey]

Some problem with the files, the datacenter is working on it.

-corey

 

[dbforum]

Thanks for your fast reaction!

Maarten

 

[Corey]

Is this resolved?

-Corey

 

[dbforum]

For me not...


Maarten

 

[crazzyt9]

would this also be causeing php-nuke to be unable to connect to the mysql data bases?


Tim

 

[Chris]

crazzyt9, most likely yes.

To everyone, if you havn't read, read this http://x10hosting.com/showthread.php?t=2192.

 

[BrettFreeman]

I had the same problem on mine. CHMOD tmp to 777.

 

[yhap2003]

Well it's the server problem yea, we all know now. Chmod wouldn't do anything right now. Oh and BTW I can't get intp my site nor the ftp too

http://xolite.x10hosting.com/

 

[dbforum]

I guess that's because they took down the server to solve this problem

 

[Corey]

That would be correct, there are corrupt files and it's being fixed. I have had no luck with this server since I got it ;(

-Corey

 

[yhap2003]

Oh i c, well Coery that doesn't sound too good!!! LOL. No luck with the server.

 

[dbforum]

Great! Problem solved

 

[BrettFreeman]

Yhap, nice hacked invision board. Psych.

 

[yhap2003]

Hey tx, Yeah everything works normal now. everythings fixed now.

 

[SnT2k]

Resolved..
anyway, thanks a lot :3

 

[Chris]

Good.

Closed.