×
Blue Eagle (1.5.0) for K5.1 is released (20 Jul 2018)

Please update the Kunena Blue Eagle to 1.5.0 if you use Kunena 5.1.
We made several bug fixes and improvements. Also Blue Eagle has now all the features from Crypsis.
Download: www.kunena.org/download/templates/category/blue-eagle-5

× 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 6 months ago - 3 years 6 months ago #1 by tlweb
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 6 months ago by 810.
The topic has been locked.
More
3 years 6 months ago #2 by 810
Replied by 810 on topic User post statistic not correct
This can be, because empty posts will be ignored.
The topic has been locked.
More
3 years 6 months ago #3 by tlweb
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 6 months ago #4 by 810
Replied by 810 on topic User post statistic not correct
#_kunena_users are users not messages
The topic has been locked.
More
3 years 6 months ago #5 by tlweb
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 6 months ago #6 by 810
Replied by 810 on 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
The following user(s) said Thank You: tlweb
The topic has been locked.
More
3 years 6 months ago - 3 years 6 months ago #7 by tlweb
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 6 months ago by tlweb.
The topic has been locked.
More
3 years 6 months ago #8 by 810
Replied by 810 on 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
The topic has been locked.
More
3 years 6 months ago #9 by 810
Replied by 810 on topic User post statistic not correct
heb je een migratie gedaan of update
The topic has been locked.
More
3 years 6 months ago #10 by tlweb
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.240 seconds