[SMF Converter] IPB 2.3.x

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

Previous topic - Next topic

Python000

Quote from: TE on May 30, 2009, 02:02:02 AM
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?

SleePy

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

Python000

Quote from: SleePy 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?
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!

Python000

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

please try to decrease the number of concurrent converted messages..

edit the invision23_to_smf.sql

find:

---* {$to_prefix}messages 200

replace it with:

---* {$to_prefix}messages 100

then restart the conversion.

Python000

Quote from: TE 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:

---* {$to_prefix}messages 200

replace it with:

---* {$to_prefix}messages 100

then 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

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

#87
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

Smoerble

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?

Metalltony

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

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.

QuoteRecalculating forum statistics... Successful.

Alpha120

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
    hxxp:m.id [nonactive] 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, hxxp:m.email [nonactive]_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 = hxxp:me.id [nonactive])
    LEFT JOIN `fuertota_ctrlz`.ibf_members_converge AS mc ON (m.id = mc.converge_id)
    WHERE hxxp:m.id [nonactive] != 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.

Norv

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

Alpha120

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 :)

adamc72

Hi,

Happy New Year. I am trying to convert my IPB2.3.6 to SMF1.1.11 and get the following error:
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

pioner

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

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

/******************************************************************************/
--- 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.

pioner

#97
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

Domi5

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

Norv

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

Advertisement: