Author Topic: [SMF Converter] IPB 2.3.x (Read 251939 times)

ThorstenE · « **Reply #40 on:** August 20, 2008, 01:33:19 AM »

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 · « **Reply #41 on:** August 20, 2008, 04:31:41 PM »

open the .sql file

find:

Code: [Select]

---* {$to_prefix}log_polls
replace:

Code: [Select]

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

Ellion Cold · « **Reply #42 on:** August 21, 2008, 09:46:20 AM »

Thanks for the help!

Ferkel · « **Reply #43 on:** September 05, 2008, 03:49:51 AM »

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 · « **Reply #44 on:** September 05, 2008, 05:12:31 AM »

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 · « **Reply #45 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?

Ferkel · « **Reply #46 on:** September 08, 2008, 09:04:39 AM »

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 · « **Reply #47 on:** September 23, 2008, 06:27:51 PM »

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 · « **Reply #48 on:** September 23, 2008, 09:42:02 PM »

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

Cool Surfer · « **Reply #49 on:** October 17, 2008, 01:24:26 PM »

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

SleePy · « **Reply #50 on:** October 17, 2008, 05:56:41 PM »

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 · « **Reply #51 on:** December 02, 2008, 11:57:16 AM »

Code: [Select]

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 · « **Reply #52 on:** December 02, 2008, 12:04:40 PM »

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

Barnabus · « **Reply #53 on:** February 11, 2009, 02:50:32 PM »

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 · « **Reply #54 on:** February 11, 2009, 02:59:36 PM »

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

Londonms · « **Reply #55 on:** February 23, 2009, 09:23:02 PM »

Help -

Quote

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 · « **Reply #56 on:** February 24, 2009, 02:37:27 AM »

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

Code: [Select]

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

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 · « **Reply #57 on:** April 08, 2009, 11:58:11 PM »

Hello when try to convert a see that msg
thank you

SleePy · « **Reply #58 on:** April 09, 2009, 12:22:02 AM »

candidosa2,

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

candidosa2 · « **Reply #59 on:** April 09, 2009, 12:54:39 AM »

yes did see imagen attach

News:

Author Topic: [SMF Converter] IPB 2.3.x (Read 251939 times)

ThorstenE

ThorstenE

ThorstenE

ThorstenE

candidosa2

candidosa2