Welcome Guest, Not a member yet? Register   Sign In
flexi auth - A user authentication library for CodeIgniter

[eluser]taztwister[/eluser]
@haseydesign

I did go through the instillation guide. I am not sure why the forgotten password token field is set to be NOT NULL but in the insert query the library runs it doesn't specify a forgotten password token value. So the insert query will fail.

Code I am executing
Code:
$result = $this->flexi_auth->insert_user($email, $username, $password, false, 1, false);
Query run by library from insert_user command
Code:
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]',
'testuser',
'$2a$08$AyMGTHv4Vq/rJ84V.KBMJuVTRNETI0Gb4dxbYhyNDpGaQ.RcfXnpa',
'192.168.1.197',
'2013-03-06 13:03:24',
'2013-03-06 13:03:24',
'9d6daf8b40382ba9bc4438e980eaa2f00b9852b9',
  0,
  0,
'YdtZJYNvf5')

SQL Script provided by the library that pertains to this field
Code:
DROP TABLE IF EXISTS `user_accounts`;
CREATE TABLE `user_accounts` (
  `uacc_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uacc_group_fk` smallint(5) unsigned NOT NULL,
  `uacc_email` varchar(100) NOT NULL,
  `uacc_username` varchar(15) NOT NULL,
  `uacc_password` varchar(60) NOT NULL,
  `uacc_ip_address` varchar(40) NOT NULL,
  `uacc_salt` varchar(40) NOT NULL,
  `uacc_activation_token` varchar(40) NOT NULL,
  `uacc_forgotten_password_token` varchar(40) NOT NULL,
  ....


Messages In This Thread
flexi auth - A user authentication library for CodeIgniter - by El Forum - 03-06-2013, 12:13 PM



Theme © iAndrew 2016 - Forum software by © MyBB