error log unknown meetings.contact_id

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hi,

I keep having this in error log:
MySQL error 1054: Unknown column ‘meetings.contact_id’ in ‘where clause’

Any idea how to solve this please?

SuiteCRM 7.9.8
PHP 7

2

Your error is probably much longer than that, and includes a full query, no?

Or a place from the code where it is being called from?

3

Hi pgr,

Mon Feb 5 15:46:38 2018 [16522][c6ecdcc6-72d3-4148-70df-55b797fd8d80][FATAL] Query Failed: SELECT meetings.id AS id FROM meetings LEFT JOIN meetings_contacts ON meetings.id=meetings_contacts.meeting_id AND meetings_contacts.deleted=0

LEFT JOIN contacts contacts ON contacts.id=meetings_contacts.contact_id AND contacts.deleted=0
WHERE contacts.id = meetings.contact_id AND meetings.id = ‘7968a44f-329e-59d7-7fad-5a787c61eb78’ LIMIT 0,1: MySQL error 1054: Unknown column ‘meetings.contact_id’ in ‘where clause’
Mon Feb 5 15:46:38 2018 [16522][c6ecdcc6-72d3-4148-70df-55b797fd8d80][FATAL] Get One Failed:SELECT meetings.id AS id FROM meetings LEFT JOIN meetings_contacts ON meetings.id=meetings_contacts.meeting_id AND meetings_contacts.deleted=0

LEFT JOIN contacts contacts ON contacts.id=meetings_contacts.contact_id AND contacts.deleted=0
WHERE contacts.id = meetings.contact_id AND meetings.id = ‘7968a44f-329e-59d7-7fad-5a787c61eb78’: MySQL error 1054: Unknown column ‘meetings.contact_id’ in ‘where clause’

It joins meetings.contact_id but there’s no contact_id in the meetings table.
I am very confused on this.

4

If you go in Admin / Repair and do a Quick Repair and Rebuild, scroll down to the bottom and see if you get a button to “sync vardefs with database”. If yes, press it.