PT language characters problem
Brought to you by:
thomasbley
Menu
▾
▴
1 Attachments
#371 PT language characters problem
Simple Groupware version: 0.745
Simple Groupware language: ptPT
PHP Version: 5.4.7
Database + Version: mysql 552
Server OS: Windows NT 6.1 build 7601 (Windows 7 Home Premium Edition Service Pack 1) i586
Webserver: Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7
Webbrowser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0
APC cache usage: not installed
Disk usage: 126 GB / 931 GB
Hello,
I have an collation or character issue that might be breaking my Simplegroupware db but I'm not really sure how to solve!
The input data on the simple_contacts and simple_companies is on Portuguese so I think I have problems with special characters like ç ã á à (don't know if commas or dashes might be breaking as well).
If I create a company by instance with special characters and then I associate contacts with the company. Sometimes the newly created company appears as null on the contact search field. Sometimes after associating the company with the contact everything appears normal but they don't get properly linked because If I go on the specific company and then click the contact link an error message appears as "item not found".
I have the collation set to utf8_general_ci on all tables except:
simple_seq_simple_categories
simple_seq_simple_cms
simple_seq_simple_companies_ki
simple_seq_simple_contactgroups
simple_seq_simple_contactgroups_ki
simple_seq_simple_contacts_ki
simple_seq_simple_emails_ki
simple_seq_simple_portal
simple_seq_simple_sys_console
simple_seq_simple_sys_custom_fields
simple_seq_simple_sys_events
simple_seq_simple_sys_groups
simple_seq_simple_sys_hosts
simple_seq_simple_sys_identities
simple_seq_simple_sys_stats
simple_seq_simple_sys_tree
simple_seq_simple_sys_users
these ones are set to latin1_swedish_ci which is the default collation of mysql version so I guess they adopted the default collation.
I have already a lot of entries on the database and I would like to know If there is a way to solve this problem so the database does not break if I make changes to the structure.
Thank you in advance,
TL
UPDATE:
I've attached a pdf with a few screenshots of the problem
Hello,
works for me, tested "ç ã á à ß" as company name. Screenshot is missing URLs, no PHP config given.
The attached PDF shows the table "simple_contacts_ki": When you change the Simple Groupware code base or add new code without publishing it, there can be no support for your code.
bye
Thomas
Hello Thomas,
Thank you for the reply.
I did a fresh install of simple groupware to test this issue again. I installed the latest version, portuguese installation.
I left everything by default and I create 2 companies and 2 contacts:
Company 1 - Name: Cucurica Marketing Comunicação Lda (no other fields added)
Company 2 - Name: Adereço. Comunicação e Eventos Culturais, Lda (no other fields added)
Contact 1: Last Name: Sara (no other fields added)
Contact 2: Last Name: Adereço - Comunicação e Eventos Culturais, Lda First Name: Geral (no other fields added)
When I try to associate Contact 1 with Company 1, Company 1 can't be associated because it's assumed as null.
I can associate Contact 2 with Company 2 but when I go to Company view and I click on associated contacts I get "item not found" error.
If you can please test the exact same configuration.
My supposition is that there must be something weird in going on in the database with some conjunction of characters because It does not happen with all this special characters only in special cases. I don't think It happens either If you try the special characters in an isolated manner.
I'm assuming you need mu php.ini file so I attach it. If you need I can do some more screenshots but they will be the same as in the previous post.
If you need anything else please let me know.
I appreciate very much the help.
Cheers,
TL
Hello,
forget this for the new installation Which I guess it's the same as before but nonetheless:
Simple Groupware version: 0.745
Simple Groupware language: ptPT
PHP Version: 5.4.7
Database + Version: mysql 552
Server OS: Windows NT TLKI-PC 6.1 build 7601 (Windows 7 Home Premium Edition Service Pack 1) i586
Webserver: Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7
Webbrowser: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.95 Safari/537.11
APC cache usage: not installed
Disk usage: 126 GB / 931 GB
Cheers
Hello,
you might try these settings in your php.ini:
mbstring.internal_encoding = UTF-8
mbstring.func_overload = 7
bye
Thomas
Hello,
Thank you very much for the reply as 1 of the problems got solved. I think the portuguese special characters issue is solved. I still have a small problem with company 2 though:
Company 2 - Name: Adereço. Comunicação e Eventos Culturais, Lda (no other fields added)
Contact 2: Last Name: Adereço - Comunicação e Eventos Culturais, Lda First Name: Geral (no other fields added)
I can associate Contact 2 with Company 2 but when I go to Company view and I click on associated contacts I get "item not found" error.
If I just remove the comma of the company name the issue disappears (Company 2 - Name: Adereço. Comunicação e Eventos Culturais Lda). Even If I change the comma with ; for instance the issue disappears as well (Company 2 - Name: Adereço. Comunicação e Eventos Culturais; Lda)
I guess that last comma is breaking something now.
Do you have any suggestions?
Cheers
TL