Advertisement:

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

Offline Python000

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #80 on: July 13, 2009, 06:11:13 PM »
Any error messages during the conversion (white page, script stops, internal server error) ???
My browser says that the page timed out, it is a browser error not a SMF error but I've tried Google Chrome and Internet Explorer and it still happens.

Any ideas?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • 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 #81 on: July 23, 2009, 09:28:35 PM »
You might want to convert via command line. It seems like the queries it is executing is causing the server to lock up and your browser is giving up before it does.

Do you have any part of the conversion done? That you know of so far?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Python000

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #82 on: July 23, 2009, 09:32:16 PM »
You might want to convert via command line. It seems like the queries it is executing is causing the server to lock up and your browser is giving up before it does.

Do you have any part of the conversion done? That you know of so far?
Yeah, like I said it finishes about half of the conversion, and I can see it when I browse the new forum (the parts it converted).  Then that happens.  It converts stuff like members but stops before it converts the important stuff like posts, boards, and stats!

Offline Python000

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #83 on: July 28, 2009, 02:40:40 PM »
Anybody?  This is getting kind of urgent now.

I don't like my server supports shell access because it wouldn't let me access it. :o

The conversion gets about half way through converting posts when it gives up.  The very last number in the URL was 38500 I believe, the number that progresses up as it converts more posts.

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #84 on: July 28, 2009, 03:07:05 PM »
please try to decrease the number of concurrent converted messages..

edit the invision23_to_smf.sql

find:
Code: [Select]
---* {$to_prefix}messages 200replace it with:
Code: [Select]
---* {$to_prefix}messages 100then restart the conversion.

Offline Python000

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #85 on: July 28, 2009, 11:21:26 PM »
please try to decrease the number of concurrent converted messages..

edit the invision23_to_smf.sql

find:
Code: [Select]
---* {$to_prefix}messages 200replace it with:
Code: [Select]
---* {$to_prefix}messages 100then restart the conversion.
Didn't work, still stops working when "start=39500" (the url).  It's always that same number where it stops working... :(

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #86 on: July 29, 2009, 01:17:12 AM »
Any chance to convert your forum offline? You could install a local webserver on your PC (XAMPP for example is an easy to install MySQL, PHP, Apache environment), then import your forum and convert it to SMF, then transfer the converted SMF back to your host..

Mu3rt31

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #87 on: July 30, 2009, 03:58:00 AM »
Just did download the that .sql file from this thread the error message does not say "script error in line 23" anymore it just says:
Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

http://www.simplemachines.org/community/index.php?topic=325809.0
« Last Edit: July 30, 2009, 04:01:28 AM by Mu3rt31 »

Offline Smoerble

  • Semi-Newbie
  • *
  • Posts: 19
Re: [SMF Converter] IPB 2.3.x
« Reply #88 on: August 05, 2009, 03:31:11 PM »
I get duplicate entry errors because the answers are the same, but not the polls.

That means I have a lot polls that have the answer "yes". Each produces a duplicate entry error :(.

Anyone has an idea how to fix this?

Offline Metalltony

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.3.x
« Reply #89 on: August 12, 2009, 12:27:54 PM »
hi,
I want to convert my board from ipb 2.3.6 to smf 1.1.10 but I get this error msg

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting calendar events... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments... Successful.
Converting user avatars... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1250094278),
    ("conversion_from", "invision23_to_smf.sql");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1250094278)' at line 1

What can I do?

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #90 on: August 12, 2009, 12:33:36 PM »
everything should be fine, that's a minor bug in convert.php (we add a database value after the conversion) and the conversion has already finished.

Quote
Recalculating forum statistics... Successful.

Offline Alpha120

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.3.x
« Reply #91 on: December 14, 2009, 08:52:30 PM »
Hello, sorry for this post in this topic, I know the last post is from 12-08, but I need help with my IPB 2.3.6 to SMF 1.1.11 conversion.

I get this error:

