- Posts: 9
- Thank you received: 0
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 Vbulletin to Kunena, jos_fb_messages
Sorry for my english, i'm french.
I'm migrating VBulletin to Kunena.
In VB, in "post" table, i have this fields
postid threadid parentid
in Kunena
id parent thread catid
What is exactly the correspondance ?
ok postid --> id
threadid --> thread ?
parentid --> ??????
Thanks for your support,
Dany
Please Log in or Create an account to join the conversation.
parentid => parent
threadid => thread
catid can be found in another table (threads(?) table, most likely threadid(?))
Please Log in or Create an account to join the conversation.
have you already migrate vbulletin to kunena ?
I have few problem with post migration
I can migrate posts, but next,I think there are a problem with id, thread or parent.. When I click on post (right panel, last post etc..) Kunena do not link to post id but to post thread.
For example, if
post id = 20000
parent = 19850
thread = 8600
Kunena try to search post #8600
But in jos_fb_messages table, id parent and thread are corrects (copied from postid, parentid and threadid from vbulletin)
Please Log in or Create an account to join the conversation.
And yes, Kunena does just like that. You need to fetch first message of that thread and that will be your threadid in kunena.
Please Log in or Create an account to join the conversation.
and thread = parent in Kunena ?
Please Log in or Create an account to join the conversation.
So to map thread from VB to Kunena, you need to look at the threads table and to find first message. That first message = thread in Kunena.
Please Log in or Create an account to join the conversation.
Do you know mysql command to copy record ? for example to populate jos_fb_messages_text with id and text from vb table. For the moment I use export/import in csv but if is possible with mysql, is faster... sorry for my english, I hope you can understand
Please Log in or Create an account to join the conversation.
I don't know what you mean by copy record, but for insered something in a table use the sql instruction :
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.
For example :
TABLE_1
'id' 'content'
1 content1
2 content2
3 content3
4 content4
TABLE_2
'id' 'content' 'other field' 'other field'
table is empty
I have tried this
INSERT INTO table_1 (id,content) VALUES (SELECT id,content FROM table_2)
But this not works
Please Log in or Create an account to join the conversation.
This is just an example and it's not complete
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.