Can't login to customer interface after 3.2.2 installation

Moderator: crythias

Locked
eduardogdom
Znuny newbie
Posts: 5
Joined: 12 Nov 2012, 18:46
Znuny Version: 3.2.2

Can't login to customer interface after 3.2.2 installation

Post by eduardogdom »

Hello,

I've installed otrs 3.1.11 for testing purposes and now I'm trying to upgrade to the 3.2.2 version. As the old database was full of test data, I've drop it and executed the installer.pl again to create a new one from scratch.

Apparently the Agent interface is working fine, but when I try to use the Customer interface, the system returns an 'Invalid Session' error. Log shows the following:

Code: Select all

[Thu Feb 21 15:24:53 2013] -e: DBD::mysql::db do failed: Incorrect string value: '\x80\x00\x00\x00\x08C...' for column 'data_value' at row 1 at C:/otrs//Kernel/System/DB.pm line 478.
ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Thu Feb 21 15:24:53 2013

 Message: Incorrect string value: '\x80\x00\x00\x00\x08C...' for column 'data_value' at row 1, SQL: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES (?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?),(?,?,?,?)'

 RemoteAddress: 
 RequestURI: /otrs/customer.pl

 Traceback (4700): 
   Module: Kernel::System::AuthSession::DB::CreateSessionID (v1.72) Line: 333
   Module: Kernel::System::AuthSession::CreateSessionID (v1.53) Line: 177
   Module: Kernel::System::Web::InterfaceCustomer::Run (v1.72) Line: 282
   Module: ModPerl::ROOT::ModPerl::Registry::C_3a_otrs_bin_cgi_2dbin_customer_2epl::handler (unknown version) Line: 46
   Module: (eval) (v1.48) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.48) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.48) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31
Any ideas?

Thanks.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Can't login to customer interface after 3.2.2 installati

Post by crythias »

OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
eduardogdom
Znuny newbie
Posts: 5
Joined: 12 Nov 2012, 18:46
Znuny Version: 3.2.2

Re: Can't login to customer interface after 3.2.2 installati

Post by eduardogdom »

Thanks, solved!
Locked