Thanks for the reply
Have just tried the code you gave, status is Successful, but isValid is false. Have creating tried with a few different users and varified that they have entries in the db
Could it be that my schema is wrong in my db??
I can't remember how I created it, is there a script to build this again?
My membership schema:
Code: Select all
CREATE TABLE `data`.`aspnet_users` (
`userid` varchar(40) NOT NULL,
`applicationname` varchar(255) NOT NULL,
`username` varchar(245) DEFAULT NULL,
`lastactivitydate` datetime DEFAULT NULL,
`isanonymous` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`userid`),
UNIQUE KEY `aspnet_users_username_pk` (`username`,`applicationname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `data`.`aspnet_membership` (
`userid` varchar(40) NOT NULL,
`password` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`passwordquestion` varchar(255) DEFAULT NULL,
`passwordanswer` varchar(255) DEFAULT NULL,
`comments` varchar(255) DEFAULT NULL,
`isapproved` tinyint(4) DEFAULT NULL,
`islockedout` tinyint(4) DEFAULT NULL,
`creationdate` datetime DEFAULT NULL,
`lastlogindate` datetime DEFAULT NULL,
`lastpasswordchangeddate` datetime DEFAULT NULL,
`lastlockoutdate` datetime DEFAULT NULL,
`failedpasswordattemptcount` int(11) DEFAULT NULL,
`failedpasswordattemptstart` datetime DEFAULT NULL,
`failedpasswordanswercount` int(11) DEFAULT NULL,
`failedpasswordanswerstart` datetime DEFAULT NULL,
PRIMARY KEY (`userid`),
CONSTRAINT `aspnet_membership_userid_ref` FOREIGN KEY (`userid`) REFERENCES `aspnet_users` (`userid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;