Log Error

[jfreeman2nc]

I was looking through the log file and found this error occurring frequently, I was just wondering if someone could explain what could be causing this error?

[Error][Kernel::System::CustomerUser::DB::CustomerName][177] Unknown column 'salutation' in 'field list', SQL: 'SELECT login , salutation, first_name, last_name FROM customer_user WHERE LOWER(login) = LOWER('Reports') LIMIT 1'

Is this saying that the error is caused due to the salutation field being empty?

Thanks in advance for your help!

[giga0069]

Hi jfreeman2nc,

the field salutation was renamed to title. Have a look in the UPGRADING document:

16) Customer Database Backend Field Renaming
----------------------------------------

The field 'salutation' in the built-in customer database has been renamed to
the more appropriate 'title'. If you are using the built-in database data
source for customers, and you have changed the configuration, for instance
because you've added fields to the customer table, or because you've enabled
Customer Company support, you should change the mapping in your Kernel/Config.pm:

Change this line:

[ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var', '', 0 ],

to:

[ 'UserTitle', 'Title', 'title', 1, 0, 'var', '', 0 ],

Please note that this can also affect any salutations or other templates
where you've used the string <OTRS_*_UserSalutation>. If you have used this
string AND you use the built-in customer table, please replace it with
<OTRS_CURRENT_UserTitle> instead.

giga0069

[jfreeman2nc]

Looking at my Config.pm, I do not have 'UserSalutation' mapped:

Code: Select all

 Map => [
            # note: Login, Email and CustomerID needed!
            # var, frontend, storage, shown, required, storage-type, http-link
            #[ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var' ],
            [ 'UserFirstname', 'Firstname', 'first_name', 1, 1, 'var' ],
            [ 'UserLastname', 'Lastname', 'last_name', 1, 1, 'var' ],
            [ 'UserLogin', 'Login', 'login', 1, 1, 'var' ],
            [ 'UserPassword', 'Password', 'pw', 0, 1, 'var' ],
            [ 'UserEmail', 'Email', 'email', 0, 1, 'var' ],
            [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var' ],
            [ 'UserComment', 'Comment', 'comments', 1, 0, 'var' ],
            [ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int' ],
        ],

I do however see the following in the Config.pm

Code: Select all

# customer uniq id
        CustomerKey => 'login',
        CustomerID => 'customer_id',
        CustomerValid => 'valid_id',
        CustomerUserListFields => ['first_name', 'last_name', 'email'],
#       CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email'],
        CustomerUserSearchFields => ['login', 'last_name', 'customer_id'],
        CustomerUserSearchPrefix => '',
        CustomerUserSearchSuffix => '*',
        CustomerUserSearchListLimit => 250,
        CustomerUserPostMasterSearchFields => ['email'],
        CustomerUserNameFields => ['salutation', 'first_name', 'last_name'],

It looks like the error in the log is coming more from this part of the code, just not sure why. We do not really use salutations, so it is not a big issue that I have seen, it just really fills up the log.

Thanks

[renee]

If you don't use it, remove it from

Code: Select all

CustomerUserNameFields => ['salutation', 'first_name', 'last_name'],

So this should be

Code: Select all

CustomerUserNameFields => ['first_name', 'last_name'],

This mapping is used in the method CustomerName in Kernel::System::CustomerUser::(DB|LDAP). And the result of this method is used for example in the ticket overview.