Results 1 to 3 of 3

Thread: MySQL error 1146: Table doesn't exist

  1. #1
    ryytuo is offline Junior Member
    Join Date
    Aug 2011
    Location
    Finland
    Posts
    2

    Default MySQL error 1146: Table doesn't exist

    Hello everybody

    Can you help me with this problem, please? I have installed Sugar CRM 6.0 and few modules.

    My problem is following: I got several times announcements like

    "Error running count query for Contact List: Query Failed SELECT count(*) c FROM lchat_chattranscript INNER JOIN lchat_chattipt_contacts_c ON (lchat_chattranscript.id=lchat_chattipt_contacts_c .lchat_chatdf54nscript_idb AND lchat_chattipt_contacts_c.lchat_chat1fdbontacts_id a= '9efddeef-e175-ffa6-9908-4e5a7cd1798c') where ( lchat_chattipt_contacts_c.deleted=0 AND lchat_chattranscript.deleted=0) AND lchat_chattranscript.deleted=0 )::MySQL error 1146: Table 'daomocom_scrm5.lchat_chattranscript' doesn't exist"

    This error was coming when I try to create contact and I was logged as admin. It is fresh install and some modules were added.

    What can I do to fix the problem, I believe it is generic one but I was not able to find any answers.

  2. #2
    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: MySQL error 1146: Table doesn't exist

    Did you run Quick Repair and Rebuild?
    Hopefully it will create the missing table.
    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.

  3. #3
    ryytuo is offline Junior Member
    Join Date
    Aug 2011
    Location
    Finland
    Posts
    2

    Thumbs up Re: MySQL error 1146: Table doesn't exist

    Yes, now it works! Thank you very much.

    I use SugarCRM CE for teaching so it is nice to provide open source software for them.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 2010-11-10, 06:20 AM
  2. Replies: 0
    Last Post: 2010-02-04, 10:40 PM
  3. Replies: 9
    Last Post: 2009-01-22, 12:52 AM
  4. MySQL error 1146: Table doesn't exist
    By shootSOFT in forum Installation and Upgrade Help
    Replies: 1
    Last Post: 2008-11-13, 12:21 AM
  5. MySQL error 1146: Table 'sugarcrm.songs' doesn't exist
    By subhashini in forum Developer Help
    Replies: 2
    Last Post: 2006-04-17, 05:45 AM

Tags for this Thread

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
  •