Converting members... Unsuccessful!
This query:

    SELECT
    m.id AS ID_MEMBER, SUBSTRING(m.name, 1, 80) AS memberName,
    m.joined AS dateRegistered,
    IF(m.mgroup = 4, 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS ID_GROUP,
    posts, m.last_visit AS lastLogin, SUBSTRING(m.members_display_name, 1, 80) AS realName,
    SUBSTRING(me.yahoo, 1, 32) AS YIM, m.msg_total AS instantMessages,
    SUBSTRING(mc.converge_pass_hash, 1, 64) AS passwd,
    SUBSTRING(mc.converge_pass_salt, 1, 5) AS passwordSalt,
    SUBSTRING(m.email, 1, 255) AS emailAddress,
    IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,
    SUBSTRING(me.website, 1, 255) AS websiteTitle,
    SUBSTRING(me.website, 1, 255) AS websiteUrl, me.signature,
    SUBSTRING(me.location, 1, 255) AS location,
    SUBSTRING(me.icq_number, 1, 255) AS ICQ,
    SUBSTRING(me.msnname, 1, 255) AS MSN, SUBSTRING(me.aim_name, 1, 16) AS AIM,
    m.hide_email AS hideEmail, m.email_pm AS pm_email_notify,
    SUBSTRING(IF(me.avatar_location = 'noavatar', '', me.avatar_location), 1, 255) AS avatar,
    TRIM(BOTH ',' FROM mgroup_others) AS additionalGroups,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS messageLabels,
    '' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
    '' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
    '' AS smileySet, '' AS memberIP2
    FROM `fuertota_ctrlz`.ibf_members AS m
    LEFT JOIN `fuertota_ctrlz`.ibf_member_extra AS me ON (m.id = me.id)
    LEFT JOIN `fuertota_ctrlz`.ibf_members_converge AS mc ON (m.id = mc.converge_id)
    WHERE m.id != 0
    LIMIT 0, 500;

Caused the error:

    Table 'fuertota_ctrlz.ibf_member_extra' doesn't exist

I hope you can help me.
Thanks in advance.

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] IPB 2.3.x
« Reply #92 on: December 14, 2009, 09:18:52 PM »
Is there something, an admin option, in IPB, like enabling extra information about members? If yes, please enable it, then try again.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline Alpha120

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.3.x
« Reply #93 on: December 15, 2009, 07:54:38 PM »
Thank you for your fast reply. It seems my pal forgot to put the SMF forum on the same host; he wanted to do a db conversion "on the fly" from one server to another.
Anyway, it is working now. Thank you for your help :)

Offline adamc72

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.3.x
« Reply #94 on: January 01, 2010, 05:06:57 PM »
Hi,

