# CakePHP 2: Not writing session data to database

**URL:** <https://discourse.cakephp.org/t/cakephp-2-not-writing-session-data-to-database/3057>\
**Category:** Need Help\
**Created:** [August 20, 2017, 5:56am UTC](https://discourse.cakephp.org/t/cakephp-2-not-writing-session-data-to-database/3057 "2017-08-20T05:56:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sourjya](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/sourjya/32/422_2.png) [@sourjya](https://discourse.cakephp.org/u/sourjya)\
**Post date:** [August 20, 2017, 5:56am UTC](https://discourse.cakephp.org/t/cakephp-2-not-writing-session-data-to-database/3057/1 "2017-08-20T05:56:40Z")

</div>

Is there any reason why a CakePHP 2 project won’t write session data to the database (MySQL)?

As per instructions here I’ve created a `cake_sessions` table in the DB using:

> ```
> CREATE TABLE 'cake_sessions' (
> 'id' VARCHAR(255) NOT NULL DEFAULT '',
> 'data' TEXT,
> 'expires' INT(11) DEFAULT NULL,
> PRIMARY KEY ('id')
> );
> 
> ```

I’ve also modified `core.php` to reflect the following:

> ```
> Configure::write( 'Session', [
> 'defaults' => 'database',
> // Modify Session Timeout
> 'timeout' => 1440,
> 'cookieTimeout' => 1440,
> 'checkAgent' => false,
> 'autoRegenerate' => true,
> ] );
> 
> ```

However, attempting to load pages produces session errors (failed to read session data) and no data is written to the DB.

 ![cp2-db-session-error](https://canada1.discourse-cdn.com/flex029/uploads/cakephp/original/1X/e90766bfc86dc0d7c72cc680ca233a7e916e1a6d.png)

I’ve carried out similar steps in CakePHP 3 projects and it works out of the box.

Any help here will be greatly appreciated.

---

<div class="post-metadata">

**Author:** ![sourjya](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/sourjya/32/422_2.png) [@sourjya](https://discourse.cakephp.org/u/sourjya)\
**Post date:** [August 21, 2017, 5:08am UTC](https://discourse.cakephp.org/t/cakephp-2-not-writing-session-data-to-database/3057/2 "2017-08-21T05:08:24Z")

</div>

RESOLVED. My version of Cake was 2.8 and upgrading to 2.10.1 fixed the issue. My best guess is DB Sessions wasn’t fully implemented in 2.8?

---

<div class="post-metadata">

**Author:** ![xaphalanx](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/xaphalanx/32/575_2.png) [@xaphalanx](https://discourse.cakephp.org/u/xaphalanx)\
**Post date:** [August 21, 2017, 3:50pm UTC](https://discourse.cakephp.org/t/cakephp-2-not-writing-session-data-to-database/3057/3 "2017-08-21T15:50:20Z")

</div>

Your configuration needs to indicate “database” sessions. I didn’t see that in what you posted.

---

<div class="post-metadata">

**Author:** ![sourjya](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/sourjya/32/422_2.png) [@sourjya](https://discourse.cakephp.org/u/sourjya)\
**Post date:** [August 24, 2017, 2:19am UTC](https://discourse.cakephp.org/t/cakephp-2-not-writing-session-data-to-database/3057/4 "2017-08-24T02:19:53Z")

</div>

Sorry - posted wrong code! Issue resolved anyways by upgrading to 2.10.x.