News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[SMF Converter] IPB 2.3.x

Started by SleePy, May 09, 2008, 10:35:02 PM

Previous topic - Next topic

ThorstenE

edit the invision23_to_smf.sql with  a text-editor and search for this line:
---* {$to_prefix}log_polls

add after
---{
$ignore = true;
---}

then upload the file via FTP and restart the conversion..

SleePy

open the .sql file

find:
---* {$to_prefix}log_polls

replace:
---* {$to_prefix}log_polls
---{
$ignore = true;
---}
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Ellion Cold


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?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Ferkel

Quote from: SleePy on September 06, 2008, 05:12:45 PM
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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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?
www.xpindia.com ; www.onlinemedicalforum.com/smf 

Be Kind And courteous To People On Your Way Up
For You Might Meet Them On Your Way Down...

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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Sefer

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


Barnabus

Quote from: SleePy on July 23, 2008, 11:26:04 PM
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


Londonms

Help -
QuoteConverting 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:

---* {$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:

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?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

candidosa2


Advertisement: