Results 1 to 2 of 2

Thread: MySQL server has gone away, happens on login, then its fine

  1. #1
    ericTM313 is offline Junior Member
    Join Date
    Oct 2007
    Posts
    1

    Default MySQL server has gone away, happens on login, then its fine

    Hello all,
    Upon logging in (every user, with any type of permissions/settings), I get the following error:
    Unable to retrieve system settings Query Failed:SELECT category, name, value FROM config::MySQL error 2006: MySQL server has gone away

    After this error appears, I can hit the back button and everything works completely fine, no errors whatsoever.

    So this shouldn't be a big deal really, but the boss is complaining

    Ive googled and searched here, only solution I've come up with is the mysql packet size, which is currently set to 16mb. I can run the above query in phpmyadmin with no problems.

    I am on shared hosting, linux (not sure what distro, but i believe centos), php 4.3.11, mysql 5.0.18, sugar version 4.5.1f open source

    Any help is appreciated. thanks!

    -Eric

  2. #2
    sacramentojoe is offline Sugar Community Member
    Join Date
    Nov 2005
    Posts
    447

    Default Re: MySQL server has gone away, happens on login, then its fine

    max_allowed_packet is a server option which needs to be set in the
    [mysqld] section of /etc/my.cnf, not specified to the 'mysql' client
    on the command line like you're trying. But generally you're going
    in the right direction - the "MySQL server has gone away" error is
    caused by a query longer than the max_allowed_packet.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 2007-11-13, 02:51 PM
  2. Replies: 2
    Last Post: 2007-07-01, 09:55 PM
  3. Huge backups -- normal?
    By Liam in forum Help
    Replies: 5
    Last Post: 2007-05-02, 05:36 AM
  4. Replies: 7
    Last Post: 2007-02-14, 03:48 PM
  5. Replies: 0
    Last Post: 2006-04-24, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •