[SMF Converter] IPB 2.3.x

[ThorstenE]

edit the invision23_to_smf.sql with  a text-editor and search for this line:

Code Select Expand

---* {$to_prefix}log_polls

add after

Code Select Expand

---{
$ignore = true;
---}
then upload the file via FTP and restart the conversion..

[SleePy]

open the .sql file

find:

Code Select Expand

---* {$to_prefix}log_polls

replace:

Code Select Expand

---* {$to_prefix}log_polls
---{
$ignore = true;
---}


[Ellion Cold]

Thanks for the help!

[Ferkel]

Welcome you!
I'm trying to convert IP.Board v2.3.1 (ID: 23004) to SMF 1.1.5 with smf_1-1-5_invision2_converter.
But I'm getting error.

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:
    INSERT INTO `seat_club`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (2, SUBSTRING('Какая Ибица вам нравится больше???', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (3, SUBSTRING('Вариант 1', 1, 255), 'Array', 1, 255), 'Array'),
    (4, SUBSTRING('А ты что бы выбрал для себя? ', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (5, SUBSTRING('Кто же он?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (6, SUBSTRING('Кто же она?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (7, SUBSTRING('Кто же лучший?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (8, SUBSTRING('Кто же этот красавец?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (9, SUBSTRING('У кого самая улетная тачка?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (10, SUBSTRING('Кто же больше всех помогает нам?', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array');

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Array', 1, 255), 'Array'),
    (3, SUBSTRING('Вариант 1', 1, 255), 'Array',' at line 3

PLEASE!!! HELP!!!

[Ferkel]

Well I found resolution for my problem, I think.
I've just delete everything from MySQL field "poll_question" in original table "ibf_polls"

And now I have new problem:

Converting poll logs... Unsuccessful!
This query:
INSERT INTO `seat_club`.smf_log_polls
(ID_POLL, ID_MEMBER)
VALUES ('', '18'),
('', '31'),
('', '55'),
('', '19'),
('', '13'),
('', '70'),
('', '25'),
('', '46'),
('', '16'),
('', '12'),
('', '42'),
('', '23'),
('', '74'),
('', '6'),
('', '67'),
('', '27'),
('', '41'),
('', '12'),
('', '31'),
('', '92'),
('', '13'),
('', '13'),
('', '10'),
('', '9'),
('', '92'),
('', '22'),
('', '5'),
('', '55'),
('', '47'),
('', '77'),
('', '22'),
('', '12'),
('', '69'),
('', '108'),
('', '41'),
('', '108'),
('', '109'),
('', '16'),
('', '100'),
('', '41'),
('', '109'),
('', '25'),
('', '9'),
('', '13'),
('', '92'),
('', '92'),
('', '92'),
('', '41'),
('', '108'),
('', '108'),
('', '13'),
('', '109'),
('', '96'),
('', '96'),
('', '96'),
('', '100'),
('', '16'),
('', '16'),
('', '100'),
('', '13'),
('', '25'),
('', '25'),
('', '31'),
('', '31'),
('', '31'),
('', '5'),
('', '6'),
('', '41'),
('', '25'),
('', '108'),
('', '41'),
('', '25'),
('', '108'),
('', '41'),
('', '16'),
('', '108'),
('', '100'),
('', '100'),
('', '92'),
('', '92'),
('', '100'),
('', '92'),
('', '25'),
('', '96'),
('', '109'),
('', '109'),
('', '109'),
('', '9'),
('', '9'),
('', '9'),
('', '9'),
('', '9'),
('', '13'),
('', '13'),
('', '5'),
('', '5'),
('', '5'),
('', '31'),
('', '5'),
('', '31'),
('', '5'),
('', '10'),
('', '10'),
('', '10'),
('', '10'),
('', '10'),
('', '10'),
('', '6'),
('', '99'),
('', '99'),
('', '99'),
('', '99'),
('', '99'),
('', '3'),
('', '3'),
('', '3'),
('', '16'),
('', '16'),
('', '12'),
('', '12'),
('', '12'),
('', '12'),
('', '12'),
('', '12'),
('', '31'),
('', '6'),
('', '6'),
('', '6'),
('', '74'),
('', '74'),
('', '74'),
('', '74'),
('', '74'),
('', '74'),
('', '22'),
('', '22'),
('', '22'),
('', '22'),
('', '22'),
('', '22'),
('', '7'),
('', '7'),
('', '7'),
('', '7'),
('', '7'),
('', '7'),
('', '99'),
('', '70'),
('', '70');
Caused the error:

Duplicate entry '0-12-0' for key 1

What should I do?

[SleePy]

That is most likely due to your previous fix you did
Do you have a backup to revert that?

[Ferkel]

That is most likely due to your previous fix you did
Do you have a backup to revert that?

Well, that is not a problem anymore.
I've just disable (rem'it) poll while converting...
Thank you for your answer.

[Reinaldo122]

hi, where I have to put the convert.php file to could convert the BD to the SMF¿?
i'm looking but I can't find

[SleePy]

Please only ask your question once.
http://www.simplemachines.org/community/index.php?topic=190907.msg1720839#msg1720839

[Cool Surfer]

Hi
I am getting duplicate entry255 error
I tried makinh int value to 4, but its already 4.
What else can be done?

[SleePy]

You may need to change this int to 4 in the smf_categories, smf_boards and smf_collapsed_categories board. As well it is supposed to be a "BIGINT" of 4 not int.

If you run this script, http://www.simplemachines.org/community/index.php?topic=246700.0
It will do this for you. Remember to stop after the first step and let the conversion process complete before completing the rest of the steps in that script.

[Sefer]

Code Select Expand

Converting...
Converting members... Successful.
Converting categories... Unsuccessful!
This query:

    INSERT INTO `sozbitti_pedigo`.smf_categories
    (ID_CAT, name, catOrder)
    VALUES ('3', 'Önsöz Edebiyat (SB)', '3'),
    ('13', '2. Perde', '6'),
    ('26', '3. Perde', '7'),
    ('33', '1. Perde', '5'),
    ('38', 'Ve Bitti .', '8'),
    ('44', 'Başla..', '1'),
    ('284', 'Edebiyat Dünyası', '4'),
    ('335', 'İdari Yönetim Lobisi', '2');

Caused the error:

    Duplicate entry '255' for key 1

what does it mean?
what can i do for this error?

I am using IPB 2.3.1 and using true convert files..
Please help me.

[ThorstenE]

http://www.simplemachines.org/community/index.php?topic=274252.0#post_high_category_ids

[Barnabus]

It is linked to in the first post this converter topic 

Please, what am I missing... I look at the first post, there is a link "convert.php", but it just takes me back to this discussion.  I just can't find "convert.php"

Thanks in advance for your help

[ThorstenE]

http://www.simplemachines.org/community/index.php?topic=140741.0
convert.php is attached at the end from the first post (scroll down)

[Londonms]

Help -

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `smf`.smf_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_POLL, numReplies, numViews, ID_FIRST_MSG, ID_LAST_MSG, locked)
VALUES ('1', '0', '2', '1', '1', '', '3', '84', '1', '9', '0'),
('2', '0', '13', '1', '1', '', '0', '6', '2', '2', '0'),
('3', '0', '3', '1', '1', '', '6', '55', '3', '12', '0'),
('4', '0', '9', '1', '1', '', '0', '10', '13', '13', '0'),
('5', '0', '6', '1', '1', '', '2', '73', '14', '16', '0'),
('6', '0', '6', '1', '1', '', '1', '97', '17', '18', '0');
Caused the error:

Incorrect integer value: '' for column 'ID_POLL' at row 1

Invision 2.3.6

[ThorstenE]

londonms,
I think your MySQL server is in strict mode. edit the invision23_to_smf.sql and find:

Code Select Expand


---* {$to_prefix}topics 250
SELECT
t.tid AS ID_TOPIC, t.pinned AS isSticky, t.forum_id AS ID_BOARD,
t.starter_id AS ID_MEMBER_STARTED, t.last_poster_id AS ID_MEMBER_UPDATED,
pl.pid AS ID_POLL, t.posts AS numReplies, t.views AS numViews,
MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG,
t.state = 'closed' AS locked
FROM ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
LEFT JOIN {$from_prefix}polls AS pl ON (pl.tid = t.tid)
WHERE p.topic_id = t.tid
GROUP BY t.tid
HAVING ID_FIRST_MSG != 0
AND ID_LAST_MSG != 0;



replace it with:

Code Select Expand


SELECT
t.tid AS ID_TOPIC, t.pinned AS isSticky, t.forum_id AS ID_BOARD,
t.starter_id AS ID_MEMBER_STARTED, t.last_poster_id AS ID_MEMBER_UPDATED,
IF(pl.pid > 0, pl.pid , 0), t.posts AS numReplies, t.views AS numViews,
MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG,
t.state = 'closed' AS locked
FROM ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
LEFT JOIN {$from_prefix}polls AS pl ON (pl.tid = t.tid)
WHERE p.topic_id = t.tid
GROUP BY t.tid
HAVING ID_FIRST_MSG != 0
AND ID_LAST_MSG != 0;


[candidosa2]

Hello when try to convert a see that msg
thank you

[SleePy]

candidosa2,

What is the error message you are receiving at the bottom of that message?

[candidosa2]

yes did see imagen attach