Advertisement:

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

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« 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:
Code: [Select]
---* {$to_prefix}log_polls
add after
Code: [Select]
---{
$ignore = true;
---}
then upload the file via FTP and restart the conversion..

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,936
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« 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;
---}
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Ellion Cold

  • Semi-Newbie
  • *
  • Posts: 19
Re: [SMF Converter] IPB 2.3.x
« Reply #42 on: August 21, 2008, 09:46:20 AM »
Thanks for the help! :D

Offline Ferkel

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] IPB 2.3.x
« 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!!!

Offline Ferkel

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] IPB 2.3.x
« 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? :(

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,936
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« 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?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Ferkel

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] IPB 2.3.x
« Reply #46 on: September 08, 2008, 09:04:39 AM »
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.

Offline Reinaldo122

  • Newbie
  • *
  • Posts: 9
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« 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



Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,936
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #48 on: September 23, 2008, 09:42:02 PM »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Cool Surfer

  • Semi-Newbie
  • *
  • Posts: 96
  • Gender: Male
  • Never Give Up...
    • XpIndia.Com
Re: [SMF Converter] IPB 2.3.x
« 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?
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...

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,936
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« 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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Sefer

  • Semi-Newbie
  • *
  • Posts: 17
Re: [SMF Converter] IPB 2.3.x
« 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.
« Last Edit: December 02, 2008, 12:02:53 PM by Sefer »


Offline Barnabus

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.3.x
« Reply #53 on: February 11, 2009, 02:50:32 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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« 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)

Offline Londonms

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.3.x
« 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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« 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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #57 on: April 08, 2009, 11:58:11 PM »
Hello when try to convert a see that msg
thank you

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,936
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« 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?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

candidosa2

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #59 on: April 09, 2009, 12:54:39 AM »
yes did see imagen attach