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're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

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

Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine


Go to End


3 Posts   2042 Views

Avatar
vwd

Community Member, 166 Posts

30 April 2012 at 10:51am

Hi,

On a client's SS site, we're intermittently getting the following error:

Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine
At line 525 in /home/clientsite/public_html/sapphire/core/model/MySQLDatabase.php

user_error(Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine,256) line 525 of MySQLDatabase.php MySQLDatabase->databaseError(Couldn't run query: SHOW FULL FIELDS IN "Member" | Got error 28 from storage engine,256) line 123 of MySQLDatabase.php MySQLDatabase->query(SHOW FULL FIELDS IN "Member",256) line 129 of DB.php DB::query(SHOW FULL FIELDS IN "Member") line 332 of MySQLDatabase.php MySQLDatabase->fieldList(Member) line 320 of DB.php DB::fieldList(Member) line 871 of Security.php Security::database_is_ready() line 81 of Controller.php Controller->init() line 136 of Controller.php Controller->handleRequest(SS_HTTPRequest) line 282 of Director.php Director::handleRequest(SS_HTTPRequest,Session) line 125 of Director.php Director::direct(/Security/ping) line 127 of main.php

Any ideas? What is "Error 28"?

I've already done a /dev/build?flush=all, and unfortunately can't debug as it is only happening of the production server.

Thank you very much.
VWD

Avatar
swaiba

Forum Moderator, 1899 Posts

4 May 2012 at 1:37am

I think "error 28" relates to disk space - could be wrong but I remember it from a recent migration check the size and contents of your tmp/cache folder.

How many members do you have on the site? alot?

Avatar
vwd

Community Member, 166 Posts

5 May 2012 at 7:14am

G'day Barry,

Thanks for your suggestion. The site does a good bit of headroom, at least 450MB of storage, left. Also there are only a couple of users.

It's an odd one - haven't had it repeat for nearly a week despite the same usage of the site.

Will wait and see and dig into the code RE: error 28.

Thank you for your help.

VWD.