No Code Attached Yet
avatar brbrbr
brbrbr
10 Jun 2020

Steps to reproduce the issue

Create a new field 'sql'
add query
(SELECT id as value, title as text FROM #__categories where extension = 'com_content' and published = 1) union (SELECT 0 as value,'Empty' as text)

add valid default value, in this case existing category or 0

save

Expected result

Successful save

Actual result

Save failed with the following error: The default value is invalid.

Additional comments

avatar brbrbr brbrbr - open - 10 Jun 2020
avatar joomla-cms-bot joomla-cms-bot - change - 10 Jun 2020
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 10 Jun 2020
avatar brbrbr brbrbr - change - 10 Jun 2020
The description was changed
avatar brbrbr brbrbr - edited - 10 Jun 2020
avatar joomdonation joomdonation - change - 4 Dec 2022
Status New Closed
Closed_Date 0000-00-00 00:00:00 2022-12-04 07:15:07
Closed_By joomdonation
Labels Added: No Code Attached Yet
Removed: ?
avatar joomdonation joomdonation - close - 4 Dec 2022
avatar joomdonation
joomdonation - comment - 4 Dec 2022

PR #39355 should address this issue. Unfortunately, Joomla 3 does not receive regular bugs fixes on anymore, so we can only have this issue fixed for Joomla 4. Please help testing . Thanks !

Add a Comment

Login with GitHub to post a comment