We recently upgraded SugarCRM to 4.5.0c and prior to the upgrade uninstalled "Forums, Threads, Post Modules version 4.5.0c" with the plan to reimplement the package once everything was upgraded.
Unfortunately things didn't go so well.
Our accounts and opportunities show the message
Error running count query for Opportunity List: Query FailedSELECT count(*) c FROM threads INNER JOIN opportunities_threads ON (threads.id=opportunities_threads.thread_id AND opportunities_threads.opportunity_id='e1cd5ceb-d254-ce2a-f0c4-4549e9e70dfb') where ( opportunities_threads.deleted=0 AND threads.deleted=0) AND threads.deleted=0 )::MySQL error 1146: Table 'sugarcrm.threads' doesn't exist
The module isn't loaded in the admin screen. We've tried reinstalling it, but it hangs up at 81%. The log of the installation is shown below:
Adding for Leads
Adding for Contacts
Adding for Accounts
Adding for Opportunities
Adding for Cases
Adding for Notes
Adding for EmailTemplates
Adding for Calls
Adding for Emails
Adding for Meetings
Adding for Tasks
Adding for Bugs
Adding for Project
Adding for ProjectTask
Adding for Campaigns
Adding for ProspectLists
Adding for Prospects
Adding for Documents
Adding for EmailMarketing
At this point I don't care if the module is loaded or not as long as the error messge goes away. Does anyone have any suggestions on how to fix this?


LinkBack URL
About LinkBacks
SELECT count(*) c FROM threads INNER JOIN opportunities_threads ON (threads.id=opportunities_threads.thread_id AND opportunities_threads.opportunity_id='e1cd5ceb-d254-ce2a-f0c4-4549e9e70dfb') where ( opportunities_threads.deleted=0 AND threads.deleted=0) AND threads.deleted=0 )::MySQL error 1146: Table 'sugarcrm.threads' doesn't exist



Reply With Quote
Bookmarks