What does this error mean?

[Barbossa]

From time to time, I am getting this error. It just happened after upgrade to v 1.1.3.

Mysqli statement execute error : Got error 28 from storage engine

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 218
XenForo_Model->fetchAllKeyed() in XenForo/Model/Post.php at line 198
XenForo_Model_Post->getPostsInThread() in XenForo/ControllerPublic/Thread.php at line 69
XenForo_ControllerPublic_Thread->actionIndex() in XenForo/FrontController.php at line 310
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /home/jj/public_html/index.php at line 13

How to fix this?

 

[ragtek]

error28 means, that you have no free disk space at your db server anymore

 

[CTXMedia]

Error Code 28 (No space left on device)

Shutdown your forums, check disk space (and /tmp space) - maybe do a disk clean-up?

 

[CTXMedia]

Check for "log" files - some of them can get quite big but are non-essential and compressing or deleting them might give you some headroom whilst you sort something more permanent.

 

[Barbossa]

error28 means, that you have no free disk space at your db server anymore

Check for "log" files - some of them can get quite big but are non-essential and compressing or deleting them might give you some headroom whilst you sort something more permanent.

What folder, what sort of file type I should check for?

 

[CTXMedia]

What folder, what sort of file type I should check for?

If you're not sure it might be best to consult with your host. If you're on a shared/VPS plan the host might have put quotas in place to limit the space you can use - they may be able to temporarily lift the restriction whilst you sort the problem.

If you're managing your own server and it's a Linux box the logs are usually in #/var/log/ - but if you're not sure what you're doing it's probably best not to mess with the logs.

To find out how much drive space is being used by logs use du with the -h switch du -h * (whilst in the logs directory) - this way you can see whether the logs use a little or a lot of space. If they use a lot, do an ls -lap and post the results here.

Cheers,
Shaun

 

[Jake Bunce]

Also, the df command in the shell will show all partitions and their available space.

 

[Mr. Goodie2Shoes]

My first question is: Are you using a VPS or Shared Hosting?
If you are using a Shared Hosting, then contact your service provider... they sometimes use quotas for Databases...

 

[Barbossa]

My first question is: Are you using a VPS or Shared Hosting?
If you are using a Shared Hosting, then contact your service provider... they sometimes use quotas for Databases...

Guess what! I am on my dedicated server!

 

[Mr. Goodie2Shoes]

Guess what! I am on my dedicated server!

then you probably need to tweak your cPanel's config