Kunena 6.3.0 released

The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3

Question Error 1062 after register user

milas
Topic Author
Offline
Junior Member

8 years 6 months ago - 8 years 6 months ago #1 by milas

Error 1062 after register user was created by milas

After registering new user and try sign in for the first time i get this error 1062

Code:

Duplicate entry '491-0' for key 'PRIMARY' SQL=INSERT INTO `XXX_kunena_user_categories` (`user_id`,`category_id`,`allreadtime`) VALUES ('491','0','1443612463')

After that user can normally sign in and everything works fine.
Joomla 3.4.4. fresh install and Kunena 4.0.6 fresh install

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

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
htaccess: Exists | PHP environment: Max execution time: 120 seconds | Max execution memory: 128M | Max file upload: 150M

Kunena menu details:

Warning: Spoiler!

ID Name Menutype Link Path In trash

101 PcTehno mainmenu view=category&layout=list&catid=0 home No

142 Nedavne Teme mainmenu view=topics&mode=replies nedavne-teme No

140 Moje Teme mainmenu view=topics&layout=user&mode=default moje-teme No

141 Profil mainmenu view=user profil No

129 PcTehno Forum mainmenu Itemid=130 kunena-2015-10-01 No

139 Nova Tema mainmenu view=topic&layout=create nova-tema No

130 Forum kunenamenu view=home&defaultmenu=131 forum No

131 Početna kunenamenu view=category&layout=list&catid=0 forum/pocetna No

132 Nedavne teme kunenamenu view=topics&mode=replies forum/recent No

133 Nova Tema kunenamenu view=topic&layout=create forum/newtopic No

134 Bez odgovora kunenamenu view=topics&mode=noreplies forum/noreplies No

135 Moje teme kunenamenu view=topics&layout=user&mode=default forum/mylatest No

136 Profil kunenamenu view=user forum/profile No

137 Pomoć kunenamenu view=misc forum/help No

138 Pretraga kunenamenu view=search forum/search No

Joomla default template details : yoo_streamline | author: YOOtheme | version: 1.0.9 | creationdate: Unknown

Kunena default template details : Blue Eagle | author: Kunena Team | version: 4.0.6 | creationdate: 2015-09-28

Kunena version detailed: Kunena 4.0.6 | 2015-09-28 [ Pielungo ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:

board_offline 0

enablerss 1

threads_per_page 20

messages_per_page 6

messages_per_page_search 15

showhistory 1

historylimit 6

shownew 1

disemoticons 0

template blue_eagle

showannouncement 0

avataroncat 1

catimagepath category_images

showchildcaticon 1

rtewidth 640

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 0

mailadmin 0

captcha 0

mailfull 1

allowavatarupload 1

allowavatargallery 1

avatarquality 75

avatarsize 2048

imageheight 800

imagewidth 800

imagesize 150

filetypes txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2,rar

filesize 200

showranking 1

rankimages 1

userlist_rows 30

userlist_online 1

userlist_avatar 1

userlist_posts 1

userlist_karma 1

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

showspoilertag 1

showvideotag 1

showebaytag 1

trimlongurls 1

trimlongurlsfront 40

trimlongurlsback 20

autoembedyoutube 1

autoembedebay 1

ebaylanguagecode en-us

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 ago

post_dateformat_hover datetime

hide_ip 1

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

boxghostmessage 0

userdeletetmessage 0

latestcategory_in 1

topicicons 1

debug 0

catsautosubscribed 0

showbannedreason 0

showthankyou 1

showpopthankyoustats 1

popthankscount 5

mod_see_deleted 0

bbcode_img_secure text

listcat_show_moderators 1

lightbox 1

show_list_time 720

show_session_type 2

show_session_starttime 1800

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 1

superadmin_userlist 0

legacy_urls 0

attachment_protection 0

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 20

| 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 Enabled: private=1

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:

hr-HR Croatian (hr-HR)

en-GB English (en-GB)

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	0
avataroncat	1
catimagepath	category_images
showchildcaticon	1
rtewidth	640
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	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	150
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2,rar
filesize	200
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_posts	1
userlist_karma	1
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
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
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	ago
post_dateformat_hover	datetime
hide_ip	1
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
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	720
show_session_type	2
show_session_starttime	1800
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	1
superadmin_userlist	0
legacy_urls	0
attachment_protection	0
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	20

Joomla! languages installed:
hr-HR	Croatian (hr-HR)
en-GB	English (en-GB)

Third-party components: UddeIM 3.7

Third-party SEF components: None

Plugins: Search - Kunena Search 3.1.1 | Content - Kunena Discuss 3.1.1

Modules: Kunena Latest 3.1.1.1

Last edit: 8 years 6 months ago by xillibit.

Please Log in or Create an account to join the conversation.

xillibit
Offline
Administrator

8 years 6 months ago #2 by xillibit

Replied by xillibit on topic Error 1062 after register user

Hello,

Check with phpmyadmin that the table kunena_user_categories has the user_is has primary key, you have done a fresh install of Kunena 4.0.6 so it's not a problem during update from previous version.

I don't provide support by PM, because this can be useful for someone else.

Please Log in or Create an account to join the conversation.

milas
Topic Author
Offline
Junior Member

8 years 6 months ago - 8 years 6 months ago #3 by milas

Replied by milas on topic Error 1062 after register user

I can't see in table kunena_user_categories anything like "user_is"

Last edit: 8 years 6 months ago by milas.

Please Log in or Create an account to join the conversation.

xillibit
Offline
Administrator

8 years 6 months ago #4 by xillibit

Replied by xillibit on topic Error 1062 after register user

I would mean user_id

I don't provide support by PM, because this can be useful for someone else.

Please Log in or Create an account to join the conversation.

milas
Topic Author
Offline
Junior Member

8 years 6 months ago - 8 years 6 months ago #5 by milas

Replied by milas on topic Error 1062 after register user

This is what i have in table kunena_user_categories

Whwn i click on user_id

when i click on Primary

Attachments:

Last edit: 8 years 6 months ago by milas.

Please Log in or Create an account to join the conversation.

Time to create page: 0.545 seconds