Question category recount problem, duplicated posts

Just to note, I have found that I also have duplicated users as well in jos_fb_users, perhaps this is what is causing the duplicated posts to appear?

Also I don't seem to be able to delete the duplicated entry's in phpmyadmin...?

PG Lion, I think I have a fix for you, I am no expert, but by deleting the duplicated rows in jos_fb_users I am getting getting rid of the duplicated posts,

I am running the following, you will probably find not all users are duplicated (in my case anyway). Change the x after userid to the userid of the row you want to delete,

DELETE FROM jos_fb_users WHERE userid=x LIMIT 1

Limit 1 ensures that only one row is deleted. I have 17 in my case..

Not sure about running the recount again though, got a feeling that the issue may occur again if there is something not quite right in your DB.

Got another fix here,

I use community builder so all my user details come from there. So I emptied the jos_fb_user table, ensured userid is a primary key and then synced users from the backend of Kunena, this brought all the data back with no duplicates.

All that's left now is try try and work out why the post counts are still zero ???? Anyone !?

Ok, got my post counts back by using the fix at www.kunena.com/forum/139-solved-or-prior...ecount-problem#30484

I am back in business now

rawkey wrote:

Ok, got my post counts back by using the fix at www.kunena.com/forum/139-solved-or-prior...ecount-problem#30484

This is the exact solution that started this discussion topic (see #33886)! :side:

I am delighted that this method has fixed your problem, rawkey :woohoo: The fact, however, remains that, as Matias wrote (#33995)

The fix in the forum works only in some configurations, not universally.

After that the discussion turned into some of the most bizarre, convoluted stuff that I've encountered in these forums. :blink:

Therefore, although the various methods we've discussed may not work for some people (and in the absence of any follow-up details from PG_Lion), in order to risk the dangers that continually hijacking this discussion brings I am marking this topic as solved.