AnsweredAssumed Answered

Unknown column 'm1.name' in 'field list'

Question asked by Pat Pawlowski on May 17, 2017
Latest reply on May 30, 2017 by Maulik Shah

The following SQL error shows up repeatedly in our log and I can't figure out where it's coming from or why it thinks there's a name field in the users table. 

 

Wed May 17 12:35:59 2017 [25358][rfa01][FATAL]  Query Failed: SELECT DISTINCT m1.id,m1.name,m1.date_modified,m1.deleted,rt.deleted relationshipdeleted,rt.date_modified relationshipmodified FROM contacts_users rt  inner join users m1 on rt.user_id = m1.id  inner join contacts m2 on rt.contact_id = m2.id AND m2.id = 'rfa01' WHERE (m1.date_modified > '2014-01-02 03:20:59' AND m1.date_modified <= '2017-05-18 17:35:56' AND m1.deleted = 0) AND m2.id = 'rfa01' LIMIT 0,256: MySQL error 1054: Unknown column 'm1.name' in 'field list'

 

It's as strange collection of fields that it's pulling so I don't think it's anything for the UI like a dashboard or anything. It also occurs for several different users. 

 

-pat

Outcomes