CiviCRM Community Forums (archive)

I'm trying to import a list of organisations into the system, and get an error as follow :
(sorry for the bad format, the error page wouldn't even display and came in a 'save as' dialog.)

Error Details
Database Error Code: Unknown column 'functions_and_services_12' in 'field list', 1054
Additional Details:
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_XXXX_org_custom_data_3  ( org_type_16,functions_and_services_12,entity_id ) VALUES ( 'Institution','école de théatre',1473 ) ON DUPLICATE KEY UPDATE org_type_16 = 'Institution',functions_and_services_12 = 'école de théatre' [nativecode=1054 ** Unknown column 'functions_and_services_12' in 'field list']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_XXXX_org_custom_data_3  ( org_type_16,functions_and_services_12,entity_id ) VALUES ( 'Institution','école de théatre',1473 ) ON DUPLICATE KEY UPDATE org_type_16 = 'Institution',functions_and_services_12 = 'école de théatre' [nativecode=1054 ** Unknown column 'functions_and_services_12' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_smarteu_org_custom_data_3  ( org_type_16,functions_and_services_12,entity_id ) VALUES ( 'Institution','école de théatre',1473 ) ON DUPLICATE KEY UPDATE org_type_16 = 'Institution',functions_and_services_12 = 'école de théatre' [nativecode=1054 ** Unknown column 'functions_and_services_12' in 'field list']"]
)
(CiviCRM 3.3.5 on Drupal 6.2)

On a side note, to make sure it wasn't a schema corruption/upgrade problem, I tried to drop all civicrm tables, recreate them using the civicrm.mysql from the crm/sql folder on the server, then reimporting my data as advised here : http://wiki.civicrm.org/confluence/display/CRMDOC33/Ensuring+Schema+Integrity+on+Upgrades.

 However this doesn't work and I had to restore the original tables : there are several localised tables (_FR, _NL, _EN ) and fields in our data. The data import tries to import data in the localised fields or tables, which don't exist in the restored 3.3.5 core schema and the import fails.

That costom field exists and is used.
I'll try to scrap it and recreate it, thanks for the tip 

OK, I nailed it...
"Database field length" should not exceed 255 characters, as it's a mysql 'varchar', limited to 255 char until mysql 5.0.3
I have mysql 5.0.77, but still it seems to be an issue.
I'll recreate the field using more conservative values, or a 'note' type.

Thanks for the tip !