SpringSecurityLoginTutorial icon indicating copy to clipboard operation
SpringSecurityLoginTutorial copied to clipboard

Published 20 hours ago • verified publisher icon gustavoponce7

Error: Column 'role_id' cannot be null

Open apmihal opened this issue 7 years ago • 1 comments

After filling in valid user registration info on the registration page, and pressing "Register User" I get a whitelabel error page with this error message: (type=Internal Server Error, status=500)

Looking at the console output I see this error message: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'role_id' cannot be null

apmihal avatar Dec 06 '17 22:12 apmihal

I solved the problem. It seems like insert_roles.sql didn't execute, so I just ran it's containing sql query itself in my database software and it worked.

Does anyone know how to get it to execute off the bat?

apmihal avatar Dec 06 '17 23:12 apmihal