MySQL error 1054 on account details - ONLY as non-admin user

[yoggiecrm]

Hi all,
We haven't had SugarCRM for too long, and we're still learning the ropes.

Could anyone assist with the annoying problem we're having?

Any user who ISN'T admin gets the following error in any account details page, right after the "Description" field title:

Error running count query for Account List: Query Failed:( SELECT count( DISTINCT threads.id) FROM threads INNER JOIN team_memberships team_memberships ON threads.team_id = team_memberships.team_id AND team_memberships.user_id = 'c86cd0f2-76db-0822-7795-456c8cb985d1' AND team_memberships.deleted=0 INNER JOIN accounts_threads ON (threads.id=accounts_threads.thread_id AND accounts_threads.account_id='daede6ed-e348-8335-0344-457ced0cc7c4') where ( accounts_threads.deleted=0 AND threads.deleted=0) AND threads.deleted=0 )::MySQL error 1054: Unknown column 'threads.team_id' in 'on clause'

This problem doesn't exist when using the admin user.

Please help!

Thanks in advance!

[JoeAcunzo]

We're getting the exact same error. Did you ever find a solution?

I believe this began after upgrading from the Open Source version to the Professional version, but not 100% sure about that. I checked the "threads" table, and in fact, the "team_id" column is not in the table.

[kbrill]

The problem for Joe turned out to be the OS version of the Forums module. After uninstalling it all was fixed. Then you can install the PRO version of the fourms module.