[rt-users] rt3 - DBD::mysql::st execute failed: Table 'rt3.session' doesn't exist

[CULPEPPER, ALLEN (SBIS)]

Hello all,

I go the below error after installing rt-3.0.7.01 from the webpage. I saw no
problems with the install except having to go through and manually having to
install alot of perl modules that for some reason the dependency script
wouldnt install. Has anyone seen this error? There is a table called
"sessions" in mysql but no "session". I pasted the DBI.pm module below also.
If anyone could help with this it would be much appreciated, I am getting
frustrated.


Thanks,
Allen



sub insert {
        my $self    = shift;
                my $session = shift;

                         $self->connection($session);

                                 local $self->{dbh}->{RaiseError} = 1;

                                         if (!defined $self->{insert_sth}) {
                                                         $self->{insert_sth}
=
                                                         #
$self->{dbh}->prepare_cached(qq{
                                                         #
INSERT INTO sessions (id, a_session) VALUES (?,?)});
 
$self->{dbh}->prepare_cached(qq{
 
INSERT INTO session (sess_id,sess_var,sess_expire) VALUES
(?,?,current_timestamp(0))});

 
}

 
$self->{insert_sth}->bind_param(1, $session->{data}->{_session_id});
 
$self->{insert_sth}->bind_param(2, $session->{serialized});
 

 
$self->{insert_sth}->execute;

 
$self->{insert_sth}->finish;
 
}


 
$self->connection($session);

 
local $self->{dbh}->{RaiseError} = 1;

 
if (!defined $self->{insert_sth}) {
 
$self->{insert_sth} =
 
#            $self->{dbh}->prepare_cached(qq{
 
#                INSERT INTO sessions (id, a_session) VALUES (?,?)});
 
$self->{dbh}->prepare_cached(qq{
 
INSERT INTO session (sess_id,sess_var,sess_expire) VALUES
(?,?,current_timestamp(0))});

 
}

 
$self->{insert_sth}->bind_param(1, $session->{data}->{_session_id});
 
$self->{insert_sth}->bind_param(2, $session->{serialized});

 
$self->{insert_sth}->execute;		#Line 45

 
$self->{insert_sth}->finish;
 
}


System error

error: 	 DBD::mysql::st execute failed: Table 'rt3.session' doesn't exist at
/opt/SBCperl58-mthread/lib/site_perl/5.8.0/Apache/Session/Store/DBI.pm line
45.
	
context: 	 ... 	 	
277: 	 }	 
278: 	 	
279: 	 # All errors returned from this routine will be in exception form.

280: 	 local $SIG{'__DIE__'} = sub {	 
281: 	 rethrow_exception( $_[0] );	 
282: 	 };	 
283: 	 	
284: 	 #	 
285: 	 # $m is a dynamically scoped global containing this	 
... 	 	
code stack:
/opt/SBCperl58-mthread/lib/site_perl/5.8.0/HTML/Mason/Request.pm:281
/opt/SBCperl58-mthread/lib/site_perl/5.8.0/Apache/Session/Store/DBI.pm:45
/opt/SBCperl58-mthread/lib/site_perl/5.8.0/Apache/Session.pm:515
/opt/SBCperl58-mthread/lib/site_perl/5.8.0/Apache/Session.pm:462
/opt/SBCperl58-mthread/lib/site_perl/5.8.0/HTML/Mason/Request.pm:1049
/opt/rt3/share/html/autohandler:51