Advertisement:

Author Topic: Converting from Ikonboard to SMF does not work  (Read 4512 times)

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #20 on: March 15, 2019, 01:21:03 PM »
Hello vbgamer45,

I don't want to push anything, but do you maybe have an idea/hint about the last error ?

Thank you very much in advance !

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,244
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from Ikonboard to SMF does not work
« Reply #21 on: March 15, 2019, 02:52:57 PM »
I would try putting debug=1 in url after you get that message. 
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Study Force

  • SMF Hero
  • ******
  • Posts: 3,599
    • StudyForcePS on Facebook
    • @studyforceps on Twitter
Re: Converting from Ikonboard to SMF does not work
« Reply #22 on: March 15, 2019, 02:58:41 PM »
My first time ever reading about IkonBoard! Cool

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #23 on: March 16, 2019, 06:52:17 AM »
Hi vbgamer45,

thanks a lot for still supporting me !

I tried the debug=1 and that's what I got:


Notice: Undefined index: convert_script in /var/www/html/convert.php on line 52Notice: Function set_magic_quotes_runtime() is deprecated in /var/www/html/convert.php on line 55

Notice: Undefined variable: result in /var/www/html/convert.php on line 2150Notice: Undefined variable: result in /var/www/html/convert.php on line 2151Notice: Undefined index: db_fetch_assoc in /var/www/html/convert.php on line 2341


Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,244
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from Ikonboard to SMF does not work
« Reply #24 on: March 16, 2019, 02:58:33 PM »
Hmm is it possible to run query on it's own
Code: [Select]
SELECT
temp.id_msg AS id_msg, mem.id_member, p.ENABLE_EMO AS smileys_enabled,
SUBSTRING(p.IP_ADDR, 1, 255) AS poster_ip, p.POST_DATE AS poster_time,
SUBSTRING(t.TOPIC_TITLE, 1, 255) AS subject,
SUBSTRING(REPLACE(p.POST, '<br>', '<br />'), 1, 65534) AS body,
p.TOPIC_ID AS id_topic, p.FORUM_ID AS id_board,
SUBSTRING(mem.member_name, 1, 255) AS poster_name,
SUBSTRING(mem.email_address, 1, 255) AS poster_email
FROM smf_tmp_messages AS temp
INNER JOIN {$from_prefix}forum_posts AS p ON (p.POST_ID = temp.old_id_msg)
LEFT JOIN {$from_prefix}forum_topics AS t ON (t.TOPIC_ID = p.TOPIC_ID)
LEFT JOIN smf_members AS mem ON (mem.temp_id = p.AUTHOR)

LIMIT 10;

Replace {$from_prefix} with the the preix in ikonboard
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #25 on: March 17, 2019, 05:21:05 AM »
Looks like the table wasn't created:

mysql> SELECT
    -> temp.id_msg AS id_msg, mem.id_member, p.ENABLE_EMO AS smileys_enabled,
    -> SUBSTRING(p.IP_ADDR, 1, 255) AS poster_ip, p.POST_DATE AS poster_time,
    -> SUBSTRING(t.TOPIC_TITLE, 1, 255) AS subject,
    -> SUBSTRING(REPLACE(p.POST, '<br>', '<br />'), 1, 65534) AS body,
    -> p.TOPIC_ID AS id_topic, p.FORUM_ID AS id_board,
    -> SUBSTRING(mem.member_name, 1, 255) AS poster_name,
    -> SUBSTRING(mem.email_address, 1, 255) AS poster_email
    -> FROM smf_tmp_messages AS temp
    -> INNER JOIN ib_forum_posts AS p ON (p.POST_ID = temp.old_id_msg)
    -> LEFT JOIN ib_forum_topics AS t ON (t.TOPIC_ID = p.TOPIC_ID)
    -> LEFT JOIN smf_members AS mem ON (mem.temp_id = p.AUTHOR)
    ->
    -> LIMIT 10;
ERROR 1146 (42S02): Table 'gisiold.smf_tmp_messages' doesn't exist

Here's an overview of all existing tables in the Ikonboard Database :

mysql> show tables;
+------------------------+
| Tables_in_gisiold      |
+------------------------+
| ib_active_sessions     |
| ib_address_books       |
| ib_attachments         |
| ib_authorisation       |
| ib_calendar            |
| ib_categories          |
| ib_email_templates     |
| ib_forum_info          |
| ib_forum_moderators    |
| ib_forum_poll_voters   |
| ib_forum_polls         |
| ib_forum_posts         |
| ib_forum_rules         |
| ib_forum_subscriptions |
| ib_forum_topics        |
| ib_help                |
| ib_mem_groups          |
| ib_member_notepads     |
| ib_member_profiles     |
| ib_member_titles       |
| ib_message_data        |
| ib_message_stats       |
| ib_mod_email           |
| ib_mod_posts           |
| ib_moderator_logs      |
| ib_search_log          |
| ib_ssi_templates       |
| ib_templates           |
| ib_topic_views         |
+------------------------+


Just to avoid a misunderstanding - I ran this query in the OLD Ikonboard Database, not the NEW SMF DB.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,244
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from Ikonboard to SMF does not work
« Reply #26 on: March 17, 2019, 10:03:14 AM »
Try creating this table and run this query
Code: [Select]
CREATE TABLE IF NOT EXISTS {$to_prefix}tmp_messages (
  old_id_msg int(12) NOT NULL default '0',
  old_id_topic int(12) NOT NULL default '0',
  date int(15) NOT NULL default '0'
 );
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #27 on: March 17, 2019, 02:04:05 PM »
After creating the table smf_tmp_messages