Happy New Year. I am trying to convert my IPB2.3.6 to SMF1.1.11 and get the following error:
Code: [Select]
Converting...
Converting topics... Unsuccessful!
This query:
INSERT INTO `db23466_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 ('1410', '0', '1', '419', '115', '', '6', '290', '17065', '17099', '0'),
('1412', '0', '5', '24', '87', '', '10', '246', '17083', '17449', '0'),
('1413', '0', '3', '374', '1144', '', '7', '348', '17117', '17613', '0'),
('1414', '0', '1', '21', '30', '', '17', '820', '17119', '17255', '0'),
('1415', '0', '1', '125', '512', '', '33', '1113', '17153', '17993', '0'),
('1416', '0', '5', '560', '981', '', '1', '139', '17159', '17296', '0'),
('1417', '0', '1', '560', '86', '', '7', '310', '17173', '17623', '0'),
('1418', '0', '4', '974', '974', '', '5', '757', '17179', '17317', '0'),
('1419', '0', '1', '220', '21', '', '4', '221', '17194', '17201', '0'),
('1420', '1', '7', '262', '390', '', '9', '5182', '17226', '17320', '0'),
('1421', '0', '9', '1', '1', '', '0', '10', '17227', '17227', '0'),
('1422', '0', '4', '262', '359', '', '5', '1492', '17230', '17283', '0'),
('1423', '0', '10', '1074', '289', '', '3', '209', '17231', '17437', '0'),
('1424', '0', '3', '501', '151', '', '24', '846', '17236', '56128', '0'),
('1425', '0', '5', '58', '222', '', '171', '2548', '17261', '19186', '0'),
('1426', '0', '1', '512', '512', '', '14', '645', '17273', '18020', '0'),
('1427', '0', '10', '1055', '1511', '', '34', '1448', '17308', '38867', '0'),
('1428', '0', '10', '359', '359', '', '5', '376', '17326', '17528', '0'),
('1429', '0', '1', '657', '335', '', '20', '750', '17343', '17615', '0'),
('1430', '0', '4', '279', '279', '', '6', '803', '17392', '17454', '0'),
('1431', '0', '1', '98', '512', '', '8', '311', '17403', '17484', '0'),
('1432', '0', '5', '262', '156', '', '1', '228', '17419', '17427', '0'),
('1433', '0', '5', '560', '222', '', '14', '270', '17432', '17630', '0'),
('1434', '0', '5', '250', '250', '', '0', '128', '17455', '17455', '0'),
('1435', '0', '1', '284', '257', '', '12', '608', '17463', '17807', '0'),
('1436', '0', '1', '125', '125', '', '0', '300', '17467', '17467', '0'),
('1437', '0', '10', '1137', '1138', '', '18', '644', '17471', '17972', '0'),
('1438', '0', '10', '803', '1137', '', '4', '333', '17479', '19364', '0'),
('1440', '0', '5', '280', '280', '', '2', '118', '17491', '17494', '0'),
('1441', '0', '5', '30', '981', '', '32', '1311', '17498', '18264', '0'),
('1444', '0', '1', '143', '143', '', '0', '273', '17531', '17531', '0'),
('1445', '0', '3', '170', '512', '', '23', '872', '17556', '35398', '0'),
('1446', '0', '5', '222', '222', '', '2', '198', '17560', '17590', '0'),
('1447', '0', '1', '1143', '512', '', '22', '788', '17585', '17747', '0'),
('1448', '0', '10', '1139', '1139', '', '2', '212', '17596', '17854', '0'),
('1449', '0', '5', '222', '222', '', '2', '125', '17598', '17629', '0'),
('1450', '0', '5', '868', '868', '', '6', '230', '17639', '17961', '0'),
('1451', '0', '5', '222', '222', '', '0', '173', '17643', '17643', '0'),
('1452', '0', '3', '170', '256', '', '2', '387', '17644', '18089', '0'),
('1453', '0', '10', '147', '147', '', '0', '109', '17657', '17657', '0'),
('1454', '0', '10', '147', '1138', '', '2', '170', '17658', '17857', '0'),
('1455', '0', '10', '147', '147', '', '16', '1082', '17659', '22636', '0'),
('1456', '0', '1', '30', '512', '', '21', '619', '17660', '18017', '0'),
('1457', '0', '1', '30', '70', '', '17', '795', '17678', '17885', '0'),
('1458', '0', '5', '156', '156', '', '28', '602', '17680', '18448', '0'),
('1459', '0', '1', '501', '501', '', '7', '524', '17688', '18104', '0'),
('1460', '0', '1', '103', '30', '', '7', '336', '17691', '18522', '0'),
('1461', '0', '1', '1', '1', '', '5', '199', '17714', '17958', '1'),
('1462', '0', '10', '25', '25', '', '2', '250', '17715', '18152', '0'),
('1463', '0', '5', '324', '89', '', '14', '273', '17728', '18509', '0'),
('1464', '0', '5', '222', '222', '', '3', '292', '17786', '17793', '0'),
('1465', '0', '5', '24', '228', '', '3', '211', '17792', '17943', '0'),
('1466', '0', '1', '1148', '197', '', '7', '266', '17815', '17924', '0'),
('1467', '0', '1', '21', '175', '', '2', '229', '17818', '17843', '0'),
('1468', '0', '1', '299', '30', '', '7', '282', '17831', '17862', '0'),
('1469', '0', '5', '143', '222', '', '43', '611', '17860', '19191', '0'),
('1470', '0', '10', '547', '547', '', '0', '128', '17864', '17864', '0'),
('1471', '0', '10', '420', '420', '', '0', '141', '17865', '17865', '0'),
('1472', '0', '1', '38', '262', '', '43', '1710', '17879', '18195', '0'),
('1473', '0', '1', '280', '21', '', '1', '177', '17889', '17891', '0'),
('1474', '0', '4', '121', '430', '', '8', '414', '17894', '23965', '0'),
('1476', '0', '1', '439', '30', '', '10', '301', '17911', '17930', '0'),
('1477', '0', '1', '803', '1157', '', '15', '735', '17916', '19507', '0'),
('1478', '0', '3', '574', '574', '', '6', '833', '17908', '18129', '0'),
('1479', '0', '5', '222', '981', '', '7', '498', '17962', '18308', '0'),
('1480', '0', '1', '831', '222', '', '19', '801', '17975', '18955', '0'),
('1481', '0', '1', '371', '30', '', '6', '547', '17979', '18065', '0'),
('1482', '0', '1', '600', '762', '', '2', '220', '17983', '18005', '0'),
('1483', '0', '1', '412', '412', '', '0', '220', '17996', '17996', '0'),
('1484', '0', '4', '297', '297', '', '2', '435', '17999', '18274', '0'),
('1485', '0', '1', '512', '512', '', '15', '573', '18004', '18140', '0'),
('1486', '0', '1', '306', '126', '', '4', '446', '18007', '18063', '0'),
('1487', '0', '10', '483', '483', '', '5', '484', '18012', '20265', '0'),
('1488', '0', '1', '419', '444', '', '20', '652', '18022', '18653', '0'),
('1489', '0', '1', '371', '371', '', '0', '202', '18025', '18025', '0'),
('1490', '0', '1', '512', '262', '', '5', '252', '18027', '18041', '0'),
('1492', '0', '5', '80', '222', '', '25', '348', '18037', '18906', '0'),
('1493', '0', '5', '250', '981', '', '5', '502', '18050', '18338', '0'),
('1494', '0', '5', '45', '353', '', '3', '156', '18052', '18204', '0'),
('1495', '0', '14', '90', '30', '', '38', '1608', '18061', '25874', '0'),
('1496', '0', '5', '981', '981', '', '8', '196', '18064', '18096', '0'),
('1497', '0', '1', '98', '156', '', '5', '338', '18077', '18166', '0'),
('1499', '0', '5', '981', '222', '', '5', '189', '18106', '18118', '0'),
('1500', '0', '10', '323', '323', '', '3', '277', '18120', '18199', '0'),
('1501', '0', '1', '143', '151', '', '7', '304', '18145', '18391', '0'),
('1502', '0', '10', '1127', '1127', '', '1', '302', '18150', '20330', '0'),
('1503', '0', '1', '755', '981', '', '9', '579', '18156', '18335', '0'),
('1504', '0', '1', '444', '444', '', '0', '122', '18159', '18159', '0'),
('1507', '0', '1', '257', '257', '', '0', '195', '18185', '18185', '0'),
('1508', '0', '1', '1153', '11', '', '3', '310', '18193', '18207', '1'),
('1509', '0', '14', '104', '104', '', '4', '774', '18198', '18227', '0'),
('1510', '0', '1', '22', '175', '', '44', '1501', '18217', '18500', '0'),
('1511', '0', '1', '419', '38', '', '17', '758', '18229', '18576', '0'),
('1512', '0', '1', '412', '812', '', '1', '305', '18235', '18253', '0'),
('1513', '0', '1', '1153', '981', '', '8', '271', '18241', '18330', '0'),
('1514', '0', '5', '229', '229', '', '0', '165', '18245', '18245', '0'),
('1515', '0', '4', '27', '100', '', '5', '336', '18257', '18637', '0'),
('1516', '0', '4', '1153', '359', '', '2', '373', '18263', '18282', '0'),
('1517', '0', '1', '77', '250', '', '2', '300', '18287', '18316', '0'),
('1518', '0', '1', '394', '1074', '', '44', '1329', '18299', '18880', '0'),
('1519', '0', '4', '265', '200', '', '10', '564', '18315', '19583', '0'),
('1520', '0', '5', '256', '256', '', '15', '261', '18339', '18567', '0'),
('1521', '0', '4', '803', '803', '', '5', '491', '18355', '18441', '0'),
('1522', '0', '1', '333', '353', '', '28', '872', '18357', '18708', '0'),
('1523', '0', '1', '419', '0', '', '12', '480', '18394', '18491', '0'),
('1524', '0', '5', '1072', '222', '', '23', '481', '18421', '19272', '0'),
('1528', '0', '10', '549', '483', '', '11', '1701', '18458', '23476', '0'),
('1529', '0', '1', '143', '38', '', '2', '233', '18463', '18469', '0'),
('1531', '0', '1', '38', '197', '', '20', '591', '18467', '18895', '0'),
('1532', '0', '1', '1139', '447', '', '1', '283', '18477', '18479', '0'),
('1533', '0', '14', '1153', '1153', '', '5', '1083', '18492', '19590', '0'),
('1534', '0', '1', '175', '333', '', '14', '357', '18497', '18663', '0'),
('1535', '0', '5', '554', '297', '', '6', '165', '18512', '18999', '0'),
('1536', '0', '1', '598', '918', '', '54', '3796', '18515', '20622', '0'),
('1537', '0', '14', '39', '34', '', '18', '658', '18516', '25595', '0'),
('1538', '0', '14', '512', '512', '', '8', '911', '18521', '18964', '0'),
('1539', '0', '1', '325', '447', '', '4', '425', '18523', '18675', '0'),
('1540', '0', '10', '1161', '1055', '', '4', '334', '18536', '19456', '0'),
('1541', '0', '5', '21', '297', '', '2', '132', '18537', '18997', '0'),
('1542', '0', '4', '560', '115', '', '6', '536', '18583', '18731', '0'),
('1543', '0', '3', '1164', '512', '', '3', '340', '18592', '18786', '0'),
('1544', '0', '1', '560', '361', '', '38', '877', '18597', '18831', '0'),
('1545', '0', '1', '263', '222', '', '1', '365', '18598', '18954', '0'),
('1546', '0', '1', '870', '870', '', '0', '127', '18600', '18600', '0'),
('1547', '0', '12', '870', '870', '', '2', '529', '18606', '21640', '0'),
('1548', '0', '12', '870', '1251', '', '3', '704', '18607', '28741', '0'),
('1549', '0', '5', '560', '222', '29', '28', '465', '18610', '19348', '0'),
('1550', '0', '1', '98', '45', '', '24', '756', '18620', '18917', '0'),
('1551', '0', '5', '870', '870', '', '2', '136', '18621', '21650', '0'),
('1552', '0', '5', '374', '374', '', '0', '225', '18625', '18625', '0'),
('1553', '0', '4', '1121', '68', '', '12', '534', '18641', '18755', '0'),
('1554', '0', '1', '444', '444', '', '0', '127', '18662', '18662', '0'),
('1555', '0', '1', '444', '297', '', '5', '342', '18666', '19005', '0'),
('1556', '0', '1', '367', '115', '', '35', '1462', '18671', '19138', '0'),
('1557', '0', '10', '297', '483', '', '1', '218', '18724', '21592', '0'),
('1559', '0', '4', '0', '200', '', '4', '643', '18756', '19024', '0'),
('1560', '0', '5', '297', '297', '', '3', '229', '18769', '18792', '0'),
('1561', '0', '1', '1167', '1167', '', '16', '690', '18788', '19584', '0'),
('1562', '0', '3', '512', '100', '', '7', '438', '18796', '21735', '0'),
('1563', '0', '14', '121', '1', '', '9', '1417', '18845', '19211', '0'),
('1564', '0', '4', '1138', '447', '', '9', '407', '18857', '19758', '0'),
('1566', '0', '14', '39', '323', '', '2', '605', '18876', '18961', '0'),
('1568', '0', '14', '30', '21', '', '22', '1391', '18908', '20005', '0'),
('1569', '0', '1', '439', '419', '', '5', '321', '18909', '19115', '0'),
('1570', '0', '1', '30', '30', '', '1', '273', '18911', '19035', '0'),
('1571', '0', '5', '222', '222', '', '7', '143', '18916', '19289', '0'),
('1574', '0', '3', '554', '126', '', '15', '632', '18948', '19580', '0'),
('1575', '0', '1', '377', '1010', '', '18', '568', '18974', '19216', '0'),
('1576', '0', '5', '80', '222', '', '28', '451', '18975', '19485', '0'),
('1577', '1', '7', '1173', '1284', '', '30', '7359', '18978', '54419', '0'),
('1578', '0', '1', '64', '1', '', '1', '272', '18991', '19214', '0'),
('1579', '0', '1', '654', '1', '', '2', '135', '19009', '19212', '0'),
('1580', '0', '5', '256', '222', '', '1', '123', '19011', '19275', '0'),
('1581', '0', '1', '1176', '657', '', '36', '1209', '19014', '19853', '0'),
('1582', '0', '1', '560', '299', '30', '9', '759', '19036', '19520', '0'),
('1583', '0', '14', '121', '197', '', '1', '591', '19086', '19193', '0'),
('1584', '0', '10', '1176', '1176', '', '0', '205', '19089', '19089', '0'),
('1586', '0', '14', '918', '39', '', '15', '1328', '19128', '19368', '0'),
('1587', '0', '1', '501', '803', '', '23', '762', '19061', '19263', '0'),
('1588', '0', '1', '498', '1010', '', '16', '800', '19145', '19336', '0'),
('1590', '0', '1', '21', '45', '', '30', '1493', '19156', '19612', '0'),
('1591', '0', '1', '321', '321', '', '3', '343', '19165', '19610', '0'),
('1592', '0', '1', '100', '498', '', '9', '398', '19175', '19508', '0'),
('1593', '0', '1', '222', '222', '', '2', '179', '19210', '19345', '0'),
('1596', '0', '13', '177', '115', '', '1', '809', '19238', '19648', '0'),
('1597', '0', '1', '560', '280', '', '2', '191', '19251', '19254', '0'),
('1598', '0', '5', '280', '280', '', '1', '158', '19258', '19259', '0'),
('1599', '0', '5', '498', '13', '', '29', '716', '19269', '19844', '0'),
('1600', '0', '4', '289', '692', '', '9', '334', '19274', '20409', '0'),
('1601', '0', '5', '30', '222', '', '22', '617', '19277', '21464', '0'),
('1602', '0', '3', '170', '605', '', '4', '594', '19304', '19992', '0'),
('1603', '0', '1', '512', '762', '', '12', '448', '19306', '19402', '0'),
('1604', '0', '4', '359', '38', '', '52', '1809', '19307', '23458', '0'),
('1607', '0', '3', '554', '306', '', '15', '716', '19331', '22412', '0'),
('1608', '0', '4', '641', '472', '', '1', '269', '19333', '19361', '0'),
('1610', '0', '10', '483', '483', '', '3', '240', '19343', '20266', '0'),
('1611', '0', '10', '98', '98', '', '0', '178', '19362', '19362', '0'),
('1612', '0', '14', '21', '145', '', '12', '918', '19369', '20087', '0'),
('1613', '0', '5', '263', '222', '', '29', '665', '19370', '23735', '0'),
('1614', '0', '1', '143', '115', '', '26', '1562', '19371', '19596', '0'),
('1616', '0', '1', '289', '27', '', '7', '336', '19386', '19423', '0'),
('1617', '0', '1', '433', '649', '', '7', '413', '19397', '19582', '0'),
('1618', '0', '1', '359', '11', '', '2', '270', '19425', '19502', '0'),
('1619', '0', '14', '39', '39', '', '4', '784', '19432', '19446', '0'),
('1620', '0', '3', '512', '1234', '', '4', '451', '19433', '21599', '0'),
('1621', '0', '5', '560', '222', '31', '27', '476', '19452', '21465', '0'),
('1622', '0', '5', '222', '868', '', '4', '164', '19468', '19708', '0'),
('1623', '0', '10', '238', '238', '', '4', '451', '19474', '21570', '0'),
('1624', '0', '1', '693', '1153', '', '15', '544', '19483', '19667', '0'),
('1625', '0', '1', '758', '444', '', '19', '879', '19495', '19807', '0'),
('1626', '0', '10', '1187', '444', '', '26', '952', '19505', '28858', '0'),
('1627', '0', '10', '657', '395', '', '1', '394', '19506', '19640', '0'),
('1628', '0', '10', '1193', '1193', '', '10', '439', '19514', '20821', '0'),
('1629', '0', '13', '512', '512', '', '4', '1163', '19522', '22070', '0'),
('1630', '0', '10', '1189', '1137', '', '2', '250', '19529', '21862', '0'),
('1631', '0', '4', '299', '301', '', '16', '1124', '19549', '20875', '0'),
('1632', '0', '1', '693', '693', '', '1', '246', '19557', '19558', '0'),
('1633', '0', '4', '27', '27', '', '0', '157', '19572', '19572', '0'),
('1634', '0', '1', '325', '981', '', '50', '1782', '19577', '20370', '0'),
('1635', '0', '1', '79', '447', '', '3', '447', '19585', '19756', '0'),
('1636', '0', '1', '1153', '98', '', '9', '732', '19591', '19687', '0'),
('1637', '0', '5', '38', '38', '', '0', '130', '19592', '19592', '0'),
('1638', '0', '4', '80', '279', '', '8', '884', '19599', '19921', '0'),
('1639', '0', '5', '228', '228', '', '12', '273', '19603', '21745', '0'),
('1640', '0', '5', '45', '228', '', '12', '432', '19618', '21127', '0'),
('1641', '0', '4', '297', '297', '', '0', '189', '19632', '19632', '0'),
('1642', '0', '1', '419', '37', '', '5', '491', '19656', '19866', '0'),
('1643', '0', '1', '115', '115', '', '4', '422', '19678', '19959', '0'),
('1644', '0', '3', '296', '37', '', '4', '534', '19680', '19926', '0'),
('1645', '0', '4', '1153', '692', '', '10', '431', '19698', '20405', '0'),
('1646', '0', '1', '367', '37', '', '21', '589', '19703', '19863', '0'),
('1647', '0', '3', '603', '603', '', '0', '252', '19711', '19711', '0'),
('1648', '0', '4', '1121', '498', '', '36', '2723', '19725', '25354', '0'),
('1649', '0', '5', '419', '222', '', '10', '307', '19731', '20253', '0'),
('1650', '0', '5', '228', '228', '', '9', '680', '19736', '20392', '0'),
('1651', '0', '1', '444', '762', '', '14', '507', '19762', '20629', '0'),
('1654', '0', '10', '115', '115', '', '2', '398', '19784', '19808', '0'),
('1655', '0', '1', '80', '27', '', '3', '341', '19796', '19815', '0'),
('1656', '0', '10', '468', '394', '', '4', '641', '19800', '20788', '0'),
('1657', '0', '1', '803', '419', '', '7', '313', '19817', '19936', '0'),
('1658', '0', '1', '115', '38', '', '3', '214', '19827', '19898', '0'),
('1659', '0', '1', '151', '575', '', '9', '305', '19828', '19909', '0'),
('1660', '0', '1', '151', '1124', '32', '20', '1002', '19838', '21318', '0'),
('1661', '0', '1', '272', '38', '', '2', '297', '19856', '19897', '0'),
('1663', '0', '5', '289', '1138', '', '2', '403', '19867', '20236', '0'),
('1664', '0', '4', '0', '359', '', '2', '205', '19876', '19893', '0'),
('1665', '0', '10', '420', '420', '', '1', '267', '19878', '20106', '0'),
('1666', '0', '1', '447', '222', '', '17', '936', '19881', '20222', '0'),
('1667', '0', '1', '498', '605', '', '9', '308', '19912', '19989', '0'),
('1668', '0', '1', '512', '359', '', '2', '330', '19916', '19988', '0'),
('1669', '0', '1', '145', '125', '', '7', '474', '19931', '20229', '0'),
('1670', '0', '1', '1153', '1153', '', '11', '372', '19932', '20162', '0'),
('1671', '0', '5', '229', '229', '', '0', '243', '19937', '19937', '0'),
('1672', '0', '5', '918', '918', '', '0', '519', '19950', '19950', '0'),
('1673', '0', '4', '560', '344', '', '14', '266', '19952', '20352', '0'),
('1674', '0', '5', '256', '222', '', '204', '3542', '19963', '23397', '0'),
('1675', '0', '10', '262', '297', '', '4', '256', '19974', '20443', '0'),
('1676', '0', '1', '377', '42', '', '124', '4712', '19975', '21863', '0'),
('1677', '0', '1', '560', '27', '', '1', '310', '19995', '20010', '0'),
('1678', '0', '1', '21', '21', '', '0', '180', '19996', '19996', '0'),
('1679', '0', '10', '1203', '1203', '', '3', '687', '20036', '20793', '0'),
('1680', '0', '3', '1203', '1203', '', '2', '516', '20038', '20115', '0'),
('1681', '0', '1', '512', '115', '', '40', '1425', '20040', '20389', '0'),
('1682', '0', '1', '419', '692', '', '81', '3030', '20053', '20810', '0'),
('1684', '0', '5', '297', '211', '', '21', '362', '20096', '21725', '0'),
('1685', '0', '1', '498', '1010', '', '8', '384', '20101', '20281', '0'),
('1686', '0', '10', '78', '78', '', '5', '315', '20148', '20868', '0'),
('1687', '0', '1', '1208', '444', '', '9', '401', '20169', '20640', '0'),
('1688', '0', '4', '981', '981', '', '9', '388', '20194', '21139', '0'),
('1689', '0', '1', '201', '30', '', '9', '559', '20202', '20760', '0');
Caused the error:
Duplicate entry '1410' for key 1

Any idea on what needs to be done?

Thanks

Offline pioner

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.3.x
« Reply #95 on: January 16, 2010, 06:20:12 AM »
hello! I use the converter in the begin of topic, but have a problem..
I try convert ipb2.3.1 to smf_1-1-11. there is logs:

"Converting...
...
Converting settings...
Notice: unserialize() [function.unserialize]: Error at offset 119 of 216 bytes in E:\WebServers\home\172.**.**.13\www\convert.php(941) : eval()'d code on line 45
...
Successful.
Recalculating forum statistics... Successful.

Conversion Complete"


new forum work normally, but I doubt of correctness of converting
please help, thanks

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #96 on: January 17, 2010, 02:55:54 AM »
pioner, the settings aren't converted properly and the converter didn't convert all following steps (attachments, avatars)

I'd recommend to remove this block from invision23_to_smf.sql

Code: [Select]
/******************************************************************************/
--- Converting settings...
/******************************************************************************/

---# Moving settings...
---{
// We will do all updates once we find them all.
$update_settings = array();

$result = convert_query("
SELECT
conf_key AS config_name,
IF(conf_value = '', conf_default, conf_value) AS config_value
FROM {$from_prefix}conf_settings");
while ($row = mysql_fetch_assoc($result))
{
switch ($row['config_name'])
{
case 'board_name':
$inv_forum_name = $row['config_value'];
break;

case 'offline_msg':
$inv_maintenance_message = str_replace("\n", '<br />', $row['config_value']);
break;

case 'hot_topic':
$update_settings['hotTopicPosts'] = $row['config_value'];
break;

case 'display_max_posts':
$update_settings['defaultMaxMessages'] = $row['config_value'];
break;

case 'display_max_topics':
$update_settings['defaultMaxTopics'] = $row['config_value'];
break;

case 'flood_control':
$update_settings['spamWaitTime'] = $row['config_value'];
break;

case 'allow_online_list':
$update_settings['onlineEnable'] = $row['config_value'];
break;

case 'force_login':
break;

default:
break;
}
}
mysql_free_result($result);

$result = convert_query("
SELECT cs_value
FROM {$from_prefix}cache_store
WHERE cs_key = 'stats'");
list ($inv_stats) = mysql_fetch_row($result);
$inv_stats = unserialize($inv_stats);

if (!empty($inv_stats['most_count']) && !empty($inv_stats['most_date']))
{
$update_settings['mostOnline'] = $inv_stats['most_count'];
$update_settings['mostDate'] = $inv_stats['most_date'];
}

// While we coulddo this in one big batch, lets do it one by one.
foreach ($update_settings as $key => $value)
convert_query("
REPLACE INTO {$to_prefix}settings
(variable, value)
VALUES ('" . addslashes($key) . "', '" . addslashes($value) . "')");

updateSettingsFile(array(
'mbname' => '\'' . addcslashes($inv_forum_name, '\'\\') . '\'',
'mmessage' => '\'' . addcslashes($inv_maintenance_message, '\'\\') . '\''
));
---}
---#
this block only converts some basic settings (forum title and such stuff), therefore you can remove it and all important data such as members, posts, topics and the board structure is still converted. after you removed that block from the conveter file you should restart the conversion from the beginning.

Offline pioner

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.3.x
« Reply #97 on: January 17, 2010, 12:52:19 PM »
TE, thanks for help!  it's work.
Last time when i try to convert ipb2.3.1 to smf1.1.11 I have seen errors about converting avatars, as you say :), but forum is working, just copy avatars to the smf directory...  When i try again, and remove that block from invision23_to_smf.sql - but errors has still :( Then I delete avatars at all users, and begin convert again - it's successful done!

Today I tried convert to smf 2.0rc2, and has more errors. Some of them fixed, but one I can't fix, so it was necessary converting to 1.1.11 and upgrade it to 2.0rc2. Thank you for help again! /sorry for my english
« Last Edit: January 17, 2010, 11:45:01 PM by pioner »

Offline Domi5

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 2.3.x
« Reply #98 on: April 19, 2010, 03:51:11 PM »
things seem to run nicely but it stops when it get to posts i guess its caused by Arabic characters

does the converter support latin1 character set?

when the converter asked me for a char set it had a short list .. i chose cp1256

any ideas what to do

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] IPB 2.3.x
« Reply #99 on: April 19, 2010, 05:11:08 PM »
Can you please tell what is the error when it stops or what does it do?

What is the character set in which the original forum database stores posts?
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github