Why were the defautl values not set in the database as they are with the other params

@brianteeman maybe i don't understand your comment but afaik i did add them.

See here:

Why were the defautl values not set in the database as they are with the other params

@brianteeman In fact they were added to the SQL with PR #43974 .

But the options are missing the "symbol" value.

@TLWebdesign Not sure if we need an update SQL to fix that in database. but we should at least fix base.sql so it is right from the beginning on for new installations.
Update: I think we will not need a new update SQL for fixing it in the database on updated sites. For those the missing value in the options in database will cause the default value being used in PHP. But in base.sql it should be right.

I have tested this item ✅ successfully on 7a1db96

It still needs a little improvement. Currently, there is no space between the number and the currency symbol. And yes, the database value for the currency symbol is missing.
The fix resolves the error for the user. If you can submit the fix for the DB at short notice, I'll be happy to renew my test again.

Hi all the SQL is changed.

@LadySolveig not adding a space is intentional as some currencies don't use spaces in between so now you get to choose to add a space or not.

Thanks for the explanation, that's fine for me. 👍🏼 An override can be done at any time if someone wants a space between.

they don't need to do an override. they can just type a space after the symbol and then there is a space in between the symbol and the number.

But the options are missing the "symbol" value.

Thats what I meant

But the options are missing the "symbol" value.

Thats what I meant

Yes thank you i overlooked that until richard pointed it out. i fixed it now :D thanks for noticing. Still much to learn.

But the options are missing the "symbol" value.

Thats what I meant

@brianteeman For new installations it has been fixed meanwhile in the base.sql. I think it does not need a new update SQL for updated sites. FOr these we still have the right PHP default.

I have tested this item ✅ successfully on cb652ce

Tested 9319e04 successfully.

@lemuelvdm Please mark your test result in the issue tracker here https://issues.joomla.org/tracker/joomla-cms/46433 by using the blue "Test this" button at the top left corner, selecting your test result and finally submit, so the test is properly counted. Thanks in advance.

I have tested this item ✅ successfully on cb652ce

Tested Successfully. 9319e04ad Fix works as expected.

RTC

Thanks for the fix @TLWebdesign and to @LadySolveig & @lemuelvdm for testing at short notice!