[#45395] - [5.3] sql postgresql valid json
- Fixed in Code Base
- 6 May 2025
- Medium
- Build: 5.3-dev
- # 45395
- Diff
- alikon:patch-20
User tests: Successful: Unsuccessful:
Pull Request for Issue #45394 .
Summary of Changes
fix json
Testing Instructions
update from 5.2.3 or lower to a current Joomla version with postgresql
Actual result BEFORE applying this Pull Request
invalid json
Expected result AFTER applying this Pull Request
valid json
Link to documentations
Please select:
-
Documentation link for docs.joomla.org:
-
No documentation changes for docs.joomla.org needed
-
Pull Request link for manual.joomla.org:
-
No documentation changes for manual.joomla.org needed
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Category | ⇒ | Postgresql SQL Administration com_admin |
This do not fix already broken sites.
This do not fix already broken sites.
Correct.
@alikon Could you add a new update SQL script for PostgreSQL only with the right version and a suitable date, e.g. 5.3.1-2025-04-27.sql, which updates existing records with the wrong value? E.g.:
UPDATE "#__mail_templates"
SET "params" = '{"tags":["messages","message","date","extension","username"]}'
WHERE "template_id" = 'com_actionlogs.notification'
AND "params" = '"tags":["messages","message","date","extension","username"]}';
As we are only checking for the complete "params" string, we can update the complete string without using any JSON functions. IF someone has already edited that mail template, if should fixed so the WHERE clause will not match.
| Labels |
Added:
PR-5.3-dev
|
||
I have tested this item ✅ successfully on b912a2f
Update 4.4.13 to 5.3.0
Update 4.4.13/5.3.0 (broken) to this PR
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/45395.
I have tested this item ✅ successfully on b912a2f
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/45395.
| Status | Pending | ⇒ | Ready to Commit |
RTC
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/45395.
| Labels |
Added:
RTC
bug
|
||
| Status | Ready to Commit | ⇒ | Fixed in Code Base |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2025-05-06 12:07:05 |
| Closed_By | ⇒ | laoneo |
Thanks!
I have tested this item ✅ successfully on b9ffc52
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/45395.