Account Subpanels Not Diplayed (Error)

[jnovak]

I am getting the following error when I display an account. None of the subpanels are displayed. Does anyone have any ideas why I am getting this error? I get a similar error when viewing a contact.

Error retrieving Account list: Query Failed SELECT meetings.id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, meetings.time_start , meetings.assigned_user_id , 'meetings' panel_name FROM meetings LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( meetings.parent_id= '2611fcdc-6036-040b-9b2f-438b51118c4e' AND meetings.parent_type='Accounts' AND meetings.deleted=0 AND (meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name , tasks.contact_id , jt0.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.date_due as date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, tasks.time_due as time_start , tasks.assigned_user_id , 'tasks' panel_name FROM tasks LEFT JOIN contacts jt0 ON jt0.id= tasks.contact_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( tasks.parent_id= '2611fcdc-6036-040b-9b2f-438b51118c4e' AND tasks.parent_type='Accounts' AND tasks.deleted=0 AND (tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , calls.date_start , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, calls.time_start , calls.assigned_user_id , 'calls' panel_name FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ( calls.parent_id= '2611fcdc-6036-040b-9b2f-438b51118c4e' AND calls.parent_type='Accounts' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) ORDER BY date_start desc::MySQL error 1267: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'UNION'

Thanks,
John Novak

» Operating system type and version: Windows XP Professional, Fedora Core 4
» Sugar Suite version: OS 4.2.1b
» Webserver type and version: Apache 2.0.54
» PHP version: 5.0.4
» MySQL server version: 4.1.16

[jnovak]

Just an update.

When I rebooted the server, the problem seemed to disappear. Any ideas why that would happen?

Thanks,

John Novak

[jnovak]

Another update!

I was able to duplicate this problem.

I installed another instance of SugarCRM OS version 4.5.0RC. When I run this instance and then go back to my production version 4.2.1b, the problem reappears. After rebooting the server, the problem diappears.

Any ideas why this would happen? Is it unacceptable to run two instances of this program that are different versions?

Thanks,

John Novak

[EdSawyer]

The error is telling you why it's having trouble:

Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'UNION'

Look at the collations of the tables in your mysql DB. Chances are they are not all the same. 4.5 uses a different set of collations, IIRC, ... there was some discussion of it in the 4.5 threads. Normalize the tables so they are all using the same collation and it should work fine. Chances are you probably can't use the same set of tables to run both a 4.2x instance and a 4.5 instance due to this (possibly.. just speculating on that last point).

-Ed

[ruchida]

Another update!

I was able to duplicate this problem.

I installed another instance of SugarCRM OS version 4.5.0RC. When I run this instance and then go back to my production version 4.2.1b, the problem reappears. After rebooting the server, the problem diappears.

Any ideas why this would happen? Is it unacceptable to run two instances of this program that are different versions?

Thanks,

John Novak

I had a similar issue at one of customers' sites. It was due to an inappropriate permission on direcotries and files.