Convert Kunena 1.6.0

[EricTheRed]

Hello,

I'm trying to convert from Kunena 1.6.0/Joomla 1.5.22 to SMF 2 RC4. Is it possible? I'm trying to use the converter "Kunena to SMF 2-0-rc4." I've tried many times, no dice. Here is my error:

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 `cpfold`.gle_users AS m
LEFT JOIN `cpfold`.gle_fb_users AS fb ON (fb.userid = m.id)
LEFT JOIN `cpfold`.gle_contact_details AS cd ON (cd.user_id = m.id)
LIMIT 0, 500;
Caused the error:
Table 'cpfold.gle_fb_users' doesn't exist

[EricTheRed]

Bump

Anyone? I'm tempted to make a trouble ticket for this issue.

[Norv]

Sorry for the delay.

Please, use the attached file for kunena 1.6, instead of the .sql file.

[EricTheRed]

Thanks Norv!

I'm going to test this later tonight. I'll let you know how it goes.

[EricTheRed]

Worked beautifully... except for avatars. They didn't transfer over. Thanks Norv, great support here as always. 

[Norv]

You're welcome.
Sorry to hear about avatars... They might have been in a different folder than the converter expects. It expects them in
joomla_directory/media/kunena/avatars/users (where the default kunena 1.6 installation places them IIRC)

[EricTheRed]

Ahh yeah,

Mine are in /Joomla_dir/images/comprofiler. Avatars are being managed by community builder which explains why they didn't get transfered.

[julez]

Hi, I am trying to do the same thing.  would you be so kind as to please walk me through th steps that you used to successfully convert your forum from Kunena?


Thanks

[ciaovnn]

I can not display the image of the article
here are the results:

[attachment=574]bibi_restaurant_bc.jpg[/attachment]

[JJ..]

Hi, I am trying to do the same thing.  would you be so kind as to please walk me through th steps that you used to successfully convert your forum from Kunena?


Thanks

me too, I ´m a beginner, who can explain how i have to do this. It´s kunena 1.7