ditto ordeBy menu index

1,024 Posts

Frank Reply #1, 16 years, 5 months ago

Hi,

I am trying to order published docs residing in a container, by menu index.
On a trial page where ditto is creating output for the codaslider this seems to work fine, difference, no FURL on that page.
On the site where it all should happen, it does not order by that menuindex. On that page FURL is active. Both pages run Ditto 2.1 both on Modx 1.0.2.
Here is the call, very simple:

[!Ditto? &startID=`[*id*]`   &orderBy=`menuindex DESC` &tpl=`contentTpl` &debug=`1`!]

Debug shows this

Basic Info
Version 	2.1.0
Summarize 	7
Total 	7
Start 	0
Stop 	7
IDs 	3, 4, 5, 6, 7, 8, 9
Sort By	Sort Direction
menuindex	DESC

And this is the indexes page ID s used vs output order>

page 1 id 3 index 1 output place 1
page 2 id 4 index 3 output place 2
page 3 id 6 index 4 output place 4
page 4 id 5 index 5 output place 3
page 5 id 7 index 6 output place 5
page 6 id 8 index 7 output place 6
page 7 id 9 index 8 output place 7

So it seems the pages are indexed by their ID s rather than the menuindex.
Why would that be?

Thanks, Frank.

☆ A M B ☆
24,524 Posts

sottwell Reply #2, 16 years, 5 months ago

I’m not sure if it would cause it to fail, but there appear to be three spaces between the &startID parameter and the &orderBy parameter.

By the way, the &startID parameter should be &parents, and isn’t necessary anyway as the current document is the default.

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org

1,024 Posts

Frank Reply #3, 16 years, 5 months ago

Thanks,

the white space is not the issue, I am very puzzled. Page now shows some more strange behaviour (Jquery things) Maybe it is all related. If you feel like it, see for yourself, the third slider on this page is sliding back to slide #2?

http://www.amersfoort-kinderopvang.nl/over_eigenwijs.html

I will first put in all that content, and start disabling scripts, see what the cause can be.

thanks, Frank.

MODX Staff
10,725 Posts

opengeek Reply #4, 16 years, 5 months ago

Are you running any flavor MySQL server version 5.0.51 by chance? It’s horribly broken and the queries required to produce the ordered list you want don’t work because of the bugs in that version of MySQL server.

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

1,024 Posts

Frank Reply #5, 16 years, 5 months ago

I am not running anything, can t afford to run my own webserver, my hosting company is running Mysql 5.0.51a-community so probably not the right version. I allready asked this host (and its a big one in holland) to change version to be able to run Revolution. It however feels like the story of Mozes and the mountain. Anyway I will convince the website owner of the problem of the sorting, and they will have to buy it. And lets hope that one day my host will update,

thanks, Frank.