Troubleshooting
Help! What is this MySQL error code 28 thing?
Scenario:
"For no reason at all, I got this error message where my blogs should be.
mySQL error with query SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, i.itime, i.imore as more, m.mnumber as authorid, m.memail as authormail, m.murl as authorurl, c.cname as category, i.icat as catid, i.iclosed as closed FROM nucleus_item as i, nucleus_member as m, nucleus_category as c WHERE i.iblog=1 and i.iauthor=m.mnumber and i.icat=c.catid and i.idraft=0 and i.itime<="2006-05-02 19:51:08" ORDER BY i.itime DESC LIMIT 0,10: Got error 28 from storage engine
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/username/public_html/path/to/nucleus/libs/BLOG.php on line 165
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/username/public_html/path/to/nucleus/libs/BLOG.php on line 202
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/username/public_html/path/to/nucleus/libs/BLOG.php on line 211
How can I fix this?"
Solution:
Error 28 means that one or more partitions on your server is out of space or doesn't have enough space to complete this operation. You or your host will need to find out which partition is low on disk space and either add more space or free up some.
Original forum thread (thanks, xiffy!):
http://forum.nucleuscms.org/viewtopic.php?t=12050
Total votes: 18 - Rating: 1.39