Thanks. I had noted that issue in #26067 (comment)

I have a problem in PhpMyadmin to apply the Insert from the update sql:
It says
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 17, 20, 0, '*', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00')' at line 1

The error comes from the fact that the params column is missing an empty value by using ''
'class:messages', 0, , 17, 20, 0,
should be
'class:messages', 0, '', 17, 20, 0,

same for postgres update

Once corrected, and I don't know if it is my version of PHPMyadmin or not, I still have an error:
#1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'checked_out_time' at row 1

for the datetime issue for postgresql the defualt date time is not 0000-00-00 00:00:00' but 1970-01-01 00:00:00 for mysql phpmyadmin depending on your mysql version and setting the correct datetime should be '1000-01-01 00:00:00' see https://dev.mysql.com/doc/refman/8.0/en/datetime.html for more info

@alikon
You are damned right. Issue with update is solved here using '1000-01-01 00:00:00'
My sql version is Server version: 5.7.25 - MySQL Community

Shall not we correct this all over our sqls? Including joomla.sql ?

No we don't need in joomla for now at least for mysql < 8, cause we are setting the no sql strict mode

should be ok now. it was late when I did this and it sadly was pretty sloppy

my only concern is about the lft,rgt values as the #__menu is one of the nested tables,
but take my comment like as someone reading only the code in hurry , (ie without proof) :smile

i was concerned too. didnt seem to have a negative impact and i dont know how to fix it without changing all records

The system test errors reported by drone seem valid to me but are unrelated to this PR

Drone relaunched

Thanks!

Thanks