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   1163 Views

Avatar
vwd

30 April 2012 at 10:51am Community Member, 159 Posts

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

4 May 2012 at 1:37am Forum Moderator, 1796 Posts

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

5 May 2012 at 7:14am Community Member, 159 Posts

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.