Converting from Ikonboard to SMF does not work

[Warlock666]

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 !

[vbgamer45]

I would try putting debug=1 in url after you get that message. 

[Biology Forums]

My first time ever reading about IkonBoard! Cool

[Warlock666]

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

[vbgamer45]

Hmm is it possible to run query on it's own

Code Select Expand


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

[Warlock666]

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.

[vbgamer45]

Try creating this table and run this query

Code Select Expand


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'
);


[Warlock666]

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>

[vbgamer45]

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

[Warlock666]

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)

[vbgamer45]

change

Code Select Expand


SELECT
    temp.id_msg

To

Code Select Expand


SELECT
    temp.old_id_msg 


[vbgamer45]

Try this file

[Warlock666]

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)

[vbgamer45]

Forgot to add the hide email fix try this file

[Warlock666]

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.

[Warlock666]

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 ?

[vbgamer45]

might help i thiught that query change would be it

[Warlock666]

Here you are 

[Warlock666]

Hello vbgamer45,

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

[vbgamer45]

No not not sure why it dies.