Database error with Authentication library |
[eluser]anand9[/eluser]
Hi, i am new to codeigniter.. i installed Tank Auth library, but when i take my site i get an error 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 ('c05a01e2547621f2d5cdc231d9afc007', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) Ap', 1267093664) i imported the db file of Tank Auth into my db which had an existing table with 3 fields. i tried DX_auth also, but getting the same error... can some1 plz help me what this could be?
[eluser]steelaz[/eluser]
Are you developing on local machine? Most likely your MySQL is running in strict mode.
[eluser]anand9[/eluser]
Yes, i am running on my localhost... WAMP server.... can you tell me how to fix it?
[eluser]steelaz[/eluser]
http://forum.mambo-foundation.org/showthread.php?t=5254 Your my.ini should be in wamp/bin/mysql/mysqlx.x.x/
[eluser]anand9[/eluser]
Thanks bro.. it worked... i run this script from my phpmyadmin Code: SET @@global.sql_mode= ''; and it worked like a charm...
[eluser]anand9[/eluser]
hi, Code: SET @@global.sql_mode= ''; can someone please help me out?
[eluser]steelaz[/eluser]
You'll need to change it in my.ini file. See the link I posted above.
[eluser]anand9[/eluser]
unfortunately i could not find the code Code: # Set the SQL mode to strict |
Welcome Guest, Not a member yet? Register Sign In |