Jump to:

23489 Posts in 18996 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine

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

Page: 1
Go to End
Author Topic: 1137 Views
  • vwd
    Avatar
    Community Member
    158 Posts

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

    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

  • swaiba
    Avatar
    Forum Moderator
    1792 Posts

    Re: Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine Link to this post

    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?

  • vwd
    Avatar
    Community Member
    158 Posts

    Re: Error: Couldn't run query: SHOW FULL FIELDS IN "Member" Got error 28 from storage engine Link to this post

    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.

    1137 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.