• Welcome to Simple Machines Community Forum. Please login or sign up.
December 04, 2021, 12:35:37 PM

News:

Want to get involved in developing SMF, then why not lend a hand on our github!


Kunena to SMF

Started by manugarrote, May 01, 2010, 11:10:34 AM

Previous topic - Next topic

manugarrote

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/ [nofollow]

So this is the path that I use, does Kunena has different path than joomla??
Thanks!

Norv

Please try specifying the exact Kunena directory, instead of joomla directory (since kunena is installed inside joomla directory)
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

manugarrote

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

Norv

Is there a configuration file inside \www\components\com_kunena ?

ETA: what version of joomla do you have please?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

manugarrote

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!

Norv

Good to hear you got it sorted out! :)
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

georgee

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

skinnyindacity

I did everything in this topic but after i ran the convert file NONE of my members, posts or topics showed up...

Norv

What version of Kunena, please, and what converter did you use?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

skinnyindacity

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.

skinnyindacity

Bumping this topic (see post above).

Norv

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?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

SoulEdge

July 21, 2011, 04:53:10 AM #13 Last Edit: July 22, 2011, 09:43:45 AM by SoulEdge
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?

SoulEdge


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

ratisar

December 05, 2011, 11:01:14 AM #17 Last Edit: December 05, 2011, 11:48:17 AM by ratisar
New problem
QuoteConverting members... Unsuccessful!
This query:

    SELECT
    hxxp:m.id [nonactive] 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 = hxxp:m.id [nonactive])
    LEFT JOIN `erigrasdb1`.tgpc_contact_details AS cd ON (cd.user_id = hxxp:m.id [nonactive])
    LIMIT 0, 500;

Caused the error:

    Table 'erigrasdb1.tgpc_fb_users' doesn't exist

ITS Net Services

Quote from: ratisar on December 05, 2011, 11:01:14 AM
New problem
QuoteConverting members... Unsuccessful!
This query:

    SELECT
    hxxp:m.id [nonactive] 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 = hxxp:m.id [nonactive])
    LEFT JOIN `erigrasdb1`.tgpc_contact_details AS cd ON (cd.user_id = hxxp:m.id [nonactive])
    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.

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".

Advertisement: