Can’t view more than 20 posts, drafts showing up, new posts not showing

thank you for starting a new thread as your issue may not be related to the previous one.

We can only see 19 displayed on a category page. When we tried zooming out in the browser, this didn’t show all of our posts.

do you see any javascript errors in your console?

@aurovrata the issue is the initial query in Reorder_Post_Within_Categories_Admin->_get_order() is returning duplicates.

either use UNIQUE on the post_id or filter dupes with php afterwards.

SELECT rpwc_pm.post_id FROM wp_postmeta as rpwc_pm, wp_posts as rpwc_p WHERE rpwc_pm.meta_key ='_rpwc2' AND rpwc_pm.meta_value=9 AND rpwc_pm.post_id=rpwc_p.ID AND rpwc_p.post_type='article' ORDER BY rpwc_pm.meta_id;

@glovaci please start a separate thread, this WP forum policy.

@aurovrata i don’t have an issue. My reply was telling you how to fix your plugin and the error this thread is about.

@glovaci order by meta_id will return unique values. If this is not the case then please start a new thread to report your issue separately.

Duplicates could appear if the data is corrupted in which case please is the reset button to other the ranking data

@aurovrata ORDER BY will not return unique values. Are you confusing GROUP BY?

SELECT post_id FROM wp_postmeta, wp_posts WHERE 
meta_key ='_rpwc2' 
AND meta_value=9 
AND post_id=ID 
AND post_type='article' 
ORDER BY meta_id;

is equivalent to

SELECT post_id, meta_id FROM wp_postmeta, wp_posts WHERE 
meta_key ='_rpwc2' 
AND meta_value=9 
AND post_id=ID 
AND post_type='article' 

which will return unique rows unless the data has been corrupted.

@aurovrata yes, I understand that. That’s why I’m telling you to either use a unique, group by, or filter the results to ensure there are no duplicates. Because as you can see from the issues… “corrupt data” is possible

Because as you can see from the issues… “corrupt data” is possible

indeed, and the solution is not to make do with corrupt data but rather to fix the corrupt data…for which there is already a solution, reset the ranking.