User statistics - A non well formed numeric value encountered

Started by iso, February 16, 2019, 10:11:55 PM

Previous topic - Next topic

iso

Hi,

if I access the user statistic (also of a newly created user) I get this error:

Error
Art des Fehlers: General
Fehlermeldung: 8: A non well formed numeric value encountered
File: /var/www/web127/htdocs/foobar/forum/Themes/default/Profile.template.php
Line: 1410
URL der Seite die den Fehler erzeugte: https://foobar-users.de/index.php?action=profile;area=statistics;u=2349
Backtrace information
#0: smf_error_handler()
Called from /var/www/web127/htdocs/foobar/forum/Themes/default/Profile.template.php on line 1410
#1: template_statPanel()
Called from /var/www/web127/htdocs/foobar/forum/Sources/Load.php on line 2463
#2: loadSubTemplate()
Called from /var/www/web127/htdocs/foobar/forum/Sources/Subs.php on line 3279
#3: obExit()
Called from /var/www/web127/htdocs/foobar/forum/index.php on line 154

albertlast

Can you please run this query give us the feedback of the return:

SELECT
b.id_board, MAX(b.name) AS name, b.num_posts, COUNT(*) AS message_count,
CASE WHEN COUNT(*) > MAX(b.num_posts) THEN 1 ELSE COUNT(*) / MAX(b.num_posts) END * 100 AS percentage
FROM smf_messages AS m
INNER JOIN smf_boards AS b ON (b.id_board = m.id_board)
WHERE m.id_member = 2349
GROUP BY b.id_board, b.num_posts
ORDER BY percentage DESC
LIMIT 10

albertlast


iso

Hi,
return of the query:

id_board name num_posts message_count percentage
26 Forenregeln und Nutzungsbedingungen 2 1 50.0000
9 Tutorials 122 50 40.9836
6 Mod-Ecke 555 167 30.0901
7 Ankündigungen und Mitteilungen 53 15 28.3019
13 Softwareempfehlungen 122 32 26.2295
10 Admin-Ecke 9 2 22.2222
24 Informationen 6 1 16.6667
12 Mod-Archiv 1023 130 12.7077
22 Veraltete Tutorials [nur lesen] 244 29 11.8852
5 Plugins 5601 615 10.9802



fix work - thanks

Advertisement: