Jump to:

22976 Posts in 11702 Topics by 2826 members

General Questions

SilverStripe Forums » General Questions » CHARACTER SET 'utf8' error

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 2
Go to End
Author Topic: 3003 Views
  • midoriberlin
    Avatar
    Community Member
    5 Posts

    Re: CHARACTER SET 'utf8' error Link to this post

    Hello all,

    A little late but this might help someone. I was getting exactly the same error, not locally but after I uploaded to a live site.

    Afterwards I realised what was happening was I had an admin window open in my local environment which, due to checking out a different version of the site to push to live, was unable to security ping to the correct address.

    And so I get this error every minute while that was the case. Check the subject of the email you get and see if it has anything about "security ping" in it and if so a variation on the scenario above may be the problem.

    cheerio,

    a

  • borriej
    Avatar
    Community Member
    267 Posts

    Re: CHARACTER SET 'utf8' error Link to this post

    I am also getting this error.

    I had a live site transferred from one hosting to another. At previous hosting it ran perfectly.. but now, i receive this error. mysite/_config.php is set to connect to the correct database.

    Any idea's?

    [05-Apr-2012 08:29:14] Error at sapphire/core/model/MySQLDatabase.php line 525: Couldn't run query:
    SET CHARACTER SET 'utf8'

  • borriej
    Avatar
    Community Member
    267 Posts

    Re: CHARACTER SET 'utf8' error Link to this post

    typo in password.. solved

  • oleze
    Avatar
    Community Member
    64 Posts

    Re: CHARACTER SET 'utf8' error Link to this post

    Seems on my local development systems (MAMP) the error came from using "localhost" as a alias for my database-server. Changed it to "127.0.0.1" and the error is gone.

  • techgyver
    Avatar
    Community Member
    6 Posts

    Re: CHARACTER SET 'utf8' error Link to this post

    I just had the same issue. The error was caused by too many mysql-connections, so i increased the limit and solved the problem.

  • AdamJ
    Avatar
    Community Member
    145 Posts

    Re: CHARACTER SET 'utf8' error Link to this post

    @techgyver - how did you do that?

    3003 Views
Page: 1 2
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.