Update Problem with JUser Plugin and Password Reset field

[ckcoj]

I have run into a problem after converting from Joomla 3.10.12/Fabrik 3.10 to Joomla 4.4.2/Fabrik 4.0Zeta/PHP 8.1.18. This problem does NOT occur in J3/F3.

Problem:
When I create a new member record, then try to update that member, I get the following error:

Debug/Error Message: Incorrect integer value: '' for column `u271733241_joomla_dev1`.`ckcoj1_users`.`requireReset` at row 1
User Message: CANNOT SAVE THE USER INFORMATION

If I do any one of the things below, I can make the error go away and successfully update the member record.

- update the member.password_reset field to '0' via SQL
- modify the Member form juser plugin and set the 'Password Reset field' to 'Please select'
- logout and then login

Configuration Information:

Table: member

Columns:
id int(11) AI PK
date_time datetime
userid int(11)
first_name varchar(255)
last_name varchar(255)
full_name text
email varchar(255)
password varchar(255)
email_confirm varchar(255)
block varchar(255)
password_reset varchar(255)
...other fields omitted

Form: Member - Plugin: JUser
Fields:
Name field: full_name
Username field: email
Password field: password
Email field: email
Block field: block
User ID field: userid
User group field: [not set]
Password Reset field: password_reset

 

[troester]

Is your J!3 running with php7?

One issue is that your password_reset element is varchar; #_users has tinyint (with default 0).
Your element should at least have a default=0.

The other issue is that such settings are not correctly catched in jusers.
Password reset was added at some point but not doesn't check all options like 'block' does.
We'll have to fix it.

 

[ckcoj]

Yes the J!3 is running with PHP 7.4.33

Yes, I noticed that data type difference.

Yes, adding a default of 0 for that element, then adding the new member also worked.

I will probably add the default and do a sql update of the existing values to zero.

I am also contemplating just dropping that field. We do not use it at this point.

Thanks!

 

[troester]

Yes the J!3 is running with PHP 7.4.33

So the difference is the old
in php7 ''==0, in php8 it's not"
and we have to chase them