Results 1 to 4 of 4

Thread: Error retrieving Email list

  1. #1
    hadar is offline Junior Member
    Join Date
    Nov 2006
    Posts
    1

    Default Error retrieving Email list

    Hello,
    I installed the open sorce CRM today so i could check it and recommand this system to my compny
    I'm getting this error when im trying to get to the Emails

    Error retrieving Email list: Query Failed:SELECT emails.*, CONCAT(emails.date_start, CONCAT(' ', emails.time_start)) date_sent, users.user_name as assigned_user_name, contacts.first_name, contacts.last_name FROM emails LEFT JOIN emails_contacts ec ON emails.id = ec.email_id LEFT JOIN contacts ON ec.contact_id = contacts.id LEFT JOIN users ON emails.assigned_user_id=users.id WHERE emails.assigned_user_id = '1' AND emails.type = 'inbound' AND emails.status != 'archived' AND emails.deleted=0 ORDER BY date_sent DESC LIMIT 0,20::MySQL error 2013: Lost connection to MySQL server during query

    can you please help me

  2. #2
    jstievenart is offline Sugar Community Member
    Join Date
    Apr 2007
    Location
    Bruxelles, Belgium
    Posts
    13

    Default Re: Error retrieving Email list

    I'm getting exactly the same problem....
    Jerome Stievenart
    IT Manager @ Think IT sprl

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

    Default Re: Error retrieving Email list

    hadar and jstievenart, please confirm the exact version of Sugar you are running. Is it 5.0 GA?

    Also what is your environment? MySQL version, etc.?

    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

  4. #4
    jstievenart is offline Sugar Community Member
    Join Date
    Apr 2007
    Location
    Bruxelles, Belgium
    Posts
    13

    Default Re: Error retrieving Email list

    The version I use is 4.5.1h
    The problem has appeared after I did upgrade from a previous release.
    Could be a configuration issue but i don't know where to look at...
    Jerome Stievenart
    IT Manager @ Think IT sprl

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
  •