DB Error on create dedupes rules

[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
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -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

[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...    )

[Donald Lobo]

For now the easiest fix is:

1. create a new column in that table called: 'title'

2. Copy the right values to that column from the title_XX_YY columns

3. You can optionally delete the other columns

For multi-lingual stuff to be improved and expanded on we definitely need a few folks to start contributing to the codebase. So would be great if you can start recruiting other folks from BE / CA other multi-lingual countries

lobo

[ehanuise]

Thanks.
I added the table and copied from the french column using this sql query :

update `civicrm_dedupe_rule_group` set title = (select title_fr_FR)

Works like a charm