r3847: link_to_prev and link_to_next adhere to a custom sort order

wet · 2012-07-14 07:33:34

Els, I cannot reproduce this here.

I’d need your whole page template and the details of the affected articles to dig deeper. Please use this SQL query to produce the article details:

SELECT ID, Posted, unix_timestamp(Posted) as uPosted FROM textpattern ORDER BY Posted DESC

els · 2012-07-14 13:01:42

Thanks Robert, I will check again. Probably something stupid I did.

els · 2012-07-15 22:10:43

wet wrote:

SELECT ID, Posted, unix_timestamp(Posted) as uPosted FROM textpattern ORDER BY Posted DESC

Probably a dumb question, but do I just place this in <txp:php> tags and put it in the article form?

Gocom · 2012-07-15 22:37:34

You can run it via SSH (which you can skip if it’s not a remote server) and MySQL CMD interface. E.g.

$ ssh domain.tld
$ mysql --user="yourUsername" --password="yourPassword" yourDatabasename
mysql> $ SELECT ID, Posted, unix_timestamp(Posted) as uPosted FROM textpattern ORDER BY Posted DESC;

This would give you:

+-----+---------------------+------------+
| ID  | Posted              | uPosted    |
+-----+---------------------+------------+
| 523 | 2012-06-10 00:03:01 | 1339275781 |
|   2 | 2012-06-09 23:36:43 | 1339274203 |
|   1 | 2012-06-08 02:18:23 | 1339111103 |
| 406 | 2012-04-25 20:11:50 | 1335373910 |

You could also use tools like phpMyAdmin or rah_terminal.

Last edited by Gocom (2012-07-15 22:45:27)

els · 2012-07-15 22:44:10

Ah thank you, Jukka. I don’t quite get why Robert needs all articles’ details for this? I found that actually link_to_prev/next are not linking to the current article like I said before, but in fact don’t output anything at all. Tried it again with today’s nightly (well, yesterday’s) but it didn’t change.

Gocom · 2012-07-15 22:48:56

Els wrote:

I don’t quite get why Robert needs all articles’ details for this?

To reproduce the behavior and to see if there is potential issue with sorting. I would be asking for the same thing. What Robert asks doesn’t reveal anything confidential about your site if are worried about that, just timestamps and IDs.

Last edited by Gocom (2012-07-15 22:49:54)

els · 2012-07-15 23:06:23

Got it :) Thanks again.

wet · 2012-07-16 09:54:09

Els, please try r3966. It might fix this bug.

els · 2012-07-16 14:33:07

That was quick :) I’m at work now, but will try as soon as I get home. Thanks!

els · 2012-07-16 17:53:41

Yes, fixed :) Thanks again!

feragnoli · 2012-10-04 17:03:05

hello,

is it possible to restrict the sorting to only articles in the same category, ordered by date?
something like:

<txp:article sort=“This article’s Category1, Posted desc” />

<txp:if_individual_article>
<txp:link_to_next><txp:next_title/></txp:link_to_next>
<txp:link_to_prev><txp:prev_title/></txp:link_to_prev>
</txp:if_individual_article>

thank you

wet · 2012-10-05 07:09:41

No.

The sort category is taken from the page URL, as are section and author. The pros and cons of this decision were discussed here.

Textpattern CMS

Textpattern CMS support forum

#13 2012-07-14 07:33:34

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#14 2012-07-14 13:01:42

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#15 2012-07-15 22:10:43

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#16 2012-07-15 22:37:34

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#17 2012-07-15 22:44:10

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#18 2012-07-15 22:48:56

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#19 2012-07-15 23:06:23

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#20 2012-07-16 09:54:09

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#21 2012-07-16 14:33:07

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#22 2012-07-16 17:53:41

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#23 2012-10-04 17:03:05

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

#24 2012-10-05 07:09:41

Re: r3847: link_to_prev and link_to_next adhere to a custom sort order

Board footer