[eluser]Unknown[/eluser]
Im working in a application and Im using sessions (cookie).
My config.php is set as:
Code:
$config['sess_cookie_name'] = 'ci_session';
$config['sess_expiration'] = 7200;
$config['sess_encrypt_cookie'] = FALSE;
$config['sess_use_database'] = FALSE;
$config['sess_table_name'] = 'ci_sessions';
$config['sess_match_ip'] = FALSE;
$config['sess_match_useragent'] = TRUE;
$config['sess_time_to_update'] = 300;
Work well in localhost but when I put in a server host, a get this message when i try login:
Code:
A Database Error Occurred
Error Number: 1146
Table 'mysite.ci_sessions' doesn't exist
SELECT * FROM (`ci_sessions`) WHERE `session_id` = '5e98b394130f87a3eee8888c9b299a' AND `user_agent` = 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) Ap'
Why does CI try save data to database?
In my controller I put this:
Code:
if(count($login)>0){
$newdata = array(
'user_name' => $login[0]->name,
'user' => $data['user'],
'loggedin' => TRUE
);
$this->load->library('session');
$this->session->set_userdata($newdata);
redirect(base_url().'mypage', 'refresh');
}else{
$this->index();
}
Anyone can help me?
Thanks...