New articles are created with last possible "ordering"

[bartnikj]

Steps to reproduce the issue

In Joomla 3.6.0:

1. Go to backend
2. Create article
3. Save and close
4. List all articles using ordering

Expected result

New article is listed as first one, just like before J3.6

Actual result

New article is listed as last one, which is pretty bad if you already have 1000+ articles and need to drag and drop it from bottom to the top.

System information (as much as possible)

Joomla 3.6.0

[brianteeman]

Seems to be the same as in 3.5.1

[bartnikj]

Same as "new article is last" or "new article is first". It happened to me after upgrading from 3.5.1 to 3.6.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/11103.}

[bartnikj]

Hmmm... that's weird. I updated 5 of my J35 to J36 and two got this problem. The other 3 are just fine... The JTable->reorder code is identical so it must be something else.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/11103.}

[csthomas]

What can I see in J3.6 the ordering is reversed, please check changes in #8576.
@alikon, @rdeutz Could you check it?

The performance is better because reordering is removed and any new article is added at the end.

In short: Ordering was reversed for better performance.

But it has created problem with B/C for people that based on article ordering column.

I suggest to notice users that article ordering was reversed. May be advice to wait for 3.6.1.

IMHO J3.6.1 should add some sql update to reverse ordering of existed articles (on installation) before users will add new articles. And reverse ordering direction from ASC to DESC and from DESC to ASC in modules/category view, etc.

[brianteeman]

IMHO J3.6.1 should add some sql update to reverse ordering of existed
articles (on installation) before users will add new articles. And reverse
ordering direction from ASC to DESC and from DESC to ASC in
modules/category view, etc.

You can't do that. It will completely break any existing site that uses
ordering

[csthomas]

Hmm, Joomla 3.6 broke ordering, but done good thing for performance
and I like that change.

I see two ways:

1. Back to ordering from 3.5.1 and still have problem with performance - reverse Performance gain - new featured article #8576.
   People who has 3.6 may be not happy. It will has mess with current new articles.

2. Go forward (and maybe add some sql updates to fix old ordering)
   and explain users that new article will get last number (in column ordering) and older articles have lower numbers. And they should change order direction for modules, etc.

[alikon]

i'm not an expert of B/C , sem 2.0 etc , so not so sure if this is an issue that break some rules when upgrading to a new minor version .... for me is an improvement.

[csthomas]

@alikon
Your patch changed way of set ordering for a new article:
Before:

• new article was set as ordering=0 and all existed articles was reordering (old moved by +1 in the same category), so at the end the new article had column ordering=1

After:

• new article is set as the last one in the same category and all existed articles are NOT reordering - this is performance boost

I may wrong, please check.

[alikon]

yes correct,
but again i don't see the problem

[csthomas]

The problem is that the users may use some modules/articles view with sql order by "ordering ASC" to get the newest articles at the top of result - something like "Last published".
In Joomla 3.6 that does not work because the newest articles go down in result, after older.

[alikon]

i think is wrong to use the "field ordering" to get content sorted by a date

[csthomas]

May be but Joomla allow to sort by ordering field and now it is work in reverse order.

If ordering field is not important for Joomla 3.6
then I do not have to discuss about it because personally I do not use it.

Other example:
Line 1357:
https://github.com/joomla/joomla-cms/blob/staging/libraries/joomla/table/table.php

Users in J3.5 could set some articles to be always on the top of newest articles. (sort by ordering ASC)
Joomla 3.5 then allow to display extra article(-s) (means with set ordering=-1) to be always on the top of result.

IMHO: Some information about change order direction in ordering field should be added.

[csthomas]

I only want to mention that featured table also have ordering field which direction was reversed.

[CEWebDesign]

"add new article at top / at the end" setting in options would be great.
(I like the changes, performance + at the end)