Welcome Guest, Not a member yet? Register   Sign In
Redux Auth Sample application - I get "Column 'group_id' cannot be null" error on register form submission
#1

[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?
#2

[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 Smile




Theme © iAndrew 2016 - Forum software by © MyBB