Element Plugin - User - Hidden - does not save

[nbradshaw]

When Element Plugin - User -> Hidden using ID - the form does not save. This does work when showing on form on save.

Error: Incorrect integer value: '' for column 'created_by' at row 1

 

[troester]

See https://fabrikar.com/forums/index.p...integer-value-for-column-user-at-row-1.53649/

Still trying to replicate.

 

[nbradshaw]

This is how to reproduce:
There is no issue on NEW record/row.

This issue is when user element db value = NULL on EDIT record.

Attaching some screenshots of the element settings - hopefully that is helpful.

 

[troester]

Can you try?
in \plugins\fabrik_element\user\user.php
change line 189
$layoutData->value = is_a($user, 'User') ? $user->get('id') : '';
to
$layoutData->value = is_a($user, 'User') ? $user->get('id') : 0;

 

[nbradshaw]

Made the change - it will now update the db value to = 0 on save.

 

[troester]

ok, yes, it was already fixed (https://github.com/joomlahenk/fabrik/wiki/Changelog, I was testing with the updated code)

change line 188/189
$layoutData->readOnly = is_a($user, 'Joomla\CMS\User\User') ? $user->get($displayParam) : '';
$layoutData->value = is_a($user, 'Joomla\CMS\User\User') ? $user->get('id') : '';

and line 1008
return is_a($user, 'Joomla\CMS\User\User') ? $user->get($displayParam) : false;

 

[nbradshaw]

Thanks! BTW - how do I update to the most recent files (so I make sure that I am not reporting something that has already been fixed?

I see this here (however, I don't see a url): https://github.com/joomlahenk/fabrik/wiki/Testing-a-fix: Alternatively, you can install the cumulative update zip from our download server. A link to this file will be included in the changelog wiki.