To fix the error you are getting you need to restart your MYSQL server.
for example, on Fedora Core 4 (red hat) go to the command link or shell and type the following:
/etc/init.d/mysqld restart
Thats it, reload the page that was giving you the error below and it should go away
If you have hosting by a company who does shared web hosting, then you need to call them and advise that you are getting this error message.
ERROR:
DB Error: unknown error
SELECT distinct(session_id) FROM mod_visitors_hit WHERE timestamp>date_sub(now(), interval 5 minute) ORDER BY user DESC, ip [nativecode=1030 ** Got error -1 from table handler]
Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
warning:, unknown():, write, failed:, no, space, left, on, device, (28), in, unknown, on, line, 0
Wed Oct 21, 2009 5:01 pm - Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
#32
Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
Author: Alex
Sat Jun 20, 2009 9:24 pm - Re: Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
#38
bruno
many times you get this error simply because there is no more space in your hard drive of your server so the mysql database cannot add more information inot the database because your space is full
Sat Jul 11, 2009 4:47 pm - Re: Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
#56
ksingsr
help me mine says:
bin/mlgui: Write failed: No space left on device:
bin/mlgui: Write failed: No space left on device:
Sat Jul 11, 2009 4:57 pm - Re: Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
#61
vbuletin
i have vbulletin forum and i get this error:
"write failed: No space left on device (28)"
what can i do to fix?
"write failed: No space left on device (28)"
what can i do to fix?
Sun Aug 23, 2009 11:36 pm - Re: Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
#214
Arvind
Don't understand how is this related to MYSQL server as it clearly indicate that path to /tmp folder is not correct. I think it has nothing to do with MYSQL.
Wed Aug 26, 2009 2:22 pm - Re: Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
#216
webe
hi Arvind, my error was related to MYSQL SERVER, because my tables needed space in the harddrive, but beacuse MSYQL could not write any more data to the disk, i got this error.
Wed Sep 23, 2009 9:51 pm - Re: Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
#254
subhakar
nice answer frm u
thanq
thanq
Wed Jul 28, 2010 12:05 am - Re: Warning: Unknown(): write failed: No space left on device (28) in Unknown on line 0
#4257
Skum
Thank you. Worked as a charm.