Results 1 to 2 of 2

Thread: SQL error 1146 appeared under accounts

  1. #1
    graphitexp is offline Junior Member
    Join Date
    Jan 2007
    Posts
    1

    Unhappy SQL error 1146 appeared under accounts

    Hi,
    Any one had the same problem?
    This error appeared when i listed the account details..

    Error running count query for Account List: Query Failed SELECT count( DISTINCT threads.id) FROM threads INNER JOIN accounts_threads ON (threads.id=accounts_threads.thread_id AND accounts_threads.account_id='81446e73-c5b9-b6d4-b955-45bccf268d29') where ( accounts_threads.deleted=0 AND threads.deleted=0) AND threads.deleted=0 )::MySQL error 1146: Table 'sugarcrm.threads' doesn't exist

    Cheers,
    Bobby

  2. #2
    Deuce is offline Sugar Community Member
    Join Date
    Aug 2006
    Location
    California
    Posts
    66

    Default Re: SQL error 1146 appeared under accounts

    Did you by chance install the Forums module and then remove it? The 'threads' table the error refers to is part of that module... The easy fix would be to install the Forums module, available at http://www.sugarcrm.com/crm/download/sugar-suite.html

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Accounts, Contacts and B2C implementations
    By organi in forum General Discussion
    Replies: 46
    Last Post: 2010-05-23, 07:04 PM
  2. Replies: 1
    Last Post: 2008-02-22, 04:25 PM
  3. Replies: 1
    Last Post: 2006-09-11, 03:38 PM
  4. Replies: 5
    Last Post: 2005-12-07, 05:25 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
  •