• Welcome to Simple Machines Community Forum. Please login or sign up.
December 02, 2021, 07:44:49 PM

News:

Follow SMF on Twitter.


[SMF Converter] IPB 2.3.x

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

Previous topic - Next topic

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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Tiscan

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


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:

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:
$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.

Quote from: TE on May 23, 2009, 05:12:10 PM
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:

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


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:

---* {$to_prefix}topics 250

replace it with:

---* {$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.....
QuoteSorry, 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'


Christool

Quote from: TE on June 11, 2009, 07:26:08 AM
edit the invision23_to_smf.sql with a text-editor and search for:

---* {$to_prefix}topics 250

replace it with:

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


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


limap5

Thanks.
Managed to convert but came to several errors.

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?:
/home/sbpimnet/public_html/alumni/

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

Advertisement: