Question error in the Top 5 Most Thank You

Hello!
I have an error when I click to the more statistics link at the bottom of the forum.
The error is in the Top 5 Most Thank You's

Warning: Invalid argument supplied for foreach() in
../components/com_kunena/template/default/plugin/stats/stats.php on line 285

system notice:
500 - JDatabaseMySQL::query: 1111 - Invalid use of group function SQL=SELECT a.*,b.id,b.username AS username,COUNT(a.targetuserid) AS receivedthanks FROM `jos_kunena_thankyou` AS a LEFT JOIN jos_users AS b ON a.targetuserid=b.id GROUP BY a.targetuserid ASC ORDER BY COUNT(a.targetuserid) DESC LIMIT 0, 4

can you help me?

Hello,

Can-you put here your Kunena configuration report settings ?

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 20 seconds | Max execution memory: 80M | Max file upload: 12M

Kunena version detailled: Installed version: 1.6.0 | Build: 3620 | Version name: Spika | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	Diskusné fórum o tipovaní a stávkovaní
board_offline	0
board_ofset	0.00
offline_message	<h2>Diskusné fórum sa momentálne upravuje !</h2> <div>Skúste to prosím neskôr ...</div>
enablerss	1
enablepdf	0
threads_per_page	20
messages_per_page	7
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	1
disemoticons	0
template	default
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	200
regonly	0
changename	1
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	1
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
imageprocessor	gd2
avatarquality	65
avatarsize	100
allowimageupload	0
allowimageregupload	1
imageheight	600
imagewidth	600
imagesize	150
allowfileupload	0
allowfileregupload	0
filetypes	txt,rtf,pdf
filesize	120
showranking	1
rankimages	1
avatar_src
fb_profile
pm_component
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_username	1
userlist_posts	0
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	0
userlist_lastvisitdate	0
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	241
rules_link	www.kunena.com/
help_infb	1
help_cid	0
help_link	www.kunena.com/
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
fbsessiontimeout	1800
highlightcode	0
rss_type	recent
rss_timelimit	month
rss_limit	50
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	0
rss_word_count	100
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	50
sef	1
sefcats	1
sefutf8	0
showimgforguest	1
showfileforguest	0
pollnboptions	5
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	replyid
post_dateformat	datetime_today
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	auto
integration_login	joomla
integration_avatar	kunena
integration_profile	kunena
integration_private	none
integration_activity	auto
boxghostmessage	1
userdeletetmessage	2
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	1
showthankyou	1
showpopthankyoustats	0
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	0

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Installed (Version : 1.2.3) | Jomsocial: Disabled or not installed | UddeIm: Disabled or not installed

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Disabled | JFirePHP: Disabled or not installed | Kunena Discuss: Disabled or not installed | Kunena Search: Disabled or not installed | My Kunena Forum Menu: Disabled or not installed

Modules: Kunena Latest: Enabled (Version : 1.6.0-RC2) | Kunena Stats: Disabled or not installed | Kunena Login: Disabled or not installed

This issue is fixed in kunena 1.6.1, so i advise you to upgrade

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 20 seconds | Max execution memory: 80M | Max file upload: 12M

Joomla default template details : ja_mica | author: JoomlArt.com | version: 1.6 | creationdate: 08 May 09

Kunena version detailled: Installed version: 1.6.1 | Build: 3858 | Version name: Timu | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	Diskusné fórum o tipovaní a stávkovaní
board_offline	0
board_ofset	0.00
offline_message	<h2>Diskusné fórum sa momentálne upravuje !</h2> <div>Skúste to prosím neskôr ...</div>
enablerss	1
enablepdf	0
threads_per_page	20
messages_per_page	7
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	1
disemoticons	0
template	default
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	1
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	200
allowimageupload	0
allowimageregupload	1
imageheight	800
imagewidth	800
imagesize	150
allowfileupload	0
allowfileregupload	0
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
showranking	1
rankimages	1
avatar_src
fb_profile
pm_component
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_username	1
userlist_posts	0
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	0
userlist_lastvisitdate	0
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	241
help_infb	1
help_cid	1
showspoilertag	0
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
fbsessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	50
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	0
rss_word_count	100
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	50
sef	1
sefcats	1
sefutf8	0
showimgforguest	1
showfileforguest	0
pollnboptions	5
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	replyid
post_dateformat	datetime_today
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	joomla
integration_login	joomla
integration_avatar	kunena
integration_profile	kunena
integration_private	none
integration_activity	auto
boxghostmessage	0
userdeletetmessage	2
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	1
showthankyou	1
showpopthankyoustats	0
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	0
activity_limit	0

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Installed (Version : 1.2.3) | Jomsocial: Disabled or not installed | UddeIm: Disabled or not installed

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Disabled | JFirePHP: Disabled or not installed | Kunena Discuss: Disabled or not installed | Kunena Search: Disabled or not installed | My Kunena Forum Menu: Disabled or not installed | My Kunena Forum Posts: Disabled or not installed

