Need help with Sledmore's ASE.

[Tando]

Hello. I'm using sledmore's ASE for RevCMS, but I ran into a problem today when trying to ban a user from my Hotel.
I get the error: "Field 'id' doesn't have a default value" on the bottom of my page. The same happens when trying to give someone a badge.
Thanks in advance!

 

[ying]

Means exactly what it says.. a query is running whereby you need to set a value for ID as in your database ID doesnt have a default value....

 

[Hindi]

Hello. I'm using sledmore's ASE for RevCMS, but I ran into a problem today when trying to ban a user from my Hotel.
I get the error: "Field 'id' doesn't have a default value" on the bottom of my page. The same happens when trying to give someone a badge.
Thanks in advance!

Go to Users table, Open in design view and add a default value to the field "id". Easy as.

 

[Tando]

Go to Users table, Open in design view and add a default value to the field "id". Easy as.

Default value is? (null) ?

 

[Tranquilizer]

Default value is? (null) ?

You probably want to set it as an Auto Increment.