[SOLVED][Drupal Errors] Got error 28 from storage engine query" error
Many Drupal users received a "user warning: Got error 28 from storage engine query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2,3) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/your-username-here/public_html/modules/block/block.module on line 433." If you are facing the same situation in your Drupal site then read on to find out the solution.
The Error 28 occurs when there is not enough disk space left for MySQL to run properly. It could be because
- The filesystem/hardrive is full.
- The web host oversoldd their shared hosting or
- The host misconfigured their shared MySQL install.
To fix it you must increase the disk space either by deleting files or request your host to provide the increased space.
Hope that helps.
The easiest way to solve a Drupal issue is to hand it to the Drupal experts. We can provide a wide range of Drupal services to help you maintain and manage your Drupal websites. Get in touch with us to know more.
Reference: http://drupal.org/node/768530