Redux Auth Sample application - I get "Column 'group_id' cannot be null" error on register form submission |
[eluser]nbdr[/eluser]
The full error: A PHP Error was encountered Severity: Notice Message: Trying to get property of non-object Filename: models/redux_auth_model.php Line Number: 505 A Database Error Occurred Error Number: 1048 Column 'group_id' cannot be null INSERT INTO `users` (`username`, `password`, `email`, `group_id`, `ip_address`) VALUES ('xxxx', 'e6e80f3fbefcd72ff443b1943ff4427396c8ed5c', '[email protected]', NULL, '127.0.0.1') What am I doing wrong? Thanks! Update- I found the solution- edit the groups table manually. So now my question is - where is it written? I saw that people who asked for installation documentation for Redux Auth was sent to read the code and understand it. There must be some better instructions, where is it?
[eluser]jwindhorst[/eluser]
Let's see, assuming you are using mysql and phpMyAdmin to manage it, the default setting for a column is 'NOT NULL'. You likely need to change the table so that it will take your NULL group id from your query. In other words, as the error states, The column 'group_id' cannot be null |
Welcome Guest, Not a member yet? Register Sign In |