SMF Support > Converting to SMF

Convert Kunena 1.6.0

(1/2) > >>

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: ---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
--- End code ---

EricTheRed:
Bump

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

N. N.:
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.  :)

Navigation

[0] Message Index

[#] Next page