Forums / Cotonti / General / [4 admin cotonti] User pages / User posts at Cotonti.com

# Alex300 : Here working Bug Fix:

Find the SQL near line 34 in userlatestposts.php and replace it with:

$totalitems = sed_sql_result(sed_sql_query("SELECT COUNT(*) FROM $db_forum_posts WHERE fp_posterid=".$urr['user_id']), 0, 0);

Find the SQL near line 51 in userlatestposts.php and replace it with:

$sqluserlatestposts = sed_sql_query("SELECT p.fp_id, p.fp_updated, t.ft_title, t.ft_id, s.fs_id, s.fs_title, s.fs_category
		 FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s
		 WHERE fp_posterid='".$urr['user_id']."'
		 AND p.fp_topicid=t.ft_id
		 AND p.fp_sectionid=s.fs_id
		 GROUP BY t.ft_id
		 ORDER BY fp_updated DESC
		 LIMIT $df, ".$cfg['plugin']['userlatestposts']['countonpage']);

The same query is used in userlatestposts.ajax.php. Change it too.

Enjoy :)

Thanks a lot for your help, but this too does not fix it. Pressing the "last page" button of the pagination still shows "none" instead.

Added 38 days later:

Any updates on this? it does not really matter wether the person has 100000 posts or just 20, navigating to the last few pages of his posts (using this plugin) will result in no posts being displayed at all.