I get this error:
QuoteSorry, 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 ''
Joomla is installed on my www.miweb.com/
So this is the path that I use, does Kunena has different path than joomla??
Thanks!
Please try specifying the exact Kunena directory, instead of joomla directory (since kunena is installed inside joomla directory)
I've tried with: \www\components\com_kunena
And gets the same:
QuoteSorry, 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 ''
Thanks
Is there a configuration file inside \www\components\com_kunena ?
ETA: what version of joomla do you have please?
Please, download this file, and open it in a lightweight code editor like Notepad++ on Windows. Edit the name of the database and prefix for joomla, to match yours.
Then, please add this file in your \www\components\com_kunena directory.
I've copied your config.php to \www\components\com_kunena\ and changed $mosConfig_db.
Appends the same...
Thank you!!
EDIT: Now WORKS thanks!!! I've had problems with avatars but all is OK!
Good to hear you got it sorted out! :)
Please help
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting topic notifications... Successful.
Converting moderators... Successful.
Clearing unused tables... Successful.
Converting smileys... Successful.
Converting attachments... Successful.
Converting avatars...
Notice: Undefined variable: file_hash in /home/www/xxx.com/subdomains/game2/convert.php(1264) : eval()'d code on line 15
The database value you're trying to insert does not exist: file_has
I did everything in this topic but after i ran the convert file NONE of my members, posts or topics showed up...
What version of Kunena, please, and what converter did you use?
I am using Kunena 1.6.4 in Joomla 1.5. The SMF converter I used was here on SMF: http://download.simplemachines.org/?converters;software=kunena (ZIP).
I even followed your one post with the configuration file (see screen shot) and SMF installed but NO users, boards or anything converted over.
Bumping this topic (see post above).
Can you please tell, where are your avatars in kunena stored? (in which folder)
Have you upgraded from Kunena 1.5 or previous to 1.6.4 at some point?
Using kunena to smf 2.0rc4 converter (but also in the old kunena to smf) the script doesn't import users.
The converter ends fine, no errors returns, but doesn't export users from kunena to smf...
Why? There's some errore in the script?
EDIT: I've got an other problem...topic's messages are exported correctly but before every ' (single-quote) there's a slash: \'. I tried to edit file converter.php or other sql file but nothing to do.
How can I resolv this as well?
Nothing please?
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.
Hello today has tried to use the converter. But has faced a problem.
QuoteSorry, 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 ''
As on top writes
QuoteNotice: 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
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.
New problem
QuoteConverting 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
Quote from: ratisar on December 05, 2011, 11:01:14 AM
New problem
QuoteConverting 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
I am having the exact same error, would really like to know what to do next to resolve this.
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".
Kunena 1.7.2
Joomla 2.5.5
Converter listed on SMF site
Error:
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting topic notifications... Successful.
Converting moderators... Successful.
Clearing unused tables... Successful.
Converting smileys... Successful.
Converting attachments... Unsuccessful!
This query:
SELECT mesid AS id_msg, filelocation
FROM `warcraft_main`.kbxsv_kunena_attachments
LIMIT 0, 500;
Caused the error:
Unknown column 'filelocation' in 'field list'
thank you :)
hello.
I ve done everything in this forum and i get this problem:
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: Table 'lusetogr_smf770.xlefz_users' doesn't exist