Question User sync not working

Hello,

I've searched the forum but have not found an answer to this issue.

We have over 5000 Joomla! users, but when we perform a Kunena user sync, we remain at 173 Kunena users.

Am I misunderstanding the function? I'm assuming we're supposed to have the same number of Kunena users as Joomla! after syncronizing users.


Thanks!

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: Missing | PHP environment: Max execution time: 30 seconds | Max execution memory: 512M | Max file upload: 128M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
285	SS396 Thread	mainmenu	view=category&catid=2	car-build-videos/1969-chevelle-ss396/2014-12-06-00-48-26	Yes
186	Forum	mainmenu	view=home&defaultmenu=191	2014-06-04-18-58-54	No
338	Forum Home	mainmenu	view=home&defaultmenu=191	2014-06-04-18-58-54/2014-12-15-15-36-45	No
337	Latest Posts	mainmenu	view=topics&layout=posts&mode=recent	2014-06-04-18-58-54/latest-posts	No
495	New Parts & Stuff	mainmenu	view=category&catid=17	2014-06-04-18-58-54/new-parts-stuff	No
511	Non Auto Related	mainmenu	view=category&catid=14	2014-06-04-18-58-54/non-auto-related	No
284	Forum	mainmenu	Itemid=386	kunena-2014-12-31	Yes
386	Forum	kunenamenu	view=home&defaultmenu=388	forum	No
387	Index	kunenamenu	view=category&layout=list	forum/index	No
388	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent	No
389	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic	No
390	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies	No
391	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest	No
392	Profile	kunenamenu	view=user	forum/profile	No
393	Help	kunenamenu	view=misc	forum/help	No
394	Search	kunenamenu	view=search	forum/search	No
494	New Parts & Stuff	kunenamenu	view=category&catid=17	new-parts-stuff	No

Joomla default template details : protostar | author: Kyle Ledbetter | version: 1.0 | creationdate: Unknown

Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.7 | creationdate: 2015-02-01

Kunena version detailed: Kunena 3.0.7 | 2015-02-01 [ Galah ]
| 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	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	0
catimagepath	category_images
showchildcaticon	0
rtewidth	500
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	100
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	-1
mailadmin	-1
captcha	0
mailfull	0
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	2048
imageheight	1200
imagewidth	1200
imagesize	6000
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
sessiontimeout	1800
highlightcode	0
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	900
defaultpage	recent
default_sort	asc
sef	1
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	datetime
post_dateformat_hover	datetime
hide_ip	1
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	80
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	0
show_session_type	0
show_session_starttime	0
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	0
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	0
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	0
statslink_allowed	0
superadmin_userlist	0
ebay_language	0
ebaylanguagecode	en-us

| Kunena integration settings:

Warning: Spoiler!

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

| Joomla! detailed language files installed:

Warning: Spoiler!

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

Third-party components: None

Third-party SEF components: None

Plugins: Search - Kunena Search 3.0.1 | Content - Kunena Discuss 3.0.7

Modules: Kunena Latest 3.0.1 | Kunena Stats 3.0.1 | Kunena Login 3.0.1

oestek wrote: Am I misunderstanding the function? I'm assuming we're supposed to have the same number of Kunena users as Joomla! after syncronizing users.

You are correct. Try the procedure shown in the following image:



As you may know , K 3.0.7 is is obsolete and it is not supported. As a suggestion, it might be a good idea to update to K 3.0.8 .

Thanks, I'll upgrade.

I tried that procedure, this is what I received:

Message
0 user profiles have been added

108 user profiles have been removed

0 messages have been updated

Thanks for your reply. Unfortunately, it looks like there may be a corruption in one of your database tables—the table of Joomla users. I do not know what version of Joomla you are using but, in J! 3.4.3 (the latest version of Joomla), the Joomla users are stored in the table _users

I suspect that one of the records in your _users table may be corrupted and, therefore, may be preventing the Kunena Synchronise Users feature from doing its job.

If you only have "173 users", my guess is that the 174th record may be the "problem" one.

It is not easy for someone like me—I am just an "ordinary" person like you; I am not a member of the Kunena development/support team—to help you via this forum. Perhaps one of the Kunena developers or forum moderators has a better idea and the means to help you here on this forum.

Interesting theory, I'll take a look at the Joomla user table.

Thanks for the idea.

In theory, you should be able to EMPTY (not drop) the database table _kunena_users and use the Synchronise Users feature to rebuild the table. However, I have not tried this and you should not attempt it unless you have a good, reliable backup of your website.

Hmm... interesting... my Joomla user table is not showing any users, but the back end shows nearly 6000. Been through all the tables that have anything to do with "user" and am not finding anything. The plot thickens.