Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Random Errors?


Reply


1427 Views

Avatar
pinkp

Community Member, 168 Posts

6 October 2009 at 4:04am

I am having trouble accessing and editing in the CMS admin, I get these errors sometimes but not all the time! It has problems accessing the admin and also saving changes please could someone advise me as to what this means:

--------------------------------------------

ERROR [User Error]: Couldn't run query:
SHOW FULL FIELDS IN `Permission`

Got error 28 from storage engine
IN POST /admin/getitem?ID=5&ajax=1
Line 401 in /home/sites/mysite.co.uk/public_html/sapphire/core/model/MySQLDatabase.php

Source
======
392:    }
393:    
394:    function databaseError($msg, $errorLevel = E_USER_ERROR) {
395:       // try to extract and format query
396:       if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
397:          $formatter = new SQLFormatter();
398:          $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
399:       }
400:       
* 401:       user_error($msg, $errorLevel);
402:    }
403: }
404:
405: /**
406: * A result-set from a MySQL database.
407: * @package sapphire

<ul>user_error(Couldn't run query:
SHOW FULL FIELDS IN `Permission`

Got error 28 from storage engine,256)
line 401 of MySQLDatabase.php

MySQLDatabase->databaseError(Couldn't run query: SHOW FULL FIELDS IN `Permission` | Got error 28 from storage engine,256)
line 102 of MySQLDatabase.php

MySQLDatabase->query(SHOW FULL FIELDS IN `Permission`,256)
line 120 of DB.php

DB::query(SHOW FULL FIELDS IN `Permission`)
line 276 of MySQLDatabase.php

MySQLDatabase->fieldList(Permission)
line 271 of DB.php

DB::fieldList(Permission)
line 942 of Security.php

Security::database_is_ready()
line 84 of Controller.php

Controller->init()
line 100 of LeftAndMain.php

LeftAndMain->init()
line 84 of CMSMain.php

CMSMain->init()
line 113 of Controller.php

Controller->handleRequest(HTTPRequest)
line 277 of Director.php

Director::handleRequest(HTTPRequest,Session)
line 121 of Director.php

Director::direct(/admin/getitem)
line 118 of main.php

</ul>