SMF Support > Converting to SMF

Kunena 1.7.2 to SMF 2.0.2

(1/3) > >>

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

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

How can I proceed? Please advise ppl...

TE:
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?

TE:

--- Quote from: alsthom on September 07, 2012, 02:46:26 PM ---Is there a way to convert only them? And not start from the beggining?

--- End quote ---
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..

Navigation

[0] Message Index

[#] Next page