Question Error with stats

Hello !!


I need help to repear my forum.

Recently I have noticed that the counter of my forum are all to zero. only new topics are counted. (May be because of the update to kunena 1.5.6)



I have tried to use the "recount cathegory stats" button but it is not working (after 1 minute, only a blank page with these 3 chars  are loaded.)

How can I fix this?

Hello,

Do you have tried this thing : www.kunena.com/forum/139-solved-or-prior...ecount-problem#30484

I have tried this followed queries

the first is correctly working.
the querry :

INSERT INTO jos_fb_categories (id, numTopics, numPosts)
SELECT m.catid, SUM( m.parent=0 ), SUM( m.parent>0 )
FROM jos_fb_messages as m
LEFT JOIN jos_fb_categories AS c ON c.id=m.catid
WHERE m.catid >0 AND m.hold=0
GROUP BY catid
ON DUPLICATE KEY UPDATE numTopics=VALUES(numTopics), numPosts=VALUES(numPosts);

have 3 errors :
"field description doesnt have a default value"
"field headerdesc doesnt have a default value"
and
"field class_sfx doesnt have a default value"

and the querry :

INSERT INTO jos_fb_categories (id, numTopics, numPosts)
SELECT parent, SUM( numTopics ), SUM( numPosts )
FROM jos_fb_categories
WHERE parent > 0
GROUP BY parent
ON DUPLICATE KEY UPDATE numTopics=VALUES(numTopics), numPosts=VALUES(numPosts);

have 3 errors :
"field description doesnt have a default value"
"field headerdesc doesnt have a default value"
and
"field class_sfx doesnt have a default value"

Help !

You seem to have orphan messages (with deleted category). I didn't expect that in my queries..

What do you want to do with those messages?