Workaround Problems with the juser plugin after after upgrading Joomla to Joomla! 5.2.3

asespedal

New Member
Fabrik Version: 4.5 (GitDate: 2024-12-08
Using the Fabrik form for user registration
After upgrading Joomla to Joomla! 5.2.3, the stable system started reporting an error when users tried to update data.
CANNOT SAVE THE USER INFORMATION
Incorrect integer value: '' for column `asespeda_gest`.`aaa_users`.`requireReset` at row 1
 

Attachments

  • joomla_2.fw.png
    joomla_2.fw.png
    202 KB · Views: 40
  • joomla_1.fw.png
    joomla_1.fw.png
    68.9 KB · Views: 44
  • joomla_5.fw.png
    joomla_5.fw.png
    116.5 KB · Views: 41
  • joomla_4.fw.png
    joomla_4.fw.png
    131.6 KB · Views: 41
  • joomla_3.fw.png
    joomla_3.fw.png
    140.7 KB · Views: 43
You are getting this error because, as I see from your screenshots, in the parameter 'password Reset Field' you have the element 'teste'. Clearly, you are passing a null (empty) value while the database expects an integer value. What element is it? Also, that field is optional. If you need to set the password reset in your form configuration, then you need to have something like: 0 or 1.

Otherwise, if you don't need the password reset, you can leave it empty.
 
If you disable the "test" field, it accepts changes and stops reporting errors.
but...
With the previous version of Joomla, it did not report errors and accepted the data changes.
In new records, it works with or without the "test" field activated.
I changed the "test" field to Yes/No and updated all records in the database to "0" and it continues to report an error during the update.
 
If you disable the "test" field, it accepts changes and stops reporting errors.
but...
With the previous version of Joomla, it did not report errors and accepted the data changes.
In new records, it works with or without the "test" field activated.
I changed the "test" field to Yes/No and updated all records in the database to "0" and it continues to report an error during the update.

In my system.J 5.2.3I do not get the error during editing.I have the "password reset field" element.
Set to "yes/no".With ACL permissions set to a specific group.So the user does not see the element in their form.And during saving, I have no issues.

I get the same error as you if:Setting the password reset field element to yes/no with ACL permissions that do not allow the user to see that element, the value in the reset column (in your case, test) is "null".
If it is 0 or 1, the problem does not exist.
The update completes successfully without any error.

Even if it is "null" at the database level.But if I make the yes/no element visible to the user.The saving still goes through successfully, as it updates it with the value of yes/no.
 
Prefix changed to Workaround.
It seems there's an issue with jUser plugin and element ACLs.

@asespedal : I don't think it's related to the J!5.2.3 update. From where did you upgrade (J!, Fabrik, php)?
 
I can't say for sure. But it was from the immediately previous versions.

The issue arises with the joomla update. If I revert to the previous version Juser works.
 
Last edited:
Back
Top