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.

General Questions /

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

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

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


Reply


3 Posts   1248 Views

Avatar
vwd

Community Member, 160 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, 1805 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, 160 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.