Codeigniter error session DB

Question

After upgrade Codeigniter to version 3.0 I get error DB after trying call any controller:

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id` = 'd1d384b0ceed0bd72fa210337acc666aab1a04e5'' at line 2

SELECT `data` WHERE `id` = 'd1d384b0ceed0bd72fa210337acc666aab1a04e5'

Filename: libraries/Session/drivers/Session_database_driver.php

When I reload page, I get that again with a other generated hash session. How to fix?

In config.php I set session store: $config['sess_driver'] = 'database';

I looked at file where is a error(line 138):

public function read($session_id)
    {
        if ($this->_get_lock($session_id) !== FALSE)
        {
            // Needed by write() to detect session_regenerate_id() calls
            $this->_session_id = $session_id;

            $this->_db
                ->select('data')
                ->from($this->_config['save_path'])
                ->where('id', $session_id);

            if ($this->_config['match_ip'])
            {
                $this->_db->where('ip_address', $_SERVER['REMOTE_ADDR']);
            }

            if (($result = $this->_db->get()->row()) === NULL) // Line 138
            {
                $this->_fingerprint = md5('');
                return '';
            }

            $this->_fingerprint = md5(rtrim($result->data));
            $this->_row_exists = TRUE;
            return $result->data;
        }

        $this->_fingerprint = md5('');
        return '';
    }

the correct syntax is SELECT column FROM tablename WHERE id=blah you are missing FROM tableName — Mihai
– Mihai, Commented Nov 16, 2014 at 18:38
I understand, that sinta incorect, but how to fix? I downloaded this fork: github.com/bcit-ci/CodeIgniter/tree/feature/session — Danil
– Danil, Commented Nov 16, 2014 at 18:40

Kenneth Vaughn · Accepted Answer · 2015-01-26 16:48:59Z

27

I had this same problem and it took me a while to find the solution. On the surface, the instructions tell you to just load the session driver and everything is cool, but if you look down in the Database Driver section of the CodeIgniter documentation, you find that you need to configure the $config[‘sess_save_path’] variable in your config.php file. For example:

 $config[‘sess_save_path’] = ‘ci_sessions’

http://www.codeigniter.com/userguide3/libraries/sessions.html#initializing-a-session

Of course, you have to have the ci_sessions table set up in your database as well, but this solved the missing table name for me.

answered Jan 26, 2015 at 16:48

Kenneth Vaughn

4355 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

CMPS · Accepted Answer · 2015-04-05 16:46:02Z

11

With codeigniter 3.0 :

In config file :

$config['sess_driver'] = 'database';
$config['sess_save_path'] = 'ci_sessions';

And in your MySQL database :

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`));

The name of the fields is different from the version 2.0

edited Apr 5, 2015 at 16:46

CMPS

7,7874 gold badges32 silver badges53 bronze badges

answered Apr 5, 2015 at 16:36

shugyo

1111 silver badge4 bronze badges

1 Comment

wrivas Over a year ago

The official documentation missing to say put the table name in the config.php

Cristiana Chavez · Accepted Answer · 2015-11-26 07:33:53Z

Using Codeigniter Version 3

Edit the Config File and set session driver to "database" and sess_save_path to table name

$config['sess_driver'] = 'database';//enable session with db
$config['sess_cookie_name'] = 'ci_session';
$config['sess_expiration'] = 7200;
$config['sess_save_path'] = 'ci_sessions';//database table name
$config['sess_match_ip'] = FALSE;
$config['sess_time_to_update'] = 300;
$config['sess_regenerate_destroy'] = FALSE;

For MySql

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,
        KEY `ci_sessions_timestamp` (`timestamp`)
);

For PostgreSQL:

    CREATE TABLE "ci_sessions" (
            "id" varchar(40) NOT NULL,
            "ip_address" varchar(45) NOT NULL,
            "timestamp" bigint DEFAULT 0 NOT NULL,
            "data" text DEFAULT '' NOT NULL
    );

CREATE INDEX "ci_sessions_timestamp" ON "ci_sessions" ("timestamp");

Official Codeigniter Documentation for Session database driver

Gabriel Glauber · Accepted Answer · 2015-08-30 19:12:31Z

2

I use the CI 3 and just alter:

$config['sess_save_path']           = 'ci_sessions';

Works.. =)

answered Aug 30, 2015 at 19:12

Gabriel Glauber

95611 silver badges9 bronze badges

Comments

Jimey1000 · Accepted Answer · 2014-11-27 16:26:37Z

0

SELECT 'data' FROM TABLE_NAME WHERE 'id' = 'd1d384b0ceed0bd72fa210337acc666aab1a04e5'

you are missing the tablename plus your code include special characters.

answered Nov 27, 2014 at 16:26

Jimey1000

991 gold badge1 silver badge8 bronze badges

Collectives™ on Stack Overflow

Codeigniter error session DB

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related