Advertisement:

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

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,333
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.3.x
« Reply #60 on: April 09, 2009, 06:58:00 PM »
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

Offline Tiscan

  • Semi-Newbie
  • *
  • Posts: 38
Re: [SMF Converter] IPB 2.3.x
« Reply #61 on: May 22, 2009, 07:27:09 PM »
Got myself an error trying to convert my IPB 2.3 install... any ideas?

Code: [Select]
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!

Offline Tiscan

  • Semi-Newbie
  • *
  • Posts: 38
Re: [SMF Converter] IPB 2.3.x
« Reply #62 on: May 22, 2009, 07:36:30 PM »
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

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

Code: [Select]
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]
$oldAvatarDir = $_POST['path_from'] . '/uploads';

Offline Python000

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #64 on: May 29, 2009, 02:34:52 AM »
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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #65 on: May 30, 2009, 02:02:02 AM »
Any error messages during the conversion (white page, script stops, internal server error) ???

Offline Punk92

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.3.x
« Reply #66 on: May 31, 2009, 05:41:33 AM »
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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #67 on: May 31, 2009, 06:20:25 AM »
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?

Offline Punk92

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.3.x
« Reply #68 on: May 31, 2009, 07:15:54 AM »
Ok, thanks, now work. But the user avarat there isn't.. how can i resolve?

Offline Tiscan

  • Semi-Newbie
  • *
  • Posts: 38
Re: [SMF Converter] IPB 2.3.x
« Reply #69 on: May 31, 2009, 01:14:39 PM »
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]
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]
$oldAvatarDir = $_POST['path_from'] . '/uploads';

Offline Punk92

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.3.x
« Reply #70 on: June 03, 2009, 07:47:44 AM »
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.

Offline Christool

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.3.x
« Reply #71 on: June 11, 2009, 05:57:03 AM »
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]
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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #72 on: June 11, 2009, 07:26:08 AM »
edit the invision23_to_smf.sql with a text-editor and search for:

Code: [Select]
---* {$to_prefix}topics 250
replace it with:

Code: [Select]
---* {$to_prefix}topics 250
---{
$ignore = true;
---}
Then restart the conversion..

Offline anantgupta

  • Jr. Member
  • **
  • Posts: 101
Re: [SMF Converter] IPB 2.3.x
« Reply #73 on: June 12, 2009, 01:36:44 PM »
got ths error while converting my forum

plz help

plz gve whole details hw to convert.....
Quote
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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #74 on: June 13, 2009, 01:47:30 AM »

Offline Christool

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.3.x
« Reply #75 on: June 16, 2009, 12:54:17 PM »
edit the invision23_to_smf.sql with a text-editor and search for:

Code: [Select]
---* {$to_prefix}topics 250
replace it with:

Code: [Select]
---* {$to_prefix}topics 250
---{
$ignore = true;
---}
Then restart the conversion..

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

Offline limap5

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.3.x
« Reply #76 on: June 26, 2009, 08:20:00 AM »
I got this error,
Code: [Select]

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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #77 on: June 26, 2009, 02:42:57 PM »
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



Offline limap5

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.3.x
« Reply #78 on: June 27, 2009, 10:11:25 AM »
Thanks.
Managed to convert but came to several errors.
Code: [Select]
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

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #79 on: June 27, 2009, 12:37:25 PM »
I believe you used this path during conversion?:
Code: [Select]
/home/sbpimnet/public_html/alumni/
please try
Code: [Select]
/home/sbpimnet/public_html/alumni (without trailing slash)