Solved User list in admin seems to choke

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 120 seconds | Max execution memory: 512M | Max file upload: 128M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
1711	Forum	mainmenu	view=home&defaultmenu=1200	kunena-2015-06-04	No
1812	Recent Posts	mainmenu	view=topics&layout=posts&mode=recent	kunena-2015-06-04/recent-posts	No
1813	Recent Topics	mainmenu	view=topics&mode=replies	kunena-2015-06-04/recent-topics	No
1814	Directors Only	mainmenu	view=category&catid=83	kunena-2015-06-04/directors-only	No
282	Directors' Forum Page	mainmenu	view=category&catid=83	sp-members/directors/2012-06-15-02-01-17	No
1739	Forum for New Members	mainmenu	view=category&catid=167	2015-04-10-14-16-02/kunena-2015-06-06	No
1730	Forum	kunenamenu	view=home&defaultmenu=1732	forum	No
1731	Index	kunenamenu	view=category&layout=list	forum/index	No
1732	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent	No
1733	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic	No
1734	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies	No
1735	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest	No
1736	Profile	kunenamenu	view=user	forum/profile	No
1737	Help	kunenamenu	view=misc	forum/help	No
1738	Search	kunenamenu	view=search	forum/search	No

Joomla default template details : jsn_metro_pro | author: JoomlaShine.com | version: 2.0.4 | creationdate: 11/11/2014

Kunena default template details : | author: | version: | creationdate:

Kunena version detailed: Kunena 4.0.7 | 2015-11-16 [ Albareto ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	25
messages_per_page	6
messages_per_page_search	10
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	silverpen
showannouncement	0
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
rtewidth	650
rteheight	300
enableforumjump	0
reportmsg	1
username	0
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	60
maxsig	1
regonly	1
pubwrite	0
floodprotection	0
mailmod	1
mailadmin	-1
captcha	-1
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	80
avatarsize	1000
imageheight	700
imagewidth	700
imagesize	1000
filetypes	txt,rtf,pdf,zip,doc,docx
filesize	2000
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	0
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	0
popusercount	0
showpopsubjectstats	1
popsubjectcount	5
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	0
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	14400
highlightcode	1
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	1800
defaultpage	recent
default_sort	asc
sef	1
showimgforguest	0
showfileforguest	0
pollnboptions	10
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:60:00
pollnbvotesbyuser	1
pollresultsuserslist	1
maxpersotext	150
ordering_system	replyid
post_dateformat	ago
post_dateformat_hover	none
hide_ip	1
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	60
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	1
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	text
listcat_show_moderators	0
lightbox	1
show_list_time	720
show_session_type	0
show_session_starttime	1000
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	1
category_subscriptions	topic
topic_subscriptions	every
pubprofile	0
thankyou_max	10
email_recipient_count	20
email_recipient_privacy	bcc
captcha_post_limit	-1
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	-1
hold_guest_posts	0
attachment_limit	10
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	180
iptracking	1
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
superadmin_userlist	1
legacy_urls	1
attachment_protection	1
categoryicons	1
avatarresizemethod	1
avatarcrop	0
user_report	1
searchtime	365
teaser	0
ebay_language	0
twitter_consumer_key
twitter_consumer_secret
allow_change_subject	1
max_links	10
userlist_name	1
usernamechange	0
version_check	1
userlist_usertype	1
sefutf8	0
enablepdf	1
jmambot	1
annmodid	42,43,44,45
changename	0
userlist_username	1
rules_infb	1
help_infb	1
onlineusers	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Enabled: activity=1 avatar=1 profile=1 activity_points_limit=0
Kunena - Community Builder Enabled: access=1 login=0 activity=1 avatar=1 profile=1 private=0
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=0
Kunena - Kunena Enabled: avatar=0 profile=0
Kunena - UddeIM Enabled: private=1

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (en-GB)

Third-party components: AlphaUserPoints 2.0.4 | CommunityBuilder 2.0.12 | UddeIM 3.7

Third-party SEF components: None

Plugins: Search - Kunena Search 3.1.1

Modules: Kunena Latest 3.1.1 | Kunena Search 3.1.1

I am getting a 500 Internal Error when I click on Kunena - Users (Fatal Error: Out of memory (allocated 230948864) (tried to allocate 7738170 bytes) in libraries/joomla/application/web.php on line 717). I'm guessing it is because it is trying to load all 4000 or so site users at once. Is there a way to change the option "All" for the listing of the users to, say, 20, without access to the User page. In other words, is this value for the number of users to list on one page in the database someplace, or is there someplace in the code I can temporarily hard wire a number in there?

Thanks!

i see in the report, that you have not selected a default kunena template.
Try that first.

Thanks for your reply. Selecting a template (either Blue Eagle or Crypsis) did not help.

I have a clone site in which I only have a dozen or so users, and that site is not having problems. I noticed when I created the clone from a backup of the production site that "All" was selected in the administrative area of Kunena Users. I could take the production site offline, do a complete backup and export the Kunenua user database table, remove users in Kunena, set the "All" to 20, then upload the Kunena user table back to the database. I was hoping for something simpler, however.

Just FYI - My issue with the User list in Admin has been solved by the upgrade to Kunena 4.0.8.