[#45839] - Code error in libraries/src/Table/Nested.php
- Closed
- 5 Aug 2025
- Medium
- Build: 5.3.2
- # 45839
Steps to reproduce the issue
Login to backend of Joomla as Super User.
Create a new Article.
Save the newly created Article.
Upon saving, you will get a server error page.
I did find this error:
Save failed with the following error:
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 ') GROUP BY c2.id) AS c2 SET state = c2.newpublished WHERE id = c2.newI' at line 6
Expected result
A new Article will be saved.
Actual result
A php error results upon saving a new Article.
System information (as much as possible)
See this Post for my FPA results: https://forum.joomla.org/viewtopic.php?f=834&t=1019750
Additional comments
See this Post for the fix: https://forum.joomla.org/viewtopic.php?f=834&t=1019750
Votes
| Labels |
Removed:
?
|
||
joomla-cms-bot
- | Labels |
Added:
No Code Attached Yet
|
||
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.
| Labels |
Added:
bug
|
||
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.
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2025-08-05 18:57:31 |
| Closed_By | ⇒ | richard67 |
This is not Joomla, it is a 3rd party extension. Please contact the developer.