I found a fix, in the end it was a table error of some kind.
I can't remember specifics at the moment as I am not home but will place a step by step later. Basically you need to change the table type via phpadmin to isql or something like that and then repair the table. Make sure you copy the php users table first so you don't loose any data.