Pull Request for Issue # .

Summary of Changes

Fix JSON error when updating with a PostgreSQL database and add explaining comment to update SQL script for MySQL to explain why it's different to the same value in base.sql.

Testing Instructions

For MySQL code review is sufficient.

On PostgreSQL, update from 4.4 and then check if the filter parameter of the fields plugins "textarea" and "editor" have been migrated correwctly (with "\" in the database in the filter parameter.

Create a new custom field for

Actual result BEFORE applying this Pull Request

Update succeeds on MySQL.

On PostgreSQL it fails with an yellow warning alert:

JInstaller: :install: Error SQL 22P02, 7, ERROR: invalid input syntax for type json LINE 2: ...params" = jsonb_set("params"::jsonb, '{filter}' , '"\\Joomla... ^ DETAIL: Escape sequence "\J" is invalid. CONTEXT: JSON data, line 1: "\J...

Expected result AFTER applying this Pull Request

Update still succeeds on MySQL.

Update succeeds without any warning or error on PostgreSQL.

Custom fields of types editor, text and textarea work with the "Text" filter.

Link to documentations

Please select:

• No documentation changes for docs.joomla.org needed

• No documentation changes for manual.joomla.org needed