SMF Support > Converting to SMF
Kunena to SMF
mtstover:
Same issue here - got the above file to work in combo with replacing the variables as described in other posts. But now have slashes everywhere.
ratisar:
Hello today has tried to use the converter. But has faced a problem.
--- Quote ---Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Kunena 1.5. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.
The error that was received from the Database was: Incorrect database name ''
--- End quote ---
As on top writes
--- Quote ---Notice: Undefined variable: mosConfig_db in /var/www/erigras/erigras.ru/htdocs/convert.php(452) : eval()'d code on line 1
Notice: Undefined variable: mosConfig_dbprefix in /var/www/erigras/erigras.ru/htdocs/convert.php(452) : eval()'d code on line 1
--- End quote ---
The way specified above hasn't helped
Joomla 1.7.3
Kunena 1.7.1
convert.php It is established in a directory joomla
Path to SMF:/var/www/erigras/erigras.ru/htdocs/forum
Path to Kunena 1.5:/var/www/erigras/erigras.ru/htdocs/
kunena is in/erigras.ru/htdocs/components/com_kunena
I apologize for my English translated the translator.
ratisar:
New problem
--- Quote ---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 `erigrasdb1`.tgpc_users AS m
LEFT JOIN `erigrasdb1`.tgpc_fb_users AS fb ON (fb.userid = m.id)
LEFT JOIN `erigrasdb1`.tgpc_contact_details AS cd ON (cd.user_id = m.id)
LIMIT 0, 500;
Caused the error:
Table 'erigrasdb1.tgpc_fb_users' doesn't exist
--- End quote ---
ITS Net Services:
--- Quote from: ratisar on December 05, 2011, 11:01:14 AM ---New problem
--- Quote ---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 `erigrasdb1`.tgpc_users AS m
LEFT JOIN `erigrasdb1`.tgpc_fb_users AS fb ON (fb.userid = m.id)
LEFT JOIN `erigrasdb1`.tgpc_contact_details AS cd ON (cd.user_id = m.id)
LIMIT 0, 500;
Caused the error:
Table 'erigrasdb1.tgpc_fb_users' doesn't exist
--- End quote ---
--- End quote ---
I am having the exact same error, would really like to know what to do next to resolve this.
ITS Net Services:
Figured out the problem I was having above.
The convertor for Kunena to SMF was written for FireBoard and is looking for database tables named fb. When FireBoard changed to Kunena, they renamed all their database tables to kunena.
So if you do a find and replace on the kunena_to_smf.sql file you can get it to work. Simply find "fb" and replace it with "kunena".
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version