Advertisement:

Author Topic: converting kunena 1.6.3 to smf  (Read 1438 times)

Offline losthillsguy

  • Newbie
  • *
  • Posts: 1
converting kunena 1.6.3 to smf
« on: February 08, 2012, 10:55:11 AM »
I am running the Kunena converter and get this error message...

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


Any ideas on how to proceed?

Offline Oldiesmann

  • Lead Developer
  • SMF Super Hero
  • *
  • Posts: 24,296
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: converting kunena 1.6.3 to smf
« Reply #1 on: February 08, 2012, 01:11:55 PM »
What table is used for the forum's users?