Support (offered by community volunteers) > Using Core CiviCRM Functions

DB Error on create dedupes rules

(1/2) > >>

p.gervaix:
hi , I have this db error when i create i new dedupes rules:

ERROR:

DB Error: no such field
Error Details
Database Error Code: Unknown column 'civicrm_dedupe_rule_group.title' in 'where clause', 1054
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

   
--- Code: --- => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_dedupe_rule_group
 
 WHERE (  civicrm_dedupe_rule_group.title  = 'NameEmail' ) 
 
 
 
 [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  = 'NameEmail' ) 
 
 
 
 [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  = 'NameEmail' ) 
 
 
 
 [nativecode=1054 ** Unknown column 'civicrm_dedupe_rule_group.title' in 'where clause']"]
)


Thx for the Help
--- End code ---

ehanuise:
Same problem here.
When I check the table in the DB I see no 'title' column, but several title columns for the languages
title_fr_FR title_nl_NL title_en_GB

So my uneducated guess is the code that managed the dedupe rules somehow missed the fact that this is a multilingual install.

I filed a bug report
http://issues.civicrm.org/jira/browse/CRM-10423

Donald Lobo:

seems like that table was switched to multi-lingual by someone in release X

at a later release they realized they did not need it and switched it back. However the code base was unchanged

I'm not sure what happened and why and dont know an easy fix either

On a different but related note, I'd very much like to see a group of consultants / developers / users who depend on multi-lingual significantly to help manage, maintain and improve the multi-lingual stuff. Any chance u'd be interested in playing a lead role / be part of the team

lobo

ehanuise:
Can't play a lead role, but I sure can report what I see, and maybe contribute to some testing.
In belgium multilingual is the norm (Fr + Nl) so it helps :)

ehanuise:
Can't it be reverted to multilingual for the time being ?
As is it's not possible to edit/add any dedupe rules, making the dedupe 'default or nothing'.
(Can edit some parameters in mysql, but...  ::)  ;D )

Navigation

[0] Message Index

[#] Next page