• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Session database not working, using cookies does

#1
[eluser]RJ[/eluser]
Hello,

I can't figure out why CI is not loading the default session cookie. Below is from my error log.

Quote:DEBUG - 2009-05-12 17:54:25 --> Database Driver Class Initialized
DEBUG - 2009-05-12 17:54:25 --> Session Class Initialized
DEBUG - 2009-05-12 17:54:25 --> Helper loaded: string_helper
DEBUG - 2009-05-12 17:54:25 --> Encrypt Class Initialized

// ERROR
DEBUG - 2009-05-12 17:54:25 --> A session cookie was not found.
DEBUG - 2009-05-12 17:54:25 --> DB Transaction Failure
ERROR - 2009-05-12 17:54:25 --> Query error: Field 'user_data' doesn't have a default value
DEBUG - 2009-05-12 17:54:25 --> Language file loaded: language/english/db_lang.php

Here is my onscreen error:
Quote:Error Number: 1364

Field 'user_data' doesn't have a default value

INSERT INTO `fw_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('d3dd4efd8ee68a6218696b66aaf9fa86', '173.15.201.122', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1;', 1242136465)

I did recently switch to using database rather than cookies, and worked fine until this error appeared. any ideas why? the field "user_data" is not specified by me... NOTE: system works without database enabled now.


Messages In This Thread
Session database not working, using cookies does - by El Forum - 05-12-2009, 10:12 AM
Session database not working, using cookies does - by El Forum - 05-12-2009, 11:18 AM
Session database not working, using cookies does - by El Forum - 05-12-2009, 11:31 AM
Session database not working, using cookies does - by El Forum - 05-12-2009, 11:38 AM
Session database not working, using cookies does - by El Forum - 05-12-2009, 12:35 PM
Session database not working, using cookies does - by El Forum - 05-12-2009, 01:01 PM
Session database not working, using cookies does - by El Forum - 05-12-2009, 01:16 PM
Session database not working, using cookies does - by El Forum - 05-12-2009, 01:51 PM
Session database not working, using cookies does - by El Forum - 05-12-2009, 02:15 PM
Session database not working, using cookies does - by El Forum - 05-12-2009, 02:21 PM
Session database not working, using cookies does - by El Forum - 05-12-2009, 02:23 PM
Session database not working, using cookies does - by El Forum - 09-07-2009, 06:59 AM
Session database not working, using cookies does - by El Forum - 09-07-2009, 12:00 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.