Error upgrading to 3.2.1 , can't login

Moderator: crythias

Locked
PointPubMedia
Znuny newbie
Posts: 18
Joined: 21 Oct 2010, 21:02
Znuny Version: 3.1.0
Company: PointPub Media Communications

Error upgrading to 3.2.1 , can't login

Post by PointPubMedia »

Hi,

I just try to upgrade from 3.1.7 -> 3.2.1. Everything runs fine. Except I can't login to the interface.

After some search I found in my apache error log file:

Wed Feb 13 13:08:59 2013] -e: DBD::mysql::db do failed: Unknown column 'session_value' in 'field list' at /opt/otrs//Kernel/System/DB.pm line 478.
ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Wed Feb 13 13:08:59 2013

Message: Unknown column 'session_value' in 'field list', SQL: 'INSERT INTO sessions (session_id, session_value) VALUES (?, ?)'

Traceback (26586):
Module: Kernel::System::AuthSession::DB::CreateSessionID (v1.50) Line: 226
Module: Kernel::System::AuthSession::CreateSessionID (v1.46) Line: 186
Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 296
Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46
Module: (eval) (v1.94) Line: 204
Module: ModPerl::RegistryCooker::run (v1.94) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.94) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

[Wed Feb 13 13:08:59 2013] -e: Odd number of elements in anonymous hash at /opt/otrs//Kernel/System/Web/InterfaceAgent.pm line 354.


Sounds like something is not up to date....

Any idea?

thanks
OTRS 3.2.9
OS: Debian Linux, MySql 5.1.x
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Error upgrading to 3.2.1 , can't login

Post by jojo »

the SQL upgrade or the replament of some files was not successfully
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
PointPubMedia
Znuny newbie
Posts: 18
Joined: 21 Oct 2010, 21:02
Znuny Version: 3.1.0
Company: PointPub Media Communications

Re: Error upgrading to 3.2.1 , can't login

Post by PointPubMedia »

I untar the package at all and only copy some config file as the UPGRADE document said and I got no error when I upgrade the database using the script...
OTRS 3.2.9
OS: Debian Linux, MySql 5.1.x
Locked