Lots of repeating Apache log errors in 3.1.6

[Kilstapeter]

I reviewed the OTRS\Apache\logs\error.log and found loads of the following error:

[Mon Jun 25 10:24:56 2012] -e: DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'salutation'. (SQL-42S22) [state was 42S22 now 42000]
[Mon Jun 25 10:24:56 2012] -e: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000) at C:/PROGRA~2/OTRS/OTRS//Kernel/System/DB.pm line 618.
ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Mon Jun 25 10:24:56 2012

Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'salutation'. (SQL-42S22) [state was 42S22 now 42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000), SQL: 'SELECT salutation, first_name, last_name, login, pw, email, customer_id, comments, valid_id, login FROM customer_user WHERE LOWER(login) = LOWER('Mnm')'

Traceback (3448):
Module: Kernel::System::CustomerUser::DB::CustomerUserDataGet (v1.88.2.1) Line: 491
Module: Kernel::System::CustomerUser::CustomerUserDataGet (v1.63) Line: 294
Module: Kernel::System::Ticket::TicketAcl (v1.549.2.6) Line: 6307
Module: Kernel::System::Ticket::TicketMoveList (v1.549.2.6) Line: 1654
Module: Kernel::System::Ticket::MoveList (v1.549.2.6) Line: 7733
Module: Kernel::Output::HTML::TicketMenuMove::Run (v1.2) Line: 76
Module: Kernel::Output::HTML::TicketOverviewSmall::Run (v1.52) Line: 204
Module: Kernel::Output::HTML::LayoutTicket::TicketListShow (v1.141.2.1) Line: 930
Module: Kernel::Modules::AgentTicketLockedView::Run (v1.16) Line: 209
Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868
Module: ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_20_28x86_29_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 49
Module: (eval) (v1.90) Line: 204
Module: ModPerl::RegistryCooker::run (v1.90) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

The only thing that changes in the errors are the username, in this case Mnm.
Ideas anyone? We did not see this error in 3.1.5.

/Peter

[crythias]

Check your CustomerUser Map in config.pm
Module: Kernel::System::CustomerUser::DB::CustomerUserDataGet (v1.88.2.1) Line: 491

You are referencing a salutation in your Map in Config.pm. In 3.0+, it has been renamed to 'title'
http://bugs.otrs.org/show_bug.cgi?id=939

[Kilstapeter]

Hmm.. is it in the following code? (marked with bold text)
Could I just comment the line with #?

# CustomerUser
# (customer user database backend and settings)
$Self->{CustomerUser} = {
Name => 'Datenbank',
Module => 'Kernel::System::CustomerUser::DB',
Params => { Table => 'customer_user',
# to use an external database
# DSN => 'DBI:odbc:yourdsn',
# DSN => 'DBI:mysql:database=customerdb;host=customerdbhost',
# User => '', Password => '',
},
# 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'],
# ReadOnly => 1,
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' ],
],
};

# CustomerUser1
# (customer user ldap backend and settings)
$Self->{CustomerUser1} = {
Module => 'Kernel::System::CustomerUser::LDAP',
Params => {
# ldap host
Host => 'xxxxxxxx',
# ldap base dn
BaseDN => 'ou=xxxx, ou=xxxxx, dc=xxxxx, dc=xxxx',
# search scope (one|sub)
SSCOPE => 'sub',
# The following is valid but would only be necessary if the
# anonymous user does NOT have permission to read from the LDAP tree
UserDN => 'cn=otrs_ldap, ou=xxxxxx, ou=xxxx, ou=xxxx, dc=xxxx, dc=com',
UserPw => '',
AlwaysFilter => '',
SourceCharset => 'utf-8',
DestCharset => 'utf-8',
},
# customer uniq id
CustomerKey => 'sAMAccountName',
# customer #
CustomerID => 'mail',
CustomerUserListFields => ['sAMAccountName', 'cn', 'mail'],
CustomerUserSearchFields => ['sAMAccountName', 'cn', 'mail'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['mail'],
CustomerUserNameFields => ['givenname', 'sn'],
Map => [
# note: Login, Email and CustomerID needed!
# var, frontend, storage, shown, required, storage-type
#[ 'UserSalutation', 'Title', 'title', 1, 0, 'var' ],
[ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var' ],
[ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var' ],
[ 'UserLogin', 'Login', 'sAMAccountName', 1, 1, 'var' ],
[ 'UserEmail', 'Email', 'mail', 1, 1, 'var' ],
[ 'UserCustomerID', 'CustomerID', 'mail', 0, 1, 'var' ],
[ 'UserPhone', 'Phone', 'telephonenumber', 1, 0, 'var' ],
#[ 'UserAddress', 'Address', 'postaladdress', 1, 0, 'var' ],
#[ 'UserComment', 'Comment', 'description', 1, 0, 'var' ],
],
};

[Kilstapeter]

It's solved now!
First I commented out [ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var' ], but that was not enough.
Changing CustomerUserNameFields => ['salutation', 'first_name', 'last_name'], to CustomerUserNameFields => ['title', 'first_name', 'last_name'], did the trick.

/Peter