Migrating from Sugar Appliance CD to Ubuntu 6.06 : character set issue

[ECR]

Hi all,

I try since months to migrate from a SugarCRM 4.2.0d installed using a Sugar appliance iso CD to a SugarCRM 4.2.0d under Ubuntu 6.06 system. Here are the steps I followed :

1) backup of current DB under source system using phpmyadmin throught a firefox client installed under ubuntu 6.10.
2) Backup of current SugarCRM files using admin "Backup files" option of SugarCRM.
3) Install a full package of SugarCRM (including MYSQL & PHP) in versoion 4.2.0d.

Up to now everything works fine. SugarCRM starts on a firefox client, with no data, obviously as it is a brand new system.

Now tring to restore old datas.

4) Using phpmyadmin : deleting new SugarCRM Mysql database
5) restore old DB and datas.
6) Replace of SugarCRM new directory by old one
7) Replace old config.php (under SugarCRM directory) by the new one. I don't know why, but if I don't do this nothing is displayed by the server.

Now I'm able to access old datas with SugarCRM installed under Ubuntu. By I have a last issue. All works fine displaying the list of all accounts. But if I want details about one account, I get the following error message :

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 , meetings.parent_id , meetings.parent_type , meetings.time_start , meetings.assigned_user_id , 'meetings' panel_name FROM meetings where ( meetings.parent_id= 'b0e14c90-b0fa-c5a6-abbd-44bd0e4997e6' 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 , tasks.parent_id , tasks.parent_type , 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 where ( tasks.parent_id= 'b0e14c90-b0fa-c5a6-abbd-44bd0e4997e6' 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 , calls.parent_id , calls.parent_type , calls.time_start , calls.assigned_user_id , 'calls' panel_name FROM calls where ( calls.parent_id= 'b0e14c90-b0fa-c5a6-abbd-44bd0e4997e6' AND calls.parent_type='Accounts' AND calls.deleted=0 AND (calls.status='Planned')) AND calls.deleted=0 ) ORDER BY date_start asc::MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

Note the Mysql error at the end of the message : "Error MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'"

What's wrong?

Several (useful?) details:
* All pieces of software comes either with the Iso CD or with the SugarCRM packages.
* I'm french and I use Synolia french translation patch under source source system

[ruchida]

Hope this helps.

[ECR]

Hi Ruchida,

I already saw this thread before posting and tried to apply it. I don't know where is this my.cnf file. I found one under /etc but it isn't used. I tried to find one under sugarcrm directories but I couldn't find any.

Where should be this file?

Merry Chrismas