danger Incorrect integer value: '' for column `xxxxx`.`xxxx`.`requireReset` at row 1

[ossi]

hi,

i have a fresh J5.0.2 installation with newest Fabrik version. First I s was setting up the must have fields for the user list followed by binding them to the fields in the joomla user account.

I was able to synchronise the super user to the Fabrik User List. I even created new users in the joomla backend via the Fabrik List and it synchronised to the joomla user table. once I open a user profile via the Fabrik list again and try to save, no matter if I change anything or not. it gives me the failure:

CANNOT SAVE THE USER INFORMATION
Incorrect integer value: '' for column `uxxxxxxx_V78To`.`123_users`.`requireReset` at row 1


Auto Increment on the List is switched off

do: juser
in: both
on: both

Sync:

Sync PK: yes
Delete Users: yes
Auto Login: yes:
Sync on edit: yes

all others: no

Can you please help?

 

[trob2]

Which type is your element holding the user_id?
For dbjoin set "Please select" value to 0.

 

[ossi]

thanks for the sugestion.
userid was "field" type ,
I made it a databasejoin
please select = 0

Data:
Table = joomla_users
Value = id (Recommended)
Label = id

deleted all user records from Fabrik and synchronised again.
was able to add one user but after editing thi suser same error occurs

 

[ossi]

I found what the problem caused. When editing a existing record I needed to fill in the password again.
Just need now to see how I can avoid this behavior.

any idea?

 

[ossi]

also this one solved. Password reset wasnt set to yes/no. now all works