Question Duplicate entry at jos_kunena_messages - Upgrade from 1.5.12

Hi I've just upgraded from 1.5.12 and whole procedure was smooth.

I can read and browse old entries ==> migrated to new forum fine.

But, I can not post a new message, because I receive this error:

500 - JDatabaseMySQL::query: 1062 - Duplicate entry '0' for key 1 SQL=INSERT INTO jos_kunena_messages (`name`, `email`, `subject`, `topic_emoticon`, `ip`, `userid`, `parent`, `thread`, `catid`, `time`, `hold`) VALUES....


Any idea ? Thx.

I cheked the last row at jos_kunena_messages and it's like:
id =0
parent =0
thread =0

I erased that retried and gave the same result...

Here are my details:

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

Legacy mode: Disabled | 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: 128M | Max file upload: 60M

Kunena version detailled: Installed version: 1.6.0-RC1 | Build: 3173 | Version name: Kujadili | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	Φόρουμ
board_offline	1
board_ofset	0.00
enablerss	1
enablepdf	0
threads_per_page	20
messages_per_page	10
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	0
disemoticons	0
template	default
showannouncement	1
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	500
rteheight	600
enableforumjump	1
reportmsg	0
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	0
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	0
maxsubject	50
maxsig	100
regonly	0
changename	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
imageprocessor	gd2
avatarquality	65
avatarsize	2048
allowimageupload	0
allowimageregupload	1
imageheight	1400
imagewidth	1000
imagesize	500
allowfileupload	0
allowfileregupload	1
filetypes	zip,txt,doc,gz,jpg,gif,pdf
filesize	500
showranking	1
rankimages	1
avatar_src
fb_profile
pm_component
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_username	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	0
popusercount	5
showpopsubjectstats	0
popsubjectcount	5
usernamechange	0
rules_infb	0
rules_cid	0
rules_link
help_infb	0
help_cid	0
help_link
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	thread
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_word_count	0
rss_old_titles	1
fbdefaultpage	categories
default_sort	asc
alphauserpoints	0
alphauserpointsrules	0
alphauserpointsnumchars	0
sef	1
sefcats	0
sefutf8	0
showimgforguest	0
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	old_ord
post_dateformat	ago
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	communitybuilder
integration_login	communitybuilder
integration_avatar	communitybuilder
integration_profile	communitybuilder
integration_private	none
integration_activity	communitybuilder
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
onlineusers	1
debug	1
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankysoustats	1
popthankscount	5
mod_see_deleted	0

poliscas wrote: But, I can not post a new message, because I receive this error:

500 - JDatabaseMySQL::query: 1062 - Duplicate entry '0' for key 1 SQL=INSERT INTO jos_kunena_messages (`name`, `email`, `subject`, `topic_emoticon`, `ip`, `userid`, `parent`, `thread`, `catid`, `time`, `hold`) VALUES....


Any idea ? Thx.

Hello,

Can-you give please the entire error message ?

It looks like you're missing primary key. Did you earlier convert the forum from Joomla 1.0?

Try this URL in your site and report your findings into here:
/administrator/index.php?option=com_kunena&view=install&layout=schema

Here is the error message:

500 - JDatabaseMySQL::query: 1062 - Duplicate entry '0' for key 1 SQL=INSERT INTO jos_kunena_messages (`name`, `email`, `subject`, `topic_emoticon`, `ip`, `userid`, `parent`, `thread`, `catid`, `time`, `hold`) VALUES('admin', '[email protected]', 'Αυτό είναι ένα δοκιμαστικό μήνυμα', '1', '87.202.168.141', '62', '0', '0', '30', '1283289461', '0')

Matias I tried this url but it gives
500 - Kunena function "install" not found
And yes the forum is converted from Joomla 1.0