New CI 1.7 session class database error

[eluser]Randy Casburn[/eluser]
Hi,

1) When you re-created your table without 'NOT NULL' that fixed your DB problem.
-- Please do not be worried about this as your application will be fine and no harm will be done
2)

I was under the impression that these session variables would only be in the ci_sessions table, not in the cookie.

The values are stored in both places.

If you're interested in the specifics, open the libraries/sessions.php file. At line 298 you'll find the sess_create() method. In this method $this->user_data is defined. The last statement in the method is a call to $this->set_cookie(). That method is at line 634. In the set_cookie() method $cookie_data is assgined the value of $this->user_data. Then, the $cookie_data is written to the cookie.

That's what takes place.
---

So the bottom line is this: You've solved your problem but perhaps discovered an unexpected result along the way.

Hope this is has all been helpful.

Randy