ckcoj
New Member
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
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