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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Installing SilverStripe /

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

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

Random Errors?


Go to End


2059 Views

Avatar
pinkp

Community Member, 182 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>