Modules: Kunena Latest: Enabled (Version : 1.6.0-RC2) | Kunena Stats: Disabled or not installed | Kunena Login: Disabled or not installed

So, the issue still happens with K1.6.1 ?

No, this error is not resolved.

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 20 seconds | Max execution memory: 80M | Max file upload: 12M

Joomla default template details : ja_mica | author: JoomlArt.com | version: 1.6 | creationdate: 08 May 09

Kunena version detailled: Installed version: 1.6.1 | Build: 3858 | Version name: Timu | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	Diskusné fórum o tipovaní a stávkovaní
board_offline	0
board_ofset	0.00
offline_message	<h2>Diskusné fórum sa momentálne upravuje !</h2> <div>Skúste to prosím neskôr ...</div>
enablerss	1
enablepdf	0
threads_per_page	20
messages_per_page	7
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	1
disemoticons	0
template	default
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	200
regonly	0
changename	1
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	1
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	100
allowimageupload	0
allowimageregupload	1
imageheight	600
imagewidth	600
imagesize	150
allowfileupload	0
allowfileregupload	0
filetypes	txt,rtf,pdf
filesize	120
showranking	1
rankimages	1
avatar_src
fb_profile
pm_component
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_username	1
userlist_posts	0
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	0
userlist_lastvisitdate	0
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	241
help_infb	1
help_cid	0
showspoilertag	0
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
fbsessiontimeout	3600
highlightcode	0
rss_type	recent
rss_timelimit	month
rss_limit	50
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	0
rss_word_count	100
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	50
sef	1
sefcats	1
sefutf8	0
showimgforguest	1
showfileforguest	0
pollnboptions	5
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	replyid
post_dateformat	datetime_today
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	joomla
integration_login	joomla
integration_avatar	kunena
integration_profile	kunena
integration_private	none
integration_activity	auto
boxghostmessage	1
userdeletetmessage	2
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	1
showthankyou	1
showpopthankyoustats	0
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	0
lightbox	1
activity_limit	0

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Installed (Version : 1.2.3) | Jomsocial: Disabled or not installed | UddeIm: Disabled or not installed

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Disabled | JFirePHP: Disabled or not installed | Kunena Discuss: Disabled or not installed | Kunena Search: Disabled or not installed | My Kunena Forum Menu: Disabled or not installed | My Kunena Forum Posts: Disabled or not installed

Modules: Kunena Latest: Enabled (Version : 1.6.0-RC2) | Kunena Stats: Disabled or not installed | Kunena Login: Disabled or not installed

You need to use mysql 5.x.x in order to use K1.6.x, mysql 4 hasn't been tested with k1.6.x and like in your case this specific doesn't work on mysql 4

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 20 seconds | Max execution memory: 80M | Max file upload: 12M

Joomla default template details : ja_mica | author: JoomlArt.com | version: 1.6 | creationdate: 08 May 09

Kunena version detailled: Installed version: 1.6.1 | Build: 3858 | Version name: Timu | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	Diskusné fórum o tipovaní a stávkovaní
board_offline	0
board_ofset	0.00
offline_message	<h2>Diskusné fórum sa momentálne upravuje !</h2> <div>Skúste to prosím neskôr ...</div>
enablerss	1
enablepdf	0
threads_per_page	20
messages_per_page	7
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	1
disemoticons	0
template	default
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	200
regonly	0
changename	1
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	1
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	100
allowimageupload	0
allowimageregupload	1
imageheight	600
imagewidth	600
imagesize	150
allowfileupload	0
allowfileregupload	0
filetypes	txt,rtf,pdf
filesize	120
showranking	1
rankimages	1
avatar_src
fb_profile
pm_component
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_username	1
userlist_posts	0
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	0
userlist_lastvisitdate	0
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	241
help_infb	1
help_cid	0
showspoilertag	0
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
fbsessiontimeout	2700
highlightcode	0
rss_type	recent
rss_timelimit	month
rss_limit	50
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	0
rss_word_count	100
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	50
sef	1
sefcats	1
sefutf8	0
showimgforguest	1
showfileforguest	0
pollnboptions	5
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	replyid
post_dateformat	datetime_today
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	joomla
integration_login	joomla
integration_avatar	kunena
integration_profile	kunena
integration_private	none
integration_activity	auto
boxghostmessage	1
userdeletetmessage	2
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	0
lightbox	1
activity_limit	0

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Installed (Version : 1.2.3) | Jomsocial: Disabled or not installed | UddeIm: Disabled or not installed

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Disabled | JFirePHP: Disabled or not installed | Kunena Discuss: Disabled or not installed | Kunena Search: Disabled or not installed | My Kunena Forum Menu: Disabled or not installed | My Kunena Forum Posts: Disabled or not installed

Modules: Kunena Latest: Enabled (Version : 1.6.0-RC2) | Kunena Stats: Disabled or not installed | Kunena Login: Disabled or not installed