EE version 1.6.4 build 20080626
After upgrading from 1.5.2 to 1.6.4 I found that the next/previous links didn’t work properly.
In my case the posts were created in random order then the entry date was changed to put them in the right order.
Example: for entry id 64 the following query will look for next entry.
SELECT t.entry_id, t.title, t.url_title
FROM (exp_weblog_titles AS t)
LEFT JOIN exp_weblogs AS w ON w.weblog_id = t.weblog_id
WHERE t.entry_id != 64 AND t.entry_date < 1215636832 AND t.entry_date >=1168633682
AND t.entry_id > 64 AND (t.expiration_date = 0 OR t.expiration_date > 1215636832)
AND w.is_user_blog = 'n' AND w.site_id IN ('1') AND w.blog_name = 'plains' AND t.status != 'closed' AND t.status = 'open'
ORDER BY t.entry_date ASC, t.entry_id ASC LIMIT 1
One condition is entry_id > 64. In my case the next entry is 63 because they were initially entered in random order so the query will not return the expected result.
Is this the intended behavior or is a bug?
Thanks,
Gabriela
