No Code Attached Yet Information Required bug
avatar chmst
chmst
27 Mar 2025

Steps to reproduce the issue

In my case there are many modules on the same position. They are ordered manually and appear in the frontend in this order.

Image

When I open the last item for editing and save it, The ordering is broken. This item is now on place 1 (and has ordering 1 in the database.

Image

The problem occurs only for the last item in such a list.

Image

Expected result

The ordering does not change when a module is edited.

Actual result

Saving the last item in such an ordering calculates the wrong number.

System information (as much as possible)

Additional comments

avatar chmst chmst - open - 27 Mar 2025
avatar joomla-cms-bot joomla-cms-bot - change - 27 Mar 2025
Labels Added: No Code Attached Yet
avatar joomla-cms-bot joomla-cms-bot - labeled - 27 Mar 2025
avatar chmst chmst - change - 27 Mar 2025
The description was changed
avatar chmst chmst - edited - 27 Mar 2025
avatar chmst chmst - change - 27 Mar 2025
Title
[5.3] Ordering Bug in Modules
[5.2] Ordering Bug in Modules
avatar chmst chmst - edited - 27 Mar 2025
avatar fgsw
fgsw - comment - 28 Mar 2025

Duplicate of #44545.

avatar richard67
richard67 - comment - 28 Mar 2025

@chmst Which kind of DB are you using? MySQL? Or MariaDB? And which version?

avatar richard67 richard67 - change - 28 Mar 2025
Labels Added: Information Required
avatar richard67 richard67 - labeled - 28 Mar 2025
avatar richard67 richard67 - change - 28 Mar 2025
Labels Added: bug
avatar richard67 richard67 - labeled - 28 Mar 2025
avatar chmst
chmst - comment - 28 Mar 2025

online Server-Version: 10.11.11-MariaDB-0+deb12u1
localhost xampp, win11: 10.4.32-MariaDB

avatar joomdonation
joomdonation - comment - 28 Mar 2025

@chmst I figured out that the ordering feature is not reliable with MariaDB 10, see my comment on the original issue #44545 (comment)

avatar chmst chmst - change - 28 Mar 2025
Status New Closed
Closed_Date 0000-00-00 00:00:00 2025-03-28 13:46:01
Closed_By chmst
avatar chmst chmst - close - 28 Mar 2025
avatar chmst
chmst - comment - 28 Mar 2025

I thought that your PR #44545 fixes that issue for MariaDB 10.
Then I close this as duplicate.

avatar joomdonation
joomdonation - comment - 28 Mar 2025

It is actually an issue opened by someone else, not my PR. But Yes, this issue should be closed because it is a duplicate.

avatar richard67
richard67 - comment - 29 Mar 2025

@chmst Could you test the following framework PR and leave a comment there about the result? joomla-framework/database#335

Thanks in advance.

avatar richard67
richard67 - comment - 2 Apr 2025

Please test #45273 . Thanks in advance.

As 4.4 is in security fix only mode, this issue won't be fixed for Joomla 4.

Add a Comment

Login with GitHub to post a comment