flexi auth - A user authentication library for CodeIgniter |
[eluser]senli[/eluser]
I had the similar problem. Error Number: 1364 Field 'uacc_forgotten_password_expire' doesn't have a default value INSERT INTO `user_accounts` (`user_accounts`.`uacc_group_fk`, `user_accounts`.`uacc_email`, `user_accounts`.`uacc_username`, `user_accounts`.`uacc_password`, `user_accounts`.`uacc_ip_address`, `user_accounts`.`uacc_date_last_login`, `user_accounts`.`uacc_date_added`, `user_accounts`.`uacc_activation_token`, `user_accounts`.`uacc_active`, `user_accounts`.`uacc_suspend`, `user_accounts`.`uacc_salt`) VALUES (1, '[email protected]', 's44li', '$2a$08$Y.wP8VWekaVXLHscI175qeW73G1M34/KdHpS7i5tYsDayB7r0jJaa', '127.0.0.1', '2013-03-31 23:42:42', '2013-03-31 23:42:42', 'dbc58d051aaa745b390830f97bd323e318638870', 0, 0, 'zF9NNPdCVS') Filename: C:\server\Apache Software Foundation\Apache2.2\ci\system\database\DB_driver.php Line Number: 330 ------------------------------------------------------------------------------- [quote author="haseydesign" date="1362658349"]@taztwister I'm not convinced the NOT NULL condition set in the MySQL table is the cause of the error you are getting. I use the same SQL you are using and when I insert a record, MySQL simply enters an empty string (Equivalent to '') rather than NULL and this works fine for me and other users. The NOT NULL setting is just a personal preference, if you want to allow NULL, then give it a go and see whether it solves your problem as I don't think it should affect the functionality of the library. Additionally, you could try defining MySQL to enter an empty string for the column. Code: ALTER TABLE `user_accounts` If one of these methods do work, then maybe its conflict with the MySQL version you are using - do you know what version you're on?[/quote] |
Welcome Guest, Not a member yet? Register Sign In |