Results 1 to 3 of 3

Thread: Query failure in email module

  1. #1
    ahaupt is offline Junior Member
    Join Date
    Aug 2006
    Posts
    4

    Default Query failure in email module

    Hello Sugar Community,

    we had updated our sugar to the new version 4.5.0d (build 1168) system yesterday. Since we get the following error if we have to send a bigger email with attachment from the Sugar Document Module or the File System:

    Code:
    Query Failed:INSERT into emails set id='f00f89c4-ad66-8dd7-fe35-452deb5e60a6', date_entered='2006-10-12 07:13:54', date_modified='2006-10-12 07:13:54', assigned_user_id='1',
    ....
    Code:
    deleted='0'::MySQL error 1153: Got a packet bigger than 'max_allowed_packet' bytes
    I know the error from the mysql server. But it works before we updated sugar!
    Which default value you used for max_allowed_packet in my.cnf?

    regards,
    Alex


    OS: Suse 9
    Sugar: OS 4.5.0d (build 1168)

  2. #2
    j0hn is offline Sugar Community Member
    Join Date
    Feb 2005
    Posts
    37

    Default Re: Query failure in email module

    in etc/my.cnf

    in this section:
    [mysqld]

    add:

    max_allowed_packet=16M




    restart mysqld - - - now that error went away..

    This from:
    http://dev.mysql.com/doc/refman/5.0/...too-large.html

  3. #3
    andydreisch's Avatar
    andydreisch is offline Sugar Team Member
    Join Date
    Apr 2005
    Location
    San Jose
    Posts
    2,080

    Default Re: Query failure in email module

    Hi j0hn, would you like to add an entry in our SugarWiki about this issue? It would help for future reference.

    Thanks,

    Andy
    Andy Dreisch
    Vice President, Online Team


    Check out our Podcasts!
    Sugar University for training
    Sugar Wiki for developer and user help
    SugarForge for modules, themes, lang packs
    SugarExchange for production-ready extensions
    Enter/view bugs via the Sugar bug tracker

Thread Information

Users Browsing this Thread

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

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
  •