FixSometime Issue with databasejoin Element Saving 0 Instead of NULL After Joomla and Fabrik Update

[szotstihamer]

Hi everyone,

I’m facing an issue after updating Joomla to version 5.1.4 and Fabrik (Database version: 4.2-2024-05-25, Manifest version: 4.3.1) to the latest compatible version. Specifically, I have databasejoin elements linked to table fields, which used to save NULL values correctly when the fields were left empty. However, after the update, they are now saving 0 instead of NULL.

Here’s what I’ve checked so far:

• The database schema still shows DEFAULT NULL for the databasejoin fields.
• Fabrik’s field settings do not have a default value of 0 set.
• There are no triggers or custom SQL queries that might be altering the values.
• I’ve reviewed custom PHP code and eval fields that interact with this element, but I haven’t found anything that might be causing this issue.
• The issue persists across different scenarios, indicating it’s not tied to specific form submissions.

Has anyone experienced a similar issue, or could you provide insights on what might be causing this behavior? Any suggestions on how to ensure NULL values are correctly saved would be greatly appreciated.

Thanks in advance!

Update: I have temporarily reverted back the databasejoin.php file to previous version. This fixed the issue, but hope that null values will handled correctly in future versions of Fabrik.