Welcome Guest, Not a member yet? Register   Sign In
ci_session database problem
#1

Hello,
I want to save session data into my database
my database is MySQL:
Code:
CREATE TABLE IF NOT EXISTS `ci_sessions` (
        `id` varchar(40) NOT NULL,
        `ip_address` varchar(45) NOT NULL,
        `timestamp` int(10) unsigned DEFAULT 0 NOT NULL,
        `data` blob NOT NULL,
        PRIMARY KEY (id),
        KEY `ci_sessions_timestamp` (`timestamp`)
);
I have autoload session and database but I get:
Quote:Error Number: 1064

Erreur de syntaxe près de 'WHERE `id` = 'deeb1593af2f5d5d311ef6442cfa684736c8e554'' à la ligne 2

SELECT `data` WHERE `id` = 'deeb1593af2f5d5d311ef6442cfa684736c8e554'

Filename: libraries/Session/drivers/Session_database_driver.php

Line Number: 160

I use CI3
Reply
#2

Hello,
Check you are using database session driver and your name for the database is 'ci_sessions' (name your are given when you created your table)
PHP Code:
$config['sess_driver'] = 'database';
$config['sess_save_path'] = 'ci_sessions' // config.php file 
Reply
#3

I did these jobs
(05-02-2015, 12:45 AM)casa Wrote: Hello,
Check you are using database session driver and your name for the database is 'ci_sessions' (name your are given when you created your table)
PHP Code:
$config['sess_driver'] = 'database';
$config['sess_save_path'] = 'ci_sessions' // config.php file 
Reply
#4

Another thing, perhaps, have you this in your configuration :
PHP Code:
$autoload['drivers'] = array('session');
$autoload['libraries'] = array('database',...) ; 
Can you show your configuration or the portion of code that causes the error please ?
Reply
#5

config.php
PHP Code:
$config['sess_driver'] = 'database';
$config['sess_cookie_name'] = 'ci_sessions';
$config['sess_expiration'] = 7200;
$config['sess_save_path'] = NULL;
$config['sess_match_ip'] = FALSE;
$config['sess_time_to_update'] = 300;
$config['sess_regenerate_destroy'] = FALSE

autoload.php
PHP Code:
$autoload['libraries'] = array(
    
'database',
    
'session',
    
'form_validation',
    
'ion_auth',
    
'jdate');
$autoload['drivers'] = array('session'); 
Reply
#6

(05-02-2015, 01:58 AM)Hamed Wrote: I did these jobs

(05-02-2015, 12:45 AM)casa Wrote: Hello,
Check you are using database session driver and your name for the database is 'ci_sessions' (name your are given when you created your table)

PHP Code:
$config['sess_driver'] = 'database';
$config['sess_save_path'] = 'ci_sessions' // config.php file 

No, you didn't. Your 'sess_save_path' is NULL.
Reply
#7

Thanks,fixed
But last_activity and user_agent is empty why?
Reply




Theme © iAndrew 2016 - Forum software by © MyBB