Question Vbulletin to Kunena, jos_fb_messages

Hi

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

postid => id
parentid => parent
threadid => thread

catid can be found in another table (threads(?) table, most likely threadid(?))

thanks Matias

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)

I'm not familiar with VB; I haven't even used it much.

And yes, Kunena does just like that. You need to fetch first message of that thread and that will be your threadid in kunena.

hmm ok..


and thread = parent in Kunena ?

No. Parent looks the same as in VB. It's the post you answered to (reply/quote).

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.

ok Matias, thank you very much

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

Hello,

I don't know what you mean by copy record, but for insered something in a table use the sql instruction :

thanks xillibit, ok with you, but I would want to insert records from other table.

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

In this point, you need a php script to do that, i don't know if you have php skills. You need to do something like that :

This is just an example and it's not complete