Advertisement:
2by2host
« previous next »
Pages: 1 2 [All]   Go Down

Author Topic: Kunena to SMF  (Read 16656 times)

Offline manugarrote

  • Semi-Newbie
  • *
  • Posts: 11
Kunena to SMF
« on: May 01, 2010, 11:10:34 AM »
I get this error:
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 ''
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!
Logged

Offline N. N.

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,317
  • Blue Wolf
Re: Kunena to SMF
« Reply #1 on: May 01, 2010, 11:26:44 AM »
Please try specifying the exact Kunena directory, instead of joomla directory (since kunena is installed inside joomla directory)
Logged
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

Offline manugarrote

  • Semi-Newbie
  • *
  • Posts: 11
Re: Kunena to SMF
« Reply #2 on: May 01, 2010, 11:36:02 AM »
I've tried with: \www\components\com_kunena

And gets the same:
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 ''

Thanks
Logged

Offline N. N.

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,317
  • Blue Wolf
Re: Kunena to SMF
« Reply #3 on: May 01, 2010, 11:39:10 AM »
Is there a configuration file inside \www\components\com_kunena ?

ETA: what version of joomla do you have please?
Logged
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

Offline N. N.

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,317
  • Blue Wolf
Re: Kunena to SMF
« Reply #4 on: May 01, 2010, 11:45:03 AM »
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.
Logged
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

Offline manugarrote

  • Semi-Newbie
  • *
  • Posts: 11
Re: Kunena to SMF
« Reply #5 on: May 01, 2010, 11:55:12 AM »
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!
Logged

Offline N. N.

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,317
  • Blue Wolf
Re: Kunena to SMF
« Reply #6 on: May 01, 2010, 12:23:17 PM »
Good to hear you got it sorted out! :)
Logged
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

Offline georgee

  • Newbie
  • *
  • Posts: 1
Re: Kunena to SMF
« Reply #7 on: May 03, 2011, 09:47:14 AM »
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
Logged

Offline skinnyindacity

  • Newbie
  • *
  • Posts: 5
Re: Kunena to SMF
« Reply #8 on: June 19, 2011, 09:38:42 PM »
I did everything in this topic but after i ran the convert file NONE of my members, posts or topics showed up...
Logged

Offline N. N.

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,317
  • Blue Wolf
Re: Kunena to SMF
« Reply #9 on: June 19, 2011, 09:40:01 PM »
What version of Kunena, please, and what converter did you use?
Logged
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

Offline skinnyindacity

  • Newbie
  • *
  • Posts: 5
Re: Kunena to SMF
« Reply #10 on: June 19, 2011, 09:58:53 PM »
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.
Logged

Offline skinnyindacity

  • Newbie
  • *
  • Posts: 5
Re: Kunena to SMF
« Reply #11 on: June 20, 2011, 10:50:08 AM »
Bumping this topic (see post above).
Logged

Offline N. N.

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,317
  • Blue Wolf
Re: Kunena to SMF
« Reply #12 on: June 21, 2011, 07:47:18 AM »
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?
Logged
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

Offline SoulEdge

  • Newbie
  • *
  • Posts: 6
Re: Kunena to SMF
« Reply #13 on: July 21, 2011, 04:53:10 AM »
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?
« Last Edit: July 22, 2011, 09:43:45 AM by SoulEdge »
Logged

Offline SoulEdge

  • Newbie
  • *
  • Posts: 6
Re: Kunena to SMF
« Reply #14 on: July 23, 2011, 06:19:34 PM »
Nothing please?
Logged

Offline mtstover

  • Newbie
  • *
  • Posts: 2
Re: Kunena to SMF
« Reply #15 on: August 15, 2011, 10:36:04 PM »
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.
Logged

Offline ratisar

  • Newbie
  • *
  • Posts: 2
Re: Kunena to SMF
« Reply #16 on: December 05, 2011, 08:38:24 AM »
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 ''
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
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.
Logged

Offline ratisar

  • Newbie
  • *
  • Posts: 2
Re: Kunena to SMF
« Reply #17 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
« Last Edit: December 05, 2011, 11:48:17 AM by ratisar »
Logged

Offline ITS Net Services

  • Newbie
  • *
  • Posts: 2
Re: Kunena to SMF
« Reply #18 on: December 09, 2011, 12:19:57 AM »
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

I am having the exact same error, would really like to know what to do next to resolve this.
Logged

Offline ITS Net Services

  • Newbie
  • *
  • Posts: 2
Re: Kunena to SMF
« Reply #19 on: December 09, 2011, 12:35:12 AM »
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".
Logged

Offline darkcloud784

  • Newbie
  • *
  • Posts: 1
Re: Kunena to SMF
« Reply #20 on: June 20, 2012, 03:42:17 PM »
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'


Logged

Offline kawaiihoras

  • Newbie
  • *
  • Posts: 1
Re: Kunena to SMF
« Reply #21 on: July 20, 2012, 12:31:00 PM »
thank you  :)
Logged

Offline SialoS

  • Newbie
  • *
  • Posts: 1
Re: Kunena to SMF
« Reply #22 on: August 07, 2012, 03:07:14 AM »
hello.
I ve done everything in this forum and i get this problem:

Code: [Select]
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
Logged
Pages: 1 2 [All]   Go Up
« previous next »