mysql> CREATE TABLE IF NOT EXISTS smf_tmp_messages (
    ->   old_id_msg int(12) NOT NULL default '0',
    ->   old_id_topic int(12) NOT NULL default '0',
    ->   date int(15) NOT NULL default '0'
    ->  );
Query OK, 0 rows affected (0.01 sec)


I ran the query again and got

mysql>  SELECT
    -> temp.id_msg AS id_msg, mem.id_member, p.ENABLE_EMO AS smileys_enabled,
    -> SUBSTRING(p.IP_ADDR, 1, 255) AS poster_ip, p.POST_DATE AS poster_time,
    -> SUBSTRING(t.TOPIC_TITLE, 1, 255) AS subject,
    -> SUBSTRING(REPLACE(p.POST, '<br>', '<br />'), 1, 65534) AS body,
    -> p.TOPIC_ID AS id_topic, p.FORUM_ID AS id_board,
    -> SUBSTRING(mem.member_name, 1, 255) AS poster_name,
    -> SUBSTRING(mem.email_address, 1, 255) AS poster_email
    -> FROM smf_tmp_messages AS temp
    -> INNER JOIN ib_forum_posts AS p ON (p.POST_ID = temp.old_id_msg)
    -> LEFT JOIN ib_forum_topics AS t ON (t.TOPIC_ID = p.TOPIC_ID)
    -> LEFT JOIN smf_members AS mem ON (mem.temp_id = p.AUTHOR)
    ->
    -> LIMIT 10;
ERROR 1146 (42S02): Table 'gisiold.smf_members' doesn't exist
mysql>

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,244
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from Ikonboard to SMF does not work
« Reply #28 on: March 17, 2019, 02:37:57 PM »
In front of any of the smf_ tables

Put database.smf_
So smf_members becomes
database.smf_members

Database should be your smf's forum's databasename
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #29 on: March 17, 2019, 03:41:02 PM »
Ok sorry, that was my fault. Obviously I'm no SQL-Pro

Ok, next try :

mysql> SELECT
    -> temp.id_msg AS id_msg, mem.id_member, p.ENABLE_EMO AS smileys_enabled,
    -> SUBSTRING(p.IP_ADDR, 1, 255) AS poster_ip, p.POST_DATE AS poster_time,
    -> SUBSTRING(t.TOPIC_TITLE, 1, 255) AS subject,
    -> SUBSTRING(REPLACE(p.POST, '<br>', '<br />'), 1, 65534) AS body,
    -> p.TOPIC_ID AS id_topic, p.FORUM_ID AS id_board,
    -> SUBSTRING(mem.member_name, 1, 255) AS poster_name,
    -> SUBSTRING(mem.email_address, 1, 255) AS poster_email
    -> FROM smf_tmp_messages AS temp
    -> INNER JOIN ib_forum_posts AS p ON (p.POST_ID = temp.old_id_msg)
    -> LEFT JOIN ib_forum_topics AS t ON (t.TOPIC_ID = p.TOPIC_ID)
    -> LEFT JOIN smf.smf_members AS mem ON (mem.temp_id = p.AUTHOR)
    ->
    -> LIMIT 10;
ERROR 1054 (42S22): Unknown column 'temp.id_msg' in 'field list'
mysql>


In fact the table hat only 3 columns

mysql> describe smf_tmp_messages;
+--------------+---------+------+-----+---------+-------+
| Field        | Type    | Null | Key | Default | Extra |
+--------------+---------+------+-----+---------+-------+
| old_id_msg   | int(12) | NO   |     | 0       |       |
| old_id_topic | int(12) | NO   |     | 0       |       |
| date         | int(15) | NO   |     | 0       |       |
+--------------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)



Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,244
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from Ikonboard to SMF does not work
« Reply #30 on: March 17, 2019, 03:44:04 PM »
change
Code: [Select]
SELECT
    temp.id_msg
To
Code: [Select]
SELECT
    temp.old_id_msg 
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,244
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from Ikonboard to SMF does not work
« Reply #31 on: March 17, 2019, 03:48:31 PM »
Try this file
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #32 on: March 18, 2019, 06:32:51 AM »
Hi vbgamer,

I took the new file and used it with a clean, fresh SMF Installation and this time I got:

Converting members...Wrong value type sent to the database. Integer expected. (hide_email)

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,244
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from Ikonboard to SMF does not work
« Reply #33 on: March 18, 2019, 08:46:59 AM »
Forgot to add the hide email fix try this file
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #34 on: March 18, 2019, 01:20:51 PM »
Ok not it stops again at "preparing messages"

preparing messages..

Notice: Undefined variable: result in /var/www/html/convert.php on line 2150Notice: Undefined variable: result in /var/www/html/convert.php on line 2151Notice: Undefined index: db_fetch_assoc in /var/www/html/convert.php on line 2341

I'm going to re-check, that I have the latest convert.php from Github and will report in some minutes.

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #35 on: March 18, 2019, 01:26:35 PM »
Absolutely the same with the latest convert.php from github

Just an idea - Would it make things easier if I would upload the structure of the old Ikonboard Database here ?

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,244
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from Ikonboard to SMF does not work
« Reply #36 on: March 18, 2019, 01:32:31 PM »
might help i thiught that query change would be it
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #37 on: March 18, 2019, 02:03:31 PM »
Here you are  :D

Offline Warlock666

  • Semi-Newbie
  • *
  • Posts: 51
Re: Converting from Ikonboard to SMF does not work
« Reply #38 on: March 25, 2019, 02:00:02 PM »
Hello vbgamer45,

was the file of any help ? Is there anything I can do ?

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,244
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Converting from Ikonboard to SMF does not work
« Reply #39 on: March 25, 2019, 02:31:26 PM »
No not not sure why it dies.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro