Jump to:

23355 Posts in 17744 Topics by 2862 members

General Questions

SilverStripe Forums » General Questions » Fatal error: Couldn't run query....Got error 28

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: 610 Views
  • honeybunny
    Avatar
    Community Member
    79 Posts

    Fatal error: Couldn't run query....Got error 28 Link to this post

    My question is whether there is any way that this is a coding error? After a few days of up again down again the site is now throwing the following error:

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

    My feeling that this is a host issue. The client is on a shared host and is running Silverstripe 2.4.7 on Apache, PHP version 5.3.13, MySQL 5.1.63. Two days ago the site was down with server full errors. It came up yesterday, but is now down with this "error 28" message, which I think is also a server full type error.

    This site has run fine for several months without issue. The only recent change was to add a (simple) new page type with a jquery slider and a latest news call. Very, very easy and basic. I've used the slider several times before and the latest news comes straight from the tutorial. It's a very simple site, no bells or whistles. If it makes a difference, the "Member" table only has three members.

    Any ideas before I write off the rest of my day with the host's support team?

    Thanks from one desperate bunny...

    HB

  • martimiz
    Avatar
    Forum Moderator
    1067 Posts

    Re: Fatal error: Couldn't run query....Got error 28 Link to this post

    I never had this happen myself, but googling 'mysql error 28 from storage engine' I saw an awful lot of posts reporting this to be an 'out of diskspace' error, where MySQL cannot write to disk anymore, resulting in every query giving this error...

    So maybe the client simply ran out of (tmp) diskspace? If not, I'd definitely contact the hosting provider...

  • honeybunny
    Avatar
    Community Member
    79 Posts

    Re: Fatal error: Couldn't run query....Got error 28 Link to this post

    Thanks for the input! I found pretty much the same info online. The client's usage is minimal, less than 1% of allocated resources (disk space, bandwidth, etc...) and I wasn't able to log in to the host's billing system (it was down as well) to submit a trouble ticket which implied to me that the problem extended further than the client's site. The only response I've had from the host through the various outages is that the site is up and working fine. (Which it did for about 20 hours.) When I went back in to add a new page yesterday it was down again. It's up now, but who knows how long that will last.

    On a side note, I Love your blog! I can't remember what I was looking for when I found it, but it was very, very helpful!

    Thanks!

    HB

    610 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.