AnsweredAssumed Answered

When adding new field in Studio contatcs desapearing

Question asked by budo@interia.pl on Dec 29, 2014
Latest reply on Jan 11, 2016 by Dhaivat Naik
Hi,

I created new field (URL type) in Studio:
Admin/Studio/Contacts/Fields/Add Field (Data Type: URL)
It gone good.

Then when I go to Contact List I cannot see anything. It seams that all contacts desapeard.
I tried the same in Leads - the resukt was exacly the same.

After deleting the newly created field all contacts showed up ...

Please, help.
Bud

Sugar CRM CE 6.5.17 (Build 1220)

Log file shows:
Mon Dec 29 10:31:22 2014 [2292][1][FATAL]  Query Failed:  SELECT  leads.id , LTRIM(RTRIM(CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')))) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.account_id , leads.phone_work  , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) assigned_user_name , jt0.created_by assigned_user_name_owner  , 'Users' assigned_user_name_mod, leads.date_entered , leads.assigned_user_id  FROM leads  LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c   LEFT JOIN  users jt0 ON leads.assigned_user_id=jt0.id AND jt0.deleted=0

 AND jt0.deleted=0 where leads.deleted=0 ORDER BY leads.date_entered DESC LIMIT 0,31: MySQL error 1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_polish_ci,IMPLICIT) for operation '='

Outcomes