This is not Joomla, it is a 3rd party extension. Please contact the developer.

This is not Joomla, it is a 3rd party extension. Please contact the developer.

According to @toivo https://forum.joomla.org/viewtopic.php?f=834&t=1019750#p3750671 editing Joomla's file libraries/src/Table/Nested.php solves the issue

However, this issue is caused by a genuine bug. Change the string 'newpublished' in line 1474 to 'newPublished' and the query should now work: ->set("$published = " . $this->_db->quoteName("c2.newPublished"))

Or are you saying a badly written 3rd party extension is causing that line to be interpreted incorrectly?

Thank you - I cannot reproduce the error on my applications, but woll re-check.

Thank you - I cannot reproduce the error on my applications, but will re-check.

Thanks again to you and @toivo. Interesting .. this newPublished and newpublished exists since 6 years :) and nobody noticed.

Thanks again to you and @toivo. Interesting .. this newPublished and newpublished exists since 6 years :) and nobody noticed.

and nobody else had such an easily reproducible error or can replicate this error

Something in the environment which is sensible for capitalisation

It might depend on the collation of the information_schema database. On standard installations it is _ci (case insensitive), and normally one should not change that, but maybe we have a different collation here?

Anyway, the suggested fix is right.

I'm just preparing a PR with a fix ... I've slightly modified the suggestion.

Closing as having a pull request. Please test #45848 .

@catwired If you know someone who also can reproduce the issue, e.g. from replies to your forum post, please ask them to test the pull request, too.

Thanks in advance.

I've meanwhile found some information in MySQL documentation which could be helpful to identify an environment where the issue could be reproduced, or at least explain why it cannot be reproduced for most people:

• https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html explains that it depends on the database server's OS and the "lower_case_table_names" system variable.
• https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html#sysvar_lower_case_table_names explains that system variable and under which conditions it is set to which value.

@catwired Could you report back which OS your database server is running on, and could you check and report back the value of the "lower_case_table_names" system variable? The latter can be obtained e.g. in phpMyAdmin with the SQL statement SELECT @@GLOBAL.lower_case_table_names;;