[SMF Converter] IPB 2.3.x

[SleePy]

Your image doesn't show the last half of the error message.
Far as I can tell it may be a duplicate key error or there is something that wasn't escaped properly when SMF converter was trying to insert it into the database.

[Tiscan]

Got myself an error trying to convert my IPB 2.3 install... any ideas?

Code Select Expand


Converting...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...
Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-1-1125596689.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1129601073.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1129924461.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1142453192.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-1-1147019334.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1149789666.ipb) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036020.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036030.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036038.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036046.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036054.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036061.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036071.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-9-1152036081.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334535.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334560.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334571.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1158334591.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-17-1163618647.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads/post-7-1164218556.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads//post-1-1170731912.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads//post-17-1173815534.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21

Warning:  copy(/opt/apache2/domains/secure.netmagi.net/htdocs/forums/uploads//post-7-1175548461.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 21
  Successful.
Converting user avatars...
Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-1.png) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-5.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-6.gif) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-7.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-8.png) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-10.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy() [function.copy]: The first argument to copy() function cannot be a directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59

Notice:  Undefined variable: oldAvatarDir in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 58

Warning:  copy(/av-17.jpg) [function.copy]: failed to open stream: No such file or directory in /opt/apache2/domains/secure.netmagi.net/htdocs/smf/convert.php(1097) : eval()'d code on line 59
  Successful.
Recalculating forum statistics...  Successful.
  Conversion Complete Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support. Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the Invision Power Board 2.3 installation.

We hope you had a smooth transition!


[Tiscan]

Ok, so I did some checking... those attachments it is trying to copy don't exist (for some reason) so those are legit errors that can be ignored.

However the avatars not copying is still very strange....

[ThorstenE]

Tiscan, are the old IPB avatars located in the "uploads" folder from IPB?
If yes, you can edit the ipb23_to_smf.sql and replace:

Code Select Expand

