Juser form plugin dont work - id' doesn't have a default value

[mvilela]

Xampp, PHP 8.2.0, joomla 4.28k, fabrik_4.0gamma2, template Cassiopeia

When I try to register a new user I get an error message -

UNABLE TO SAVE USER INFORMATION

'Field 'id' does not have a default value

 

[troester]

In your registration list:
Is the id element type "internalid", set as PK and autoincrement in list settings (should be automatically if the list was created via Fabrik)?
Is the id element not used for storing the user id (i.e. id is not your "id use?r")

 

[mvilela]

Currently on the page https://www.asespedal.net/gest2017/ I have the Juser plugin working perfectly in Joomla! 3.10.
In the test I'm carrying out in Joomla 4, if I deactivate the Juser plugin, the form works perfectly both in new and in changes to records.
id= internal id
id_user = Field reserved for Joomla id_user.

 

[troester]

Strange. I can't replicate.
The error is coming from the user object, so "Field 'id' " seems to referr to J! #_users table.
What is the column definition of #_users.id? (Should also be integer, autoincrement)

Is your J!4 site an updated copy? Is the Fabrik connection pointing to the new J! database? (open and re-save)

 

[mvilela]

What is the column definition of #_users.id? (Should also be integer, autoincrement)

Autoincrement was not active in joomla table. Sorted out. Thanks