CiviCRM Community Forums (archive)

Hi,

I'm getting a database error every time I want to update or create a dedupe rule.

Eg.

Database Error Code: Unknown column 'civicrm_dedupe_rule_group.title' in 'where clause', 1054
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_dedupe_rule_group
 
 WHERE (  civicrm_dedupe_rule_group.title  = 'Individual - External ID' ) 
 
 [nativecode=1054 ** Unknown column 'civicrm_dedupe_rule_group.title' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_dedupe_rule_group
 
 WHERE (  civicrm_dedupe_rule_group.title  = 'Individual - External ID' ) 
 
 [nativecode=1054 ** Unknown column 'civicrm_dedupe_rule_group.title' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_dedupe_rule_group
 
 WHERE (  civicrm_dedupe_rule_group.title  = 'Individual - External ID' ) 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_dedupe_rule_group.title' in 'where clause']"]
)
[/size]

The problem is presumably related to the fact that it's an install with support for multiple languages. Enabling support for multiple languages modifies the database scheme. Hence the error: the field 'title' no longer exists in the table civicrm_dedupe_rule_group table.

Any suggestions on how this can be solved?

Thanks.

hi lobo,

thanks for the quick response.

here is the backtrace:

backTrace

/var/www/example/public_html/civicrm-4.1.1/CRM/Core/Error.php, backtrace, 159
, handle,
/var/www/example/public_html/civicrm-4.1.1/packages/PEAR.php, call_user_func, 931
/var/www/example/public_html/civicrm-4.1.1/packages/DB.php, PEAR_Error, 968
/var/www/example/public_html/civicrm-4.1.1/packages/PEAR.php, DB_Error, 564
/var/www/example/public_html/civicrm-4.1.1/packages/DB/common.php, raiseError, 1903
/var/www/example/public_html/civicrm-4.1.1/packages/DB/mysql.php, raiseError, 898
/var/www/example/public_html/civicrm-4.1.1/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/example/public_html/civicrm-4.1.1/packages/DB/common.php, simpleQuery, 1216
/var/www/example/public_html/civicrm-4.1.1/packages/DB/DataObject.php, query, 2428
/var/www/example/public_html/civicrm-4.1.1/packages/DB/DataObject.php, _query, 442
/var/www/example/public_html/civicrm-4.1.1/CRM/Core/DAO.php, find, 510
/var/www/example/public_html/civicrm-4.1.1/CRM/Utils/Rule.php, objectExists, 491
, objectExists,
/var/www/example/public_html/civicrm-4.1.1/packages/HTML/QuickForm/Rule/Callback.php, call_user_func, 77
/var/www/example/public_html/civicrm-4.1.1/packages/HTML/QuickForm/RuleRegistry.php, validate, 158
/var/www/example/public_html/civicrm-4.1.1/packages/HTML/QuickForm.php, validate, 1582
/var/www/example/public_html/civicrm-4.1.1/CRM/Core/Form.php, validate, 308
/var/www/example/public_html/civicrm-4.1.1/CRM/Core/StateMachine.php, validate, 149
/var/www/example/public_html/civicrm-4.1.1/CRM/Core/QuickForm/Action/Next.php, perform, 64
/var/www/example/public_html/civicrm-4.1.1/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/example/public_html/civicrm-4.1.1/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/example/public_html/civicrm-4.1.1/CRM/Core/Controller.php, handle, 284
/var/www/example/public_html/civicrm-4.1.1/CRM/Core/Page/Basic.php, run, 353
/var/www/example/public_html/civicrm-4.1.1/CRM/Contact/Page/DedupeRules.php, edit, 144
/var/www/example/public_html/civicrm-4.1.1/CRM/Core/Invoke.php, run, 227
/var/www/example/public_html/civicrm-4.1.1/drupal/civicrm.module, invoke, 454
, civicrm_invoke,
/var/www/example/public_html/includes/menu.inc, call_user_func_array, 517
/var/www/example/public_html/index.php, menu_execute_active_handler, 21

I don't see any views, just a table civicrm_dedupe_rule_group with the following fields: id, contact_type, threshold, level, is_default, name, title_en_US, title_nl_NL, title_fr_FR and is_reserved.

This is unlike other tables with support for multiple languages who seem to have a view for each language supported. E.g. in my install civicrm_contact_type has 3 views civicrm_contact_type_en_US, civicrm_contact_type_nl_NL and civicrm_contact_type_fr_FR.

The database is not modified beyond the modifications by civicrm code when support for multiple languages was enabled. I think support for multiple languages was enabled when the install was at version 4.0.7 or 4.0.8. The current version is 4.1.1.

thanks,

c.

hi lobo,

sorry for the late response. i manually restored the table structure as suggested and can confirm it works.

thanks for your help,

c.