Results 1 to 9 of 9

Thread: Help Help ::: Please

  1. #1
    Join Date
    Oct 2008
    Location
    Brasil
    Posts
    12

    Question Help Help ::: Please

    ERRO:

    Retrieving record by id email_marketing:f07e07bd-a583-cef9-33da-4b2f6c959fd4 found Query Failed:SELECT email_marketing.* FROM email_marketing WHERE email_marketing.id = 'f07e07bd-a583-cef9-33da-4b2f6c959fd4' AND email_marketing.deleted=0 LIMIT 0,1::MySQL error 2006: MySQL server has gone away

  2. #2
    datasponge is offline Sugar Community Member
    Join Date
    Mar 2008
    Location
    San Jose, CA, USA
    Posts
    553

    Default Re: Help Help ::: Please

    Can't really tell much from the error.

    What were you trying to do when this error occurred? What view were you displaying? Did other data show up correctly on the screen above it?

    If you provide all the steps you took leading up to this error, it will be much easier to see what happened.

    Phil

  3. #3
    Join Date
    Oct 2008
    Location
    Brasil
    Posts
    12

    Default Re: Help Help ::: Please

    Quote Originally Posted by datasponge View Post
    Can't really tell much from the error.

    What were you trying to do when this error occurred? What view were you displaying? Did other data show up correctly on the screen above it?

    If you provide all the steps you took leading up to this error, it will be much easier to see what happened.

    Phil
    Thanks Phil,
    the error happens when I try to send emails in the send queue (ADMIN), and also happens when the crontab runs the scheduled task: it does not send any e-mail and inform this error.
    Thank you for your help!

    Arthur

  4. #4
    datasponge is offline Sugar Community Member
    Join Date
    Mar 2008
    Location
    San Jose, CA, USA
    Posts
    553

    Default Re: Help Help ::: Please

    I'm not much of an email expert, so someone else will need to jump in.

    But you should post your SugarCRM version, since the email handling has changed dramatically in different versions.

    Also, let us know any customizations you've done related to emails. That message could be from a system function or as a result of a problem in a before or after save logic hook.

    Phil

  5. #5
    Join Date
    Oct 2008
    Location
    Brasil
    Posts
    12

    Default Re: Help Help ::: Please

    Phil,
    I use the version 5.2.0e (5626) and did not do any customization module email, only the required settings for POP and SMTP.

    In Mysql Admin called "SELECT email_marketing.* FROM WHERE email_marketing email_marketing.id = 'f07e07bd-A583-cef9-33da-4b2f6c959fd4' AND email_marketing.deleted = 0 LIMIT 0,1" runs perfectly. The error only happens when it is done by crontab.

    Look
    1 - Sending emails using php for a server e-mail in and out of server
    The sending of messages functioned ok

    2 - Execution of query directly on the server database
    I ran the query that has mentioned that "server has gone away" directly in the database working correctly, ie, the query goes to the bank is carried out quickly and correctly.

    The application runs in:
    Red Hat Enterprise Linux Server release 5.4 (Tikanga)
    Server version: Apache/2.2.14 (Unix)

    Thanks for your help!

  6. #6
    datasponge is offline Sugar Community Member
    Join Date
    Mar 2008
    Location
    San Jose, CA, USA
    Posts
    553

    Default Re: Help Help ::: Please

    Hi Arthur,

    No one else has jumped in, so I'll throw out some ideas.

    It sounds like permissions accessing your database from Sugar. It may be an install problem setting up access to the database. When you test the sql statement in MySQL Admin, make sure you use the same login name that Sugar will be using.

    Check your database configuration parameters. Look in the file config.php and find the dbconfig array. It should show the database name, user name, password, etc. Make sure all these are correct and that the query works when running as that user.

    I run from console on the server and use mysql -u admin or whatever user name you setup at install time. I don't use mysql admin, so I don't know how to set the user, but you should be able to figure this out.

    Phil

  7. #7
    Join Date
    Oct 2008
    Location
    Brasil
    Posts
    12

    Default Re: Help Help ::: Please

    Hello Phil, unfortunately still not that, checked the data connection and everything is ok.
    Have any other ideas?
    Thank you,

  8. #8
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Help Help ::: Please

    Try to follow the suggestions here.

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  9. #9
    Merlia is offline Junior Member
    Join Date
    May 2010
    Posts
    1

    Default Re: Help Help ::: Please

    Thanks for sharing andopes, it was very useful for me.

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
  •