Archivist 1.2.4 not working as of MODX 2.5.2 Update

[sonicpunk]

In the frontend the Archivist snippet is not outputting anything and no errors are being written to the MODX error log.

[[Archivist? &target=[[*archivePageID]] &parents=[[*id]],[[*pressespiegelID]] &useFurls=0]]

[ckburnett]

Looks like the problem may be within the snippet where the sort is set in the query object, here

Commenting out that line brings output back, albeit not sorted.

Replacing that line with the following appears to work in my use case, but it would need more investigation:

$c->sortby($sortBy, $sortDir);

[ksneo]

I replaced this by
$c->sortby('FROM_UNIXTIME('.$sortBy.',"%Y")', $sortDir);
$c->sortby('FROM_UNIXTIME('.$sortBy.',"%m")',$sortDir);
$c->sortby('FROM_UNIXTIME('.$sortBy.',"%d")',$sortDir);
and in ArchivistGroupper here

[Lefthandmedia]

Does the fact that this issue is closed also mean it's fixed?

[rachelmayo]

I'm having the exact same issue, and after trying both replacements that @ckburnett and @ksneo mentioned (and yes in both php files), my archives are still not appearing. Am I missing something/is there an additional step not mentioned?

[[Archivist? 
&target=`59`
&parents=`53`
&useFurls=`0`
]]

59 = Archives page; 53 = Articles parent page

@Mark-H can you please re-open this?

[jcdm]

Hi folks. If I'm reading this correctly, the issue is actually to do with some underlying XPDO functionality which has been reported by @Mark-H and fixed by @opengeek. It's possible the issue was fixed in MODX 2.5.4 - are those still having issues running 2.5.4 and/or above?

[jcdm]

@ksneo Solution above worked for me in MODX 2.5.2. Can't vouch for higher than that at the moment. I tried a lot of alternatives but that was the one that output the correct SQL statement for the Y/M/D sort order we're looking for.

[daygon2007]

Confirmed... @ksneo solution works in ModX 2.5.2