Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived General Discussion New CI 1.7 session class database error
New CI 1.7 session class database error
  • El Forum
    Guest
  •  
#1
10-25-2008, 07:09 PM

[eluser]CIfan1000[/eluser]
Hi,
I started using the new CI 1.7 session class with database based session variable storage, and got this error:
Quote:A Database Error Occurred

Error Number: 1364

Field 'user_data' doesn't have a default value

INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('5aa4c19ec6e1b86e0401e23f3dc27508', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv', 1224982938)
I am not an experienced user/programmer but I think this is happening because the SQL query does not insert anything into the user_data field of the ci_sessions table. I looked at the design of this table and this field is set to NOT NULL so maybe it is expecting a value during an INSERT query.

Please please help. Thank you for your time and effort in advance.


Messages In This Thread
New CI 1.7 session class database error - by El Forum - 10-25-2008, 07:09 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 07:19 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 07:32 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 07:35 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 07:39 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 08:35 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 08:48 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 08:49 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 08:59 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:02 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:11 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:16 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:17 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:20 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:22 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:23 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:25 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:27 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:35 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:40 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:46 PM
New CI 1.7 session class database error - by El Forum - 10-25-2008, 09:59 PM
New CI 1.7 session class database error - by El Forum - 10-26-2008, 05:51 AM
New CI 1.7 session class database error - by El Forum - 10-26-2008, 08:54 AM
New CI 1.7 session class database error - by El Forum - 10-28-2008, 11:30 PM
New CI 1.7 session class database error - by El Forum - 10-29-2008, 07:56 AM
New CI 1.7 session class database error - by El Forum - 10-29-2008, 04:21 PM
New CI 1.7 session class database error - by El Forum - 11-11-2008, 07:24 PM
New CI 1.7 session class database error - by El Forum - 11-11-2008, 07:39 PM
New CI 1.7 session class database error - by El Forum - 11-15-2008, 10:57 PM



Theme © iAndrew 2016 - Forum software by © MyBB