CiviCRM Community Forums (archive)

Hi,

I have a vanilla installation of Joomla and CiviCrm on a Windows XP, see below for the relases numbers. As soon as I try do define within the administrator console a New Individual with an accent (french é) in his first name (in my case it is rené lagrange), I get the following non-recoverable error page:

Sorry. A non-recoverable error has occurred.

Database Error Code: Data too long for column 'sort_name' at row 1, 1406

Return to CiviCRM menu.



Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

    [\code] => -1
   

[message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_contact (nick_name , domain_id , contact_type , do_not_email ,    do_not_phone , do_not_mail , external_identifier , sort_name , display_name , home_URL , preferred_communication_method , preferred_mail_format , do_not_trade , hash , source ) VALUES ( NULL ,  1 , 'Individual' ,  0 ,  0 ,  0 ,  NULL , 'lagrange, ren�' , 'ren� lagrange' ,  NULL , '' , 'Both' ,  0 , '88d9cb7d252d9bf5b802e5c64126965c' ,  NULL )  [nativecode=1406 ** Data too long for column 'sort_name' at row 1]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_contact (nick_name , domain_id , contact_type , do_not_email , do_not_phone , do_not_mail , external_identifier , sort_name , display_name , home_URL , preferred_communication_method , preferred_mail_format , do_not_trade , hash , source ) VALUES ( NULL ,  1 , 'Individual' ,  0 ,  0 ,  0 ,  NULL , 'lagrange, ren�' , 'ren� lagrange' ,  NULL , '' , 'Both' ,  0 , '88d9cb7d252d9bf5b802e5c64126965c' ,  NULL )  [nativecode=1406 ** Data too long for column 'sort_name' at row 1]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contact (nick_name , domain_id , contact_type , do_not_email , do_not_phone , do_not_mail , external_identifier , sort_name , display_name , home_URL , preferred_communication_method , preferred_mail_format , do_not_trade , hash , source ) VALUES ( NULL ,  1 , 'Individual' ,  0 ,  0 ,  0 ,  NULL , 'lagrange, ren�' , 'ren� lagrange' ,  NULL , '' , 'Both' ,  0 , '88d9cb7d252d9bf5b802e5c64126965c' ,  NULL )  [nativecode=1406 ** Data too long for column 'sort_name' at row 1]"]
)



I have tested the creation of a user in Joomla with the same accent without problem. But within CiviCrm no way to do the same. I have also tested on the demo site of CiviCrm, both Drupal and Joomla:

1) On Drupal everything works fine.
2) On Joomla I get no error page but the accentuated letter is droped: "rené" is displayed as "ren"


System information:
Database Version: 5.0.22-community-max-nt
PHP Version: 5.2.1
Web Server: Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8e mod_autoindex_color PHP/5.2.1
WebServer to PHP interface: apache2handler
Joomla! Version: Joomla! 1.0.12 Stable [ Sunfire ] 25 December 2006 01:00 UTC
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.11) Gecko/20070312 Firefox/1.5.0.11


I am a newbie with Joomla and CiviCrm, any help welcome.

Hi,

Thanks for the info. Since I am at the begining of the full setup (new to CMS's and CiviCRM), I have switched to Drupal where it seems to work great.

Regards.