×
Kunena 5.1 RC 3 Released (16 Feb 2018)

The Kunena team is proud to announce the arrival of Kunena 5.1.0 RC3 [K 5.1.0] which is now available for download as a native Joomla extension for J! 3.8.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1. This is a RC release.

× Topics that are moved into this category are considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Solved User post statistic not correct

More
3 years 3 weeks ago - 3 years 3 weeks ago #1 by tlweb
tlweb created the topic: User post statistic not correct
Hi,

My users total posts statistic is way off (almost double).

According to statistics i should have total of 24237 posts (while in #_kunena_messages total of 24265 rows in db tho)

When i do a quick export of the #_kunena_users table and count the total of column "posts" it is 47526.

This is after i used the forum tool "update statistics" to recount the user stats.

Any takes on this?

Kind regards,
Tom


This message contains confidential information

Database collation check: The collation of your table fields are correct

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 96M | Max file upload: 32M

Kunena menu details:

Warning: Spoiler! [ Click to expand ]

Joomla default template details : ja_playmag | author: JoomlArt.com | version: 1.1.1 | creationdate: Unknown

Kunena default template details : Ja PlayMag | author: JoomlArt.com | version: 1.1.1 | creationdate: Oct 31 2014

Kunena version detailed: Kunena 3.0.6 | 2014-07-28 [ Tala ]
| Kunena detailed configuration:

Warning: Spoiler! [ Click to expand ]
| Kunena integration settings:
Warning: Spoiler! [ Click to expand ]
| Joomla! detailed language files installed:
Warning: Spoiler! [ Click to expand ]

Third-party components: UddeIM 3.5

Third-party SEF components: None

Plugins: Search - Kunena Search 3.0.1 | Content - Kunena Discuss 3.0.1

Modules: Kunena Latest 3.0.1 | Kunena Stats 3.0.1 | Kunena Login 3.0.1 | Kunena Search 3.0.1

Last Edit: 3 years 3 weeks ago by 810.
The topic has been locked.
More
3 years 3 weeks ago #2 by 810
810 replied the topic: User post statistic not correct
This can be, because empty posts will be ignored.

Your feedback on the JED helps us improve Kunena!
The topic has been locked.
More
3 years 3 weeks ago #3 by tlweb
tlweb replied the topic: User post statistic not correct
Aha. ok that counts for the discrepancy of 50. But how about the almost 24K difference in user posts totals?
The topic has been locked.
More
3 years 3 weeks ago #4 by 810
810 replied the topic: User post statistic not correct
#_kunena_users are users not messages

Your feedback on the JED helps us improve Kunena!
The topic has been locked.
More
3 years 3 weeks ago #5 by tlweb
tlweb replied the topic: User post statistic not correct
The messages discrepancy was just a side note.

The problem is with the user statistic in the profile and in the user details next to the posts.

The post count there is way off. Even after i do a recount statistics.

I checked the database table kunena_users as that is where that statistic is stored:



I summed up all the fields in that column and it totalled 47526. While only 24237 messages were ever written.
Attachments:
The topic has been locked.
More
3 years 3 weeks ago #6 by 810
810 replied the topic: User post statistic not correct
Yes that's wrong.

go to administrator/index.php?option=com_kunena&view=tools&layout=diagnostics

and fix the errors, if there are any. Then do user sync, then do category recount

Your feedback on the JED helps us improve Kunena!
The following user(s) said Thank You: tlweb
The topic has been locked.
More
3 years 3 weeks ago - 3 years 3 weeks ago #7 by tlweb
tlweb replied the topic: User post statistic not correct
WOW Very handy URL! :D nice.

Indeed several issues came up. Two i was able to fix. One displays:

MovedAndMessages TEST MISLUKT 15 problemen

No details about what topics are giving these issues. Do you know how to find out more about this?
Last Edit: 3 years 3 weeks ago by tlweb.
The topic has been locked.
More
3 years 3 weeks ago #8 by 810
810 replied the topic: User post statistic not correct
er zijn problemen in de #__kunena_messages_text of #__kunena_messages

zoek eens naar moved_id


de probleem is, er zijn topics zonder berichten

Your feedback on the JED helps us improve Kunena!
The topic has been locked.
More
3 years 3 weeks ago #9 by 810
810 replied the topic: User post statistic not correct
heb je een migratie gedaan of update

Your feedback on the JED helps us improve Kunena!
The topic has been locked.
More
3 years 3 weeks ago #10 by tlweb
tlweb replied the topic: User post statistic not correct
Migratie van XMB forums maar heb je migrator ontslagen want ze bakte er niks van. Oke lege topics ga ik op zoek in de DB. Ik zag inderdaad zo'n 30 lege berichten al.

Bedankt voor de hulp!!!

Thanks!
The topic has been locked.
  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.133 seconds