if (!isset($oldAttachmentDir))
{
$result = convert_query("
SELECT conf_value
FROM {$from_prefix}conf_settings
WHERE conf_key = 'upload_dir'
LIMIT 1");
list ($oldAvatarDir) = mysql_fetch_row($result);
mysql_free_result($result);

if (empty($oldAttachmentDir) || !file_exists($oldAvatarDir))
$oldAvatarDir = $_POST['path_from'] . '/uploads';
}
with:

Code Select Expand

$oldAvatarDir = $_POST['path_from'] . '/uploads';

[Python000]

Hi.

When mine is in the process of converting posts, it times out.  I've tried it in IE and Google Chrome.  It appears to have converted successfully up until it times out (members and such are converted).  It keeps doing this every time.

Any ideas?  Please help.

[ThorstenE]

Any error messages during the conversion (white page, script stops, internal server error)

[Punk92]

Hi

in my case the conversion procedure has not given problems. When I enter in board, but the part of the forum there isn't, and also part of the area of admin. why?

[ThorstenE]

Punk92,
possibly the Group membership wasn't converted right.. You can restore the Admin privilegues for your Account:
Please check: I accidentally deleted my admin account, what do I do?

[Punk92]

Ok, thanks, now work. But the user avarat there isn't.. how can i resolve?

[Tiscan]

Thanks TE, looking at it this would indeed have fixed it.. however as it was easy to just tell folks to re-load avatars I had already done that.

It would be nice if the converter automatically detected this for older IPB installs.

Tiscan, are the old IPB avatars located in the "uploads" folder from IPB?
If yes, you can edit the ipb23_to_smf.sql and replace:

Code Select Expand

if (!isset($oldAttachmentDir))
{
$result = convert_query("
SELECT conf_value
FROM {$from_prefix}conf_settings
WHERE conf_key = 'upload_dir'
LIMIT 1");
list ($oldAvatarDir) = mysql_fetch_row($result);
mysql_free_result($result);

if (empty($oldAttachmentDir) || !file_exists($oldAvatarDir))
$oldAvatarDir = $_POST['path_from'] . '/uploads';
}
with:

Code Select Expand

$oldAvatarDir = $_POST['path_from'] . '/uploads';

[Punk92]

I've a problem with Attachments.. during the convertition, some files ( img, zip etc ) are to convert correctly, but the greater part Not. the string appears only [attachments: ....].

why?

p.s. also the avatar, but i copy the original img in /avatar,and work.

[Christool]

Hello guys,
I am trying to convert IPB 2.3.6 to SMF 1.1.9 and unfortunately, i get an error mesage :

Code Select Expand


Converting topics... Unsuccessful!
This query:
INSERT INTO `Christoo_ipb`.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 ('331', '0', '28', '190', '20', '', '2', '342', '4795', '4820', '0'),
('332', '0', '6', '58', '58', '', '14', '853', '4828', '5349', '0'),
('333', '0', '10', '313', '61', '', '33', '2701', '4846', '20202', '0'),
('334', '0', '13', '47', '47', '', '13', '167', '4856', '5283', '0'),
('335', '0', '1', '101', '94', '', '62', '1948', '4858', '7558', '0'),
('336', '0', '1', '4', '0', '', '4', '380', '4890', '5741', '0'),
('338', '0', '13', '113', '113', '', '31', '520', '4912', '5406', '0'),
('339', '0', '28', '151', '334', '', '9', '580', '4958', '6847', '0'),
('340', '0', '95', '269', '37', '', '8', '263', '4978', '6409', '0'),
('341', '0', '1', '9', '19', '', '6', '387', '5003', '5018', '0'),
('342', '0', '2', '47', '2', '', '7', '356', '5013', '5379', '0'),
('343', '0', '6', '65', '88', '', '9', '336', '5028', '5293', '0'),
('344', '0', '1', '319', '309', '', '13', '625', '5066', '6314', '0'),
('345', '0', '10', '27', '309', '', '8', '494', '5071', '6318', '0'),
('346', '0', '1', '98', '0', '', '15', '817', '5090', '5737', '0'),
('347', '0', '1', '167', '99', '', '32', '1373', '5104', '5691', '0'),
('348', '0', '28', '98', '99', '', '5', '404', '5110', '5538', '0'),
('349', '0', '28', '320', '47', '', '13', '476', '5123', '6988', '0'),
('350', '0', '6', '160', '317', '', '4', '352', '5127', '5257', '0'),
('351', '0', '1', '237', '81', '', '17', '890', '5139', '5299', '0'),
('352', '0', '8', '240', '455', '', '6', '1445', '5184', '11309', '0'),
('353', '0', '10', '5', '4', '11', '10', '700', '5218', '5712', '0'),
('354', '0', '95', '25', '25', '', '0', '128', '5221', '5221', '0'),
('356', '0', '28', '324', '90', '', '2', '395', '5230', '5844', '0'),
('357', '0', '10', '274', '150', '', '12', '609', '5260', '6256', '0'),
('358', '0', '8', '167', '603', '', '25', '1802', '5261', '70379', '0'),
('359', '0', '6', '47', '65', '', '6', '330', '5297', '6541', '0'),
('360', '0', '28', '47', '192', '', '20', '2096', '5337', '6439', '0'),
('361', '0', '28', '112', '90', '', '2', '259', '5405', '5846', '0'),
('362', '0', '10', '32', '112', '', '9', '520', '7068', '8243', '0'),
('363', '0', '95', '77', '103', '', '14', '456', '5366', '5991', '0'),
('365', '0', '1', '47', '397', '', '3', '257', '5334', '10205', '0'),
('367', '0', '1', '0', '78', '', '7', '667', '5354', '5468', '0'),
('370', '0', '28', '219', '32', '', '33', '2632', '5374', '8041', '0'),
('375', '0', '6', '81', '644', '', '21', '618', '5386', '4370006', '0'),
('376', '0', '14', '2', '2', '', '150', '1702', '5392', '6019', '0'),
('377', '0', '28', '331', '249', '', '12', '737', '5432', '6145', '0'),
('378', '0', '1', '332', '41', '', '4', '429', '5434', '10914', '0'),
('379', '0', '1', '25', '152', '', '14', '868', '5435', '5701', '0'),
('380', '0', '28', '326', '326', '', '3', '319', '5451', '5651', '0'),
('381', '0', '28', '112', '151', '', '68', '5738', '5476', '8752', '0'),
('383', '0', '10', '78', '78', '', '13', '601', '5487', '6411', '0'),
('384', '0', '17', '208', '208', '', '52', '2421', '5566', '35355', '0'),
('385', '0', '16', '213', '361', '', '3', '661', '5571', '6683', '0'),
('386', '0', '6', '14', '668', '', '12', '688', '5615', '29063', '0'),
('387', '0', '28', '143', '132', '', '18', '1275', '5647', '8051', '0'),
('388', '0', '28', '51', '131', '', '8', '481', '5680', '5974', '0'),
('390', '0', '13', '131', '112', '', '33', '585', '5700', '6285', '0'),
('391', '0', '28', '152', '6', '', '11', '585', '5705', '6121', '0'),
('392', '0', '10', '331', '4', '', '18', '616', '5724', '10166', '0'),
('393', '0', '10', '0', '0', '', '3', '356', '5725', '9208', '0'),
('394', '0', '28', '344', '581', '', '20', '1107', '5750', '15752', '0'),
('395', '0', '8', '74', '41', '', '30', '1922', '5778', '26343', '0'),
('396', '0', '10', '124', '1224', '', '51', '2483', '5812', '4377808', '0'),
('397', '0', '1', '25', '25', '', '1', '262', '5850', '5851', '0'),
('398', '0', '28', '229', '1811', '', '17', '1223', '5857', '4440898', '0'),
('399', '0', '28', '88', '29', '', '14', '596', '5890', '6477', '0'),
('400', '0', '28', '9', '625', '', '21', '757', '5898', '57041', '0'),
('401', '0', '2', '0', '2337', '', '5', '735', '5911', '4370284', '0'),
('402', '0', '28', '277', '277', '', '18', '1384', '5944', '6316', '0'),
('403', '0', '28', '192', '90', '', '5', '378', '5957', '6066', '0'),
('404', '0', '28', '125', '428', '', '39', '1643', '5999', '57423', '0'),
('405', '0', '1', '112', '78', '', '17', '559', '6008', '6325', '0'),
('406', '0', '1', '0', '665', '', '50', '1294', '6064', '62790', '0'),
('407', '0', '28', '241', '241', '', '0', '197', '6076', '6076', '0'),
('408', '0', '10', '259', '151', '', '27', '1028', '6088', '26241', '0'),
('410', '0', '6', '6', '60', '', '49', '2123', '6124', '10527', '0'),
('411', '0', '1', '169', '81', '', '10', '436', '6144', '9158', '0'),
('412', '0', '10', '60', '135', '', '15', '704', '6161', '9278', '0'),
('413', '0', '1', '38', '112', '', '39', '1498', '6166', '8342', '0'),
('414', '0', '2', '14', '14', '', '4', '303', '6174', '7763', '0'),
('415', '0', '28', '353', '440', '', '8', '340', '6199', '4314244', '0'),
('423', '0', '28', '48', '57', '', '1', '289', '6218', '6272', '0'),
('424', '0', '1', '249', '19', '', '19', '765', '6219', '6609', '0'),
('425', '0', '1', '356', '356', '', '19', '530', '6224', '21078', '0'),
('426', '0', '95', '285', '277', '', '15', '792', '6270', '15916', '0'),
('427', '0', '28', '285', '75', '', '42', '3603', '6287', '8184', '0'),
('428', '0', '1', '357', '357', '', '0', '281', '6310', '6310', '0'),
('429', '0', '28', '143', '143', '', '2', '388', '6342', '6594', '0'),
('430', '0', '28', '75', '75', '', '4', '444', '6356', '6420', '0'),
('431', '0', '13', '138', '138', '', '20', '184', '6367', '7585', '0'),
('432', '0', '1', '29', '29', '', '34', '1560', '6393', '9916', '0'),
('433', '0', '13', '361', '112', '', '35', '483', '6395', '8593', '0'),
('434', '0', '1', '13', '13', '', '4', '305', '6400', '6537', '0'),
('435', '0', '8', '167', '240', '', '12', '1356', '6404', '7882', '0'),
('436', '0', '95', '25', '25', '', '2', '230', '6406', '6829', '0'),
('437', '0', '8', '167', '125', '', '2', '794', '6407', '6471', '0'),
('438', '0', '28', '363', '363', '', '2', '357', '6433', '7828', '0'),
('439', '0', '1', '101', '38', '', '14', '634', '6469', '6562', '0'),
('440', '0', '28', '274', '23', '', '11', '479', '6505', '7454', '0'),
('441', '0', '10', '114', '309', '', '1', '208', '6515', '6626', '0'),
('442', '0', '2', '98', '33', '', '11', '624', '6540', '9528', '0'),
('443', '0', '28', '346', '237', '', '1', '253', '6548', '6550', '0'),
('444', '0', '28', '219', '90', '', '7', '344', '6566', '6667', '0'),
('445', '0', '1', '51', '56', '', '14', '667', '6571', '6617', '0'),
('446', '0', '28', '51', '92', '', '1', '229', '6572', '6584', '0'),
('447', '0', '28', '39', '107', '', '21', '733', '6573', '38078', '0'),
('448', '0', '8', '29', '455', '', '30', '2876', '6591', '64344', '0'),
('449', '0', '8', '29', '455', '', '3', '965', '6592', '11495', '0'),
('450', '0', '10', '369', '1023', '', '25', '868', '6610', '50128', '0'),
('451', '0', '28', '143', '61', '', '9', '518', '6616', '7597', '0'),
('452', '0', '28', '249', '377', '', '5', '423', '6622', '8179', '0'),
('457', '0', '95', '61', '508', '', '5', '203', '6640', '12181', '0'),
('458', '0', '1', '355', '355', '', '51', '1757', '6641', '11976', '0'),
('459', '0', '1', '61', '6800', '14', '153', '20097', '6643', '4561475', '0'),
('460', '0', '28', '61', '435', '', '1', '242', '6653', '9742', '0'),
('461', '0', '1', '361', '13', '', '2', '228', '6707', '6720', '0'),
('462', '0', '17', '29', '477', '', '4', '337', '6749', '11476', '0'),
('463', '0', '95', '74', '20', '', '37', '1309', '6701', '10856', '0'),
('464', '0', '17', '259', '231', '', '17', '825', '6706', '4323631', '0'),
('465', '0', '14', '0', '2', '', '38', '615', '6712', '7883', '0'),
('466', '0', '13', '309', '377', '', '4', '93', '6726', '7172', '0'),
('467', '0', '13', '259', '2', '', '5', '52', '6731', '7704', '0'),
('468', '0', '10', '269', '61', '', '1', '317', '6735', '7041', '0'),
('469', '0', '1', '65', '240', '', '9', '592', '6737', '7712', '0'),
('470', '0', '6', '29', '127', '', '28', '742', '6807', '7059', '0'),
('471', '0', '28', '283', '283', '', '0', '213', '6811', '6811', '0'),
('472', '0', '1', '29', '29', '', '31', '1062', '6840', '8176', '0'),
('473', '0', '13', '138', '112', '', '25', '134', '6854', '7604', '0'),
('474', '0', '1', '290', '1218', '', '85', '2268', '6857', '66110', '0'),
('475', '0', '1', '342', '342', '', '5', '405', '6891', '7436', '0'),
('476', '0', '28', '375', '26', '', '16', '918', '6961', '8851', '0'),
('477', '0', '28', '179', '190', '', '2', '262', '6970', '7043', '0'),
('478', '0', '1', '254', '254', '', '5', '344', '6977', '8909', '0'),
('479', '0', '6', '17', '16', '', '1', '177', '6985', '7080', '0'),
('480', '0', '13', '377', '2', '', '38', '308', '7013', '7702', '0'),
('482', '0', '28', '160', '435', '', '2', '362', '7015', '9740', '0'),
('483', '0', '28', '94', '435', '', '27', '1616', '7040', '14403', '0'),
('484', '0', '1', '269', '106', '', '1', '257', '7051', '7132', '0'),
('485', '0', '13', '379', '44', '', '16', '213', '7066', '8854', '0'),
('486', '0', '6', '6', '240', '', '10', '367', '7072', '7708', '0'),
('487', '0', '1', '47', '23', '', '15', '636', '7121', '7652', '0'),
('488', '0', '10', '85', '60', '', '11', '528', '7123', '7459', '0'),
('496', '0', '2', '2', '20', '', '5', '397', '7206', '7836', '0'),
('497', '0', '1', '25', '0', '', '14', '625', '7220', '7410', '0'),
('499', '0', '1', '200', '200', '', '0', '177', '7235', '7235', '0'),
('500', '0', '28', '265', '16', '', '5', '481', '7248', '8017', '0'),
('501', '0', '6', '47', '142', '', '11', '522', '7250', '8281', '0'),
('502', '0', '1', '254', '2', '', '22', '887', '7268', '8294', '0'),
('503', '0', '28', '44', '112', '', '14', '632', '7269', '7458', '0'),
('504', '0', '6', '29', '20', '', '65', '1380', '7280', '42580', '0'),
('505', '0', '2', '237', '90', '', '6', '439', '7287', '51462', '0'),
('506', '0', '2', '7', '160', '', '40', '2872', '7298', '9836', '0'),
('507', '0', '28', '114', '205', '', '6', '387', '7308', '12838', '0'),
('508', '0', '1', '114', '20', '', '41', '2698', '7310', '4389714', '0'),
('511', '0', '10', '112', '112', '', '15', '746', '7390', '8968', '0'),
('512', '0', '1', '269', '16', '', '19', '684', '7409', '8543', '0'),
('513', '0', '95', '269', '4', '', '1', '163', '7416', '8029', '0'),
('514', '0', '95', '269', '58', '', '1', '190', '7418', '7593', '0'),
('515', '0', '1', '29', '361', '', '2', '266', '7425', '7495', '0'),
('516', '0', '28', '60', '60', '', '2', '456', '7460', '7567', '0'),
('517', '0', '1', '2', '361', '', '15', '592', '7469', '7577', '0'),
('518', '0', '8', '167', '140', '', '9', '1065', '7479', '7839', '0'),
('519', '1', '14', '0', '1229', '', '29', '1081', '7483', '62703', '0'),
('520', '0', '1', '385', '13', '', '1', '233', '7496', '7528', '0'),
('521', '0', '1', '224', '966', '', '25', '2887', '7506', '4336232', '0'),
('522', '0', '17', '224', '477', '', '14', '2925', '7516', '11041', '0'),
('523', '0', '1', '219', '1546', '', '11', '1417', '7536', '4323728', '0'),
('524', '0', '1', '60', '60', '', '1', '215', '7563', '7565', '0'),
('525', '0', '28', '60', '2182', '', '14', '722', '7566', '4380730', '0'),
('526', '0', '28', '88', '131', '', '6', '354', '7583', '8979', '0'),
('527', '0', '8', '167', '73', '', '4', '555', '7588', '7770', '0'),
('528', '0', '1', '198', '198', '', '13', '693', '7591', '8301', '0'),
('529', '0', '10', '346', '99', '', '11', '657', '7598', '8984', '0'),
('530', '0', '1', '2', '47', '', '47', '1430', '7608', '8218', '0'),
('531', '0', '28', '297', '297', '', '2', '411', '7612', '7944', '0'),
('532', '0', '1', '29', '361', '', '9', '383', '7628', '8359', '0'),
('533', '0', '1', '0', '19', '', '57', '1731', '7634', '12197', '0'),
('534', '0', '13', '202', '44', '', '14', '158', '7640', '8855', '0'),
('535', '0', '28', '202', '161', '', '13', '461', '7657', '12792', '0'),
('536', '0', '1', '101', '74', '', '3', '264', '7666', '11748', '0'),
('537', '0', '13', '47', '377', '', '12', '316', '7673', '8438', '0'),
('539', '0', '10', '179', '99', '', '25', '1785', '7722', '22617', '0'),
('540', '0', '1', '74', '196', '', '75', '2998', '7724', '9688', '0'),
('541', '0', '1', '205', '140', '', '7', '401', '7750', '7801', '0'),
('542', '0', '6', '47', '17', '', '4', '268', '7756', '7788', '0'),
('543', '0', '1', '205', '47', '', '1', '245', '7765', '7767', '0'),
('544', '0', '6', '143', '143', '', '0', '172', '7777', '7777', '0'),
('545', '0', '28', '236', '125', '', '4', '405', '7794', '8156', '0'),
('546', '0', '13', '389', '79', '', '17', '140', '7798', '8423', '0'),
('547', '0', '28', '219', '219', '', '6', '363', '7841', '32385', '0'),
('548', '0', '10', '51', '202', '', '5', '511', '7843', '10019', '0'),
('549', '0', '10', '85', '88', '', '7', '492', '7854', '8096', '0'),
('550', '0', '1', '61', '16', '16', '41', '1184', '7863', '8417', '0'),
('551', '0', '1', '61', '141', '', '3', '172', '7864', '8412', '0'),
('552', '0', '1', '29', '61', '', '2', '261', '7867', '7937', '0'),
('554', '0', '28', '143', '18', '', '5', '612', '7894', '9563', '0'),
('556', '0', '1', '127', '11', '', '25', '1049', '7911', '8384', '0'),
('557', '0', '28', '393', '343', '', '2', '429', '7943', '8349', '0'),
('558', '0', '28', '25', '25', '', '5', '296', '7958', '8104', '0'),
('559', '0', '1', '0', '72', '', '62', '1672', '7990', '9317', '0'),
('560', '0', '28', '186', '186', '', '4', '437', '7994', '8748', '0'),
('561', '0', '1', '196', '199', '', '22', '794', '8001', '8948', '0'),
('562', '0', '13', '132', '603', '', '25', '207', '8063', '31803', '0'),
('563', '0', '28', '31', '26', '', '10', '470', '8064', '8540', '0'),
('564', '0', '1', '269', '37', '', '7', '432', '8103', '8198', '0'),
('565', '0', '1', '377', '398', '', '34', '1320', '8166', '8931', '0'),
('566', '0', '1', '29', '290', '', '10', '495', '8169', '8368', '0'),
('567', '0', '1', '17', '2', '', '58', '1515', '8229', '4509395', '0'),
('568', '0', '1', '17', '78', '', '31', '642', '8244', '33547', '0'),
('569', '0', '1', '151', '151', '', '12', '511', '8274', '8747', '0'),
('570', '0', '6', '47', '88', '', '1', '170', '8284', '8934', '0'),
('571', '0', '95', '184', '52', '', '11', '450', '8300', '10047', '0'),
('572', '0', '95', '398', '248', '', '2', '167', '8387', '8674', '0'),
('573', '0', '13', '398', '23', '', '19', '276', '8397', '8865', '0'),
('574', '0', '1', '29', '406', '', '23', '964', '8403', '9117', '0'),
('575', '0', '10', '259', '114', '', '8', '506', '8444', '8639', '0'),
('576', '0', '1', '103', '17', '', '2', '199', '8522', '8525', '0'),
('577', '0', '10', '17', '17', '', '14', '743', '8517', '9292', '0'),
('578', '0', '1', '2', '454', '', '20', '642', '8529', '10059', '0'),
('579', '0', '28', '352', '352', '', '43', '1387', '8544', '10676', '0'),
('580', '0', '1', '97', '81', '', '50', '903', '8571', '10957', '0'),
('581', '0', '28', '287', '205', '', '6', '421', '8580', '9199', '0'),
('582', '0', '1', '4', '99', '', '7', '262', '8595', '8764', '0'),
('583', '0', '13', '406', '377', '', '7', '113', '8601', '8663', '0'),
('584', '0', '1', '101', '342', '', '31', '1098', '8608', '9527', '0'),
('585', '0', '28', '143', '6', '', '4', '440', '8619', '8649', '0'),
('586', '0', '28', '407', '407', '', '16', '693', '8620', '9188', '0'),
('587', '0', '8', '6', '151', '', '4', '750', '8621', '8750', '0'),
('588', '0', '28', '6', '6', '', '0', '214', '8632', '8632', '0'),
('589', '0', '13', '407', '112', '', '17', '186', '8641', '9058', '0'),
('590', '0', '1', '125', '125', '', '9', '363', '8681', '9191', '0'),
('591', '0', '28', '248', '237', '', '3', '440', '8683', '8814', '0'),
('592', '0', '10', '68', '498', '', '20', '1049', '8724', '13681', '0'),
('593', '0', '28', '219', '140', '', '10', '476', '8728', '9148', '0'),
('594', '0', '28', '410', '14', '', '14', '646', '8730', '12355', '0'),
('595', '0', '95', '411', '411', '', '0', '154', '8738', '8738', '0'),
('597', '0', '28', '412', '283', '', '5', '402', '8744', '8997', '0'),
('598', '0', '8', '151', '151', '', '5', '826', '8762', '9019', '0'),
('599', '0', '8', '205', '167', '', '3', '582', '8768', '8872', '0'),
('600', '0', '10', '44', '140', '', '3', '340', '8780', '8799', '0'),
('601', '0', '10', '2', '2', '', '41', '1987', '8783', '14864', '0'),
('602', '0', '28', '414', '552', '', '2', '220', '8806', '13566', '0'),
('603', '0', '28', '406', '192', '', '8', '369', '8810', '9542', '0'),
('604', '0', '1', '101', '233', '', '17', '569', '8825', '10640', '0'),
('605', '0', '10', '407', '407', '', '3', '372', '8846', '9189', '0'),
('606', '0', '28', '50', '85', '', '5', '333', '8861', '9013', '0'),
('607', '0', '95', '5', '17', '', '4', '269', '8899', '9290', '0'),
('608', '0', '1', '85', '61', '', '1', '113', '8903', '8905', '0'),
('609', '0', '10', '61', '397', '', '4', '292', '8910', '9492', '0'),
('610', '0', '10', '61', '140', '', '3', '300', '8911', '13268', '0'),
('612', '0', '1', '233', '140', '', '13', '386', '8925', '9415', '0'),
('613', '0', '1', '88', '88', '', '8', '428', '8936', '9765', '0'),
('614', '0', '10', '78', '78', '', '9', '399', '8943', '10209', '0'),
('615', '0', '28', '51', '51', '', '4', '363', '8946', '9088', '0'),
('616', '0', '1', '92', '0', '', '15', '728', '8947', '9315', '0'),
('617', '0', '28', '421', '362', '', '26', '1211', '8978', '12369', '0'),
('618', '0', '1', '4', '75', '', '52', '1142', '8982', '4313467', '0'),
('619', '0', '28', '131', '181', '', '39', '1259', '8986', '4330721', '0'),
('620', '0', '1', '112', '172', '', '30', '892', '9034', '10118', '0');
Caused the error:

Duplicate entry '331' for key 1


Can anyone help me please ?

[ThorstenE]

edit the invision23_to_smf.sql with a text-editor and search for:

Code Select Expand

---* {$to_prefix}topics 250

replace it with:

Code Select Expand

---* {$to_prefix}topics 250
---{
$ignore = true;
---}
Then restart the conversion..

[anantgupta]

got ths error while converting my forum

plz help

plz gve whole details hw to convert.....

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.3. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'forum_smf'@'92.867.546.235' for table 'ibf_members'

[ThorstenE]

see Common conversion errors.

[Christool]

edit the invision23_to_smf.sql with a text-editor and search for:

Code Select Expand

---* {$to_prefix}topics 250

replace it with:

Code Select Expand

---* {$to_prefix}topics 250
---{
$ignore = true;
---}
Then restart the conversion..

Hello Te,
Thank you for your help, it is ok now using your fix.

[limap5]

I got this error,

Code Select Expand



Invision Power Board 2.3 to SMF Converter
Converting...
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...
Fatal error: Call to undefined function getAttachmentFilename() in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 20

IPB v 2.3.6 to SMF 1.1.9

What is the problem? I could not finish the conversion.

[ThorstenE]

please use the converter from our downloads page instead: (direct link)
http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-9_invision23_converter.zip

[limap5]

Thanks.
Managed to convert but came to several errors.

Code Select Expand


Converting...
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...
Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_01_2008/post-51-1200583554.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21

Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202632069.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21

Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202633527.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21

Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202634247.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21

Warning: copy(/home/sbpimnet/public_html/alumni/v1/uploads/monthly_02_2008/post-77-1202635307.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 21
Successful.
Converting user avatars...
Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-2.gif) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-7.gif) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-15.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-40.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-43.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-77.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59

Notice: Undefined variable: oldAvatarDir in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 58

Warning: copy(/av-201.jpg) [function.copy]: failed to open stream: No such file or directory in /home/sbpimnet/public_html/alumni/convert.php(1097) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.

[ThorstenE]

I believe you used this path during conversion?:

Code Select Expand

/home/sbpimnet/public_html/alumni/

please try

Code Select Expand

/home/sbpimnet/public_html/alumni
(without trailing slash)