Kunena 1.7.2 to SMF 2.0.2

[alsthom]

Hi.
I had some troubles to convert kunena to smf. I did some search here and I solved many of them.

But I can't solve this issue. Take a look please

Code Select Expand

Converting members...
Unsuccessful!
This query:
SELECT
m.id AS id_member, SUBSTRING(m.username, 1, 80) AS member_name,
SUBSTRING(m.username, 1, 255) AS real_name,
SUBSTRING(fb.signature, 1, 65534) AS signature,
IF(ISNULL(fb.posts), 0, fb.posts) AS posts,
SUBSTRING(SUBSTRING_INDEX(m.password, ':', 1), 1, 64) AS passwd, SUBSTRING_INDEX(m.password, ':', -1) AS password_salt,
IF(ISNULL(fb.karma), 0, fb.karma) AS karma_good, SUBSTRING(m.email, 1, 255) AS email_address,
SUBSTRING(cd.country, 1, 255) AS location,
IF(m.activation = 1, 0, 1) AS is_activated,
UNIX_TIMESTAMP(m.registerDate) AS date_registered,
UNIX_TIMESTAMP(m.lastvisitDate) AS last_login,
IF(cd.params LIKE '%email=0%', 1, 0) AS hide_email,
IF(m.usertype = 'superadministrator' OR m.usertype = 'administrator'OR m.usertype = 'Super Administrator', 1, 0) AS id_group,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS website_title, '' AS website_url, '' AS icq,
'' AS aim, '' AS yim, '' AS msn, '' AS time_format, '' AS avatar,
'' AS usertitle, '' AS member_ip, '' AS secret_question, '' AS secret_answer,
'' AS validation_code, '' AS additional_groups, '' AS smiley_set, '' AS member_ip2
FROM `amniziao_jooml61`.jos_users AS m
LEFT JOIN `amniziao_jooml61`.jos_fb_users AS fb ON (fb.userid = m.id)
LEFT JOIN `amniziao_jooml61`.jos_contact_details AS cd ON (cd.user_id = m.id)
LIMIT 0, 500;
Caused the error:
Table 'database.[b]jos_fb_users[/b]' doesn't exist

The problem is the bold above.  Table name isn't fb_users. It's Kunena, right? Something needs to be changed here, but what? and how?

I think that the converter should try to find kunena tables and not fb. So how can I proceed?

[alsthom]

I am replying to myself. Just to help others.

In the converter there is a file kunena_to_smf.sql. Open it and find fb_ and replace it with kunena_

That solved my problem. But here comes another one;

Code Select Expand

Converting members...
Successful.
Converting categories... Unsuccessful!
This query:
SELECT id AS id_cat, SUBSTRING(name, 1, 255) AS name, ordering AS cat_order
FROM `amnizia`.dsx_kunena_categories
WHERE parent = 0
LIMIT 0, 500;
Caused the error:
[b]Unknown column 'parent' in 'where clause'[/b]

How can I proceed? Please advise ppl...

[ThorstenE]

which converter did you use? the one from the downloads section (http://download.simplemachines.org/?converters;software=kunena)?

[alsthom]

That's right!

I have manage to solve the second problem by renaming kunena's table from "parent_id" to "parent".

I am not sure if this is correct.

The convertion went till topic notifications then it stop couse it couldn't find the table kunena-subscriptions.....[that's becouse my kunena is in version 2.0!]

I have now have
       - Members...
      - Categories...
      - Boards...
      - Topics...
      - Posts   converted  ok!

But i need to convert mods, smileys, attachments and avatars.

Is there a way to convert only them? And not start from the beggining?

[ThorstenE]

Is there a way to convert only them? And not start from the beggining?

yes, but that's complicated.. The one on the downloads page is outdated.. I've cheched my repositories and found a newer version. please try the attached file..

[alsthom]

I have managed to do a little proccess in the convertion.
I have stuck again at the attachments.
I get the error "Converting attachments...Unknown column 'folder' in 'field list'"
From the kunena16_to_smf.sql I found this;

SELECT mesid AS id_msg, filename, folder
FROM {$from_prefix}kunena_attachments;

I don't know anything about php etc, but I found that If I rename where it says "folder" to "something else", I then get error like this;

"Converting attachments...Unknown column 'something else' in 'field list'"

Please advise.

[ThorstenE]

OK, but I need your help. Would you please execute this query via phpMyAdmin and post the result?

Code Select Expand

SHOW COLUMNS from kunena_attachments;
I need to know the table structure from the kunena attachments table to fix that bug.

[alsthom]

Thanx for the reply.
Please look at the pic.

[ThorstenE]

mmh, no clue what's wrong here..

Code Select Expand

"Converting attachments...Unknown column 'folder' in 'field list'"
that error indicates there's a missing column named "folder" in your kunena attachments table but it's there (at least on your screenshot).

We can work around that error, but I need to know the path (folder name) to your attachments files..
example: /path/to/Joomla/files

[alsthom]

/public_html/media/kunena/attachments
/public_html/media/kunena/avatars

Regards

[ThorstenE]

Ok, hope this one works.. I've modified line 230 ..

[alsthom]

Thank you very much!
I will try it and I 'll report back.

[ilucato]

Hi folks,
I have Kunena 1.7.2 | 2012-01-31 | 5215 with Joomla 1.5.25 and intend to start to use SMF. Now my doubt is, what is the best way and the correct file link to convert my actual on-line Kunena forum to SMF without loosing posts, users and so on.

Another doubts.
a) is that possible to keep all previous communications between users of UddeIM? (Private Message system). Any further info will be appreciated, thanks
b) Does it support JoomFish! (Multiple language site)?
c) CB and AlhaUser points are supported?

Thanks in advance.

[ThorstenE]

The converter is described in this guide:
http://wiki.simplemachines.org/smf/Converting

a) don't think so, AFAIK the converter doesn't recognize UddeIM.
a) SMF is multilingual, you just need to install the related language packs.
c) AFAIK no

[bob1408]

Hi Thorsten,

I wanted PM this to you but it didn't go through.

I need updated kunena converter in a hurry and I'm willing to pay for your service as long as it's affordable for me.

I have Joomla based Kunena 2.0.3 | 2012-11-24 [ Reconciliation ] version and I like to convert data to SMF 2x [currently SMF 2.0.3  installed] so that I can get rid off kunena. I don't know how is your schedule fixed in this holiday season but I like to put up my new SMF forum public within first week of Jan 2013. I wouldn't mind you sharing the custom development with the community, actually I'd feel better if you did regardless I pay for it in spirit of sharing is caring.

Merry Christmas and Happy New Year.........