• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Anotehr Session issue with 2.03

#1
[eluser]DougW[/eluser]
I use 2 databases. One is the default database (pndb) and one is called www1. These are defined as:

$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = '';
$db['default']['password'] = '';
$db['default']['database'] = 'pnet';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'latin1_swedish_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

$db['pndb']['hostname'] = 'localhost';
$db['pndb']['username'] = '';
$db['pndb']['password'] = '';
$db['pndb']['database'] = 'www1';
$db['pndb']['dbdriver'] = 'mysql';
$db['pndb']['dbprefix'] = '';
$db['pndb']['pconnect'] = TRUE;
$db['pndb']['db_debug'] = TRUE;
$db['pndb']['cache_on'] = FALSE;
$db['pndb']['cachedir'] = '';
$db['pndb']['char_set'] = 'utf8';
$db['pndb']['dbcollat'] = 'latin1_swedish_ci';
$db['pndb']['swap_pre'] = '';
$db['pndb']['autoinit'] = TRUE;
$db['pndb']['stricton'] = FALSE;

In my connection model constructor, I define them like this:

// Call the Model constructor
parent::__construct();
$this->db = $this->load->database('default', TRUE);
$this->pndb = $this->load->database('pndb', TRUE);

What happens is that I connect to pndb to align user data. After logging in, I set session variables. But I get this error...

Table 'www1.CI_sessions' doesn't exist

Filename: libraries/Session.php

But CI_sessions does exit in the other, default database, not www1. Session.php references $this-db which should point to the default, not the one I defined as pndb.

My question is , why does $this->db suddenly point to the incorrect database? If I had just referenced $this->pndb (as in my example) and then the system tries to update the database, would it assume the current database?


FIXED: This only happens when you use the same user to connect to both databases. When I created a separate user for the second database, it started working again. Is this a CI bug?


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.