[SMF Converter] Yabb - 2.1

[kelltech]

Hi Jay-I've been working like crazy lately. Any chance to look into those errors? I've not had any luck with a conversion, still getting the same error.

[JayBachatero]

I've been real busy with school and work lately.  I'll try to take a look at this for you when I get a chance.

[joshua2001]

Hello. I have used the converter of yabb21 to SMF. Perfect one became all, the users, post, etc, but they do not appear to me topics in the forum.

What can be? Please, helpme. Thanks.

In the beginning it gives an error me:

Converting membergroups... Successful.
Converting members...
Notice: Undefined index: password in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 308

Notice: Undefined index: password in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 308

Notice: Undefined index: email in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 310

Notice: Undefined index: postcount in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 314

Notice: Undefined index: userpic in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/yabb21_to_smf.php on line 322
Incomplete.

When finalizing the conversion gives the following error me:

Converting...

Notice: Undefined index: convert_script in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 580

Warning: Invalid argument supplied for foreach() in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 583

Notice: Undefined index: convert_script in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 588
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 935

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 945

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 953

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 963

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 976

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 989

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1035

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1037

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1043

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1049

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1060

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1061

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1069

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1071

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1077

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1078

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1084

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1085

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1109

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1111

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1117

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1129

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1154

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1156

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1192

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1193

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1231

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1236

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1297

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1299

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1335

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1354

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1827

Notice: Undefined variable: result in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1377

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1378
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.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the
Notice: Undefined index: name in /www/docs/bebesenlaweb.com.ar/public_html/forosbb/convert.php on line 1454
installation.

We hope you had a smooth transition!



After the conversion the forum is just as when installing it. I must make a reconteo of the forum so that they appear the users, but post does not appear. Excuse my English.
what can be?

[dumbelljunkie]

About half the posts imported from Yabb 2.1 are not linked to users, so they appear as guests. But the other half works nicely. It's not really a problem to me, but can it be fixed manually ?

[JayBachatero]

Did you try reconverting again?

[kelltech]

Hi Jay, thanks for working on that-I appreciate your time. I tried a clean install and a clean convert and got the 'poll votes' error again:

Converting poll votes... Unsuccessful!
This query:

    ALTER TABLE `american_smf1`.smf_poll_choices
    ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:

    Duplicate entry '16777215-0' for key 1

So I thought I'd pass on what mods are installed, I don't know if it makes a difference:
    * Quick Reply Box
    * Link IP Mod
    * YaBB 2 Backup
    * Distilled Email Domains

Thanks again, whenever you get a chance to take a look, no rush. Have a good weekend :-)

Just thought I'd check for any progress on this error-still getting the same error on a fresh install & convert attempt. Thanks for any help!

[nam37]

Could someone help me with the issue at: http://www.simplemachines.org/community/index.php?topic=165586.0

Thanks in advanced.

[msbean]

Will this converter keep the looks of the yabb forum like the colors I put for a theme or will I have to do the theme all over again?

[Mr. Bean]

Will this converter keep the looks of the yabb forum like the colors I put for a theme or will I have to do the theme all over again?

AFAIK the converter wont convert your theme over since they are not compatible.  You will have to convert it manually.

[tmgtim]

hi, Anyone know why the yabb > smf1.1.2 converters in the donwloads section are just empty zip files - am I missing something ?
Thanks

[Mr. Bean]

Those files are out of date AFAIK.  You should use the one's in this topic.

[backyard]

I'm trying to convert a forum and I get this error.

Code Select Expand

Converting poll votes... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE)
    VALUES ('3', '2203', '5'),
    ('3', '0', '6'),
    ('3', '0', '6'),
    ('3', '0', '4'),
    ('3', '0', '5'),
    ('3', '0', '3'),
    ('3', '0', '1'),
    ('3', '0', '2'),
    ('3', '0', '6'),
    ('3', '0', '0'),
    ('3', '0', '0'),
    ('3', '0', '6'),
    ('3', '0', '5'),
    ('3', '0', '0'),
    ('3', '0', '5'),
    ('3', '0', '1'),
    ('3', '0', '5'),
    ('3', '2647', '3'),
    ('3', '0', '1'),
    ('3', '0', '3'),
    ('3', '0', '1'),
    ('3', '0', '3'),
    ('3', '0', '3'),
    ('3', '2538', '1'),
    ('3', '0', '3'),
    ('3', '0', '1'),
    ('3', '0', '1'),
    ('3', '0', '1'),
    ('3', '0', '2'),
    ('3', '0', '5'),
    ('3', '0', '3'),
    ('3', '0', '1'),
    ('3', '0', '1'),
    ('3', '0', '3'),
    ('3', '0', '3'),
    ('3', '0', '3'),
    ('3', '0', '3'),
    ('3', '0', '0'),
    ('3', '531', '1'),
    ('3', '0', '1'),
    ('3', '0', '1'),
    ('3', '0', '3'),
    ('3', '0', '3'),
    ('3', '0', '6'),
    ('3', '1839', '3'),
    ('3', '0', '1'),
    ('3', '0', '4'),
    ('3', '0', '0'),
    ('3', '2517', '6'),
    ('3', '1539', '3'),
    ('3', '0', '1'),
    ('3', '0', '4'),
    ('3', '0', '1'),
    ('3', '0', '1'),
    ('3', '0', '3'),
    ('3', '0', '1'),
    ('3', '2172', '3'),
    ('3', '0', '3'),
    ('3', '0', '1'),
    ('3', '0', '3'),
    ('3', '2495', '1'),
    ('3', '0', '6'),
    ('3', '0', '6'),
    ('3', '0', '3'),
    ('3', '1318', '3'),
    ('3', '0', '6'),
    ('3', '2328', '1'),
    ('3', '0', '4'),
    ('3', '0', '6'),
    ('3', '2485', '5'),
    ('3', '1', '1'),
    ('3', '1520', '1'),
    ('3', '2', '1');

Caused the error:

    Duplicate entry '3-2203-5' for key 1

Anyone know how to fix this?

[backyard]

Okay, I figured out how to get past this issue. I just deleted the postnumber.poll and .polled files. The problem I'm having now is that the username registration date didn't carry over on the conversion and it's making most of my members as deleted guests thus no profile. Anyone know how to fix this?

[ShawnD]

Hello All, Im considering converting my Yabb , And would like to know if there is any help available should I need It, Being a complete muppet at this sort of thing...Thought I had best ask first...

Thankyou in advance..

Shawn

[vmpre2]

Allrighty

Anyone provide any clues on this error?

Converting attachments (if the mod is installed)...
Warning: getimagesize() [function.getimagesize]: Read error! in /home/u4/personal/html/yabb_convert4/yabb21_to_smf.php on line 1378
Unsuccessful!
This query:

    INSERT INTO `smf_db`.convert4attachments
    (ID_ATTACH, size, downloads, filename, ID_MSG, width, height)
    VALUES
    (1, 16894, 0, 'hummer.jpg', 43, 400, 290),
    (2, 68865, 0, 'JAM_022604_A.JPG', 266, 380, 472),
    (3, 37564, 0, 'diego3.jpg', 456, 320, 237),
    (4, 52672, 0, 'BoulderSunset.JPG', 460, 736, 552),
    (5, 66746, 0, 'DSCF0002.JPG', 1481, 800, 600),
    (6, 57915, 0, 'dogs.jpg', 1797, 448, 293),
    (7, 47256, 0, 'SLAssn6-30-04.jpg', 2215, 500, 646),
    (8, 53363, 0, 'tequila1.1.JPG', 2291, 626, 943),
    (9, 45553, 0, 'backyard_rink1.jpg', 2389, 640, 427),
    (10, 23341, 0, 'bluebig.jpg', 2720, 400, 300),
    (11, 45146, 0, 'bluejack.jpg', 2721, 480, 640),
    (12, 40505, 0, 'Free_Dog.jpg', 2756, 555, 600),
    (13, 72410, 0, 'MENBLUE.GIF', 2809, 353, 336),
    (14, 106911, 0, 'Jaxy.JPG', 2894, 872, 1158),
    (15, 50905, 0, 'cop.jpg', 3231, 432, 316),
    (16, 35349, 0, 'chris_and_tequila_2.JPG', 3324, 533, 360),
    (17, 196548, 0, 'silverstone_lake_morning_fall_04.JPG', 4030, 720, 540),
    (18, 158555, 0, 'September_2004_022.jpg', 4072, 640, 480),
    (19, 135902, 0, 'September_2004_023.jpg', 4073, 640, 480),
    (20, 156030, 0, 'September_2004_024.jpg', 4074, 640, 480),
    (21, 17454, 0, 'dishDiagram.gif', 4104, 814, 562),
    (22, 43809, 0, 'dish4.jpg', 4107, 633, 466),
    (23, 21179, 0, 'dish2.jpg', 4108, 504, 347),
    (24, 153511, 0, 'October_04_005.jpg', 4262, 640, 480),
    (25, 36674, 0, 'owl3.JPG', 4325, 640, 425),
    (26, 51543, 0, 'future.jpg', 4358, 575, 349),
    (27, 89967, 0, 'golf.jpg', 4975, 1024, 768),
    (28, 128781, 0, 'Score.jpg', 4991, 500, 352),
    (29, 150896, 0, 'Halloween_04_009.jpg', 5079, 640, 480),
    (30, 3236, 0, 'high5.gif', 5124, 65, 35),
    (31, 21137, 0, 'DOG05RK002206.jpg', 5464, 280, 210),
    (32, 16594, 0, 'DOG05RK003919.jpg', 5465, 280, 210),
    (33, 23551, 0, 'logo_316693.jpg', 5775, 342, 484),
    (34, 77527, 0, 'turkeymap.jpg', 5847, 697, 439),
    (35, 7802, 0, 'tiara.jpg', 5942, 132, 176),
    (36, 103681, 0, 'PICT0296.JPG', 6063, 640, 480),
    (37, 64247, 0, 'tony.jpg', 6064, 480, 640),
    (38, 93470, 0, 'PICT0290.JPG', 6065, 640, 480),
    (39, 67886, 0, '13949.gif', 6215, 423, 381),
    (40, 4806, 0, '39221_wallpaper110.jpg', 6230, 110, 82),
    (41, 5793, 0, '42714_wallpaper110.jpg', 6231, 110, 82),
    (42, 10925, 0, 'december.jpg', 6461, 260, 260),
    (43, 19490, 0, 'november.jpg', 6468, 260, 260),
    (44, 43789, 0, 'santa-timmy1.jpg', 6501, 300, 450),
    (45, 36005, 0, 'santa-sarah1.jpg', 6502, 300, 450),
    (46, 405054, 0, 'untitled.bmp', 6529, 300, 450),
    (47, 405054, 0, 'untitled_2.bmp', 6530, 300, 450),
    (48, 405054, 0, 'untitled_3.bmp', 6531, 300, 450),
    (49, 28087, 0, 'DSCF0002b.jpg', 6536, 400, 300),
    (50, 48030, 0, 'santa-francis1.jpg', 6544, 300, 450),
    (51, 31543, 0, 'crapart2_4.jpg', 6546, 419, 329),
    (52, 900, 0, 'stargold.gif', 6785, 12, 12),
    (53, 171113, 0, 'temp.JPG', 6962, 1016, 762),
    (54, 63583, 0, 'geese.jpg', 7206, 981, 368),
    (55, 182863, 0, 'MerryChristmas.jpg', 7515, 722, 771),
    (56, 5794, 0, 'bluepuff1.jpg', 7924, 132, 176),
    (57, 5058, 0, 'bluepuff2.jpg', 7925, 132, 176),
    (58, 71148, 0, 'PICT0337.JPG', 8492, 640, 480),
    (59, 123678, 0, 'PICT0336.JPG', 8494, 640, 480),
    (60, 27644, 0, 'kitty.jpg', 8674, 301, 428),
    (61, 308578, 0, 'Santa.bmp', 8758, 495, 311),
    (62, 37310, 0, 'freepuppy.jpg', 8905, 617, 434),
    (63, 4285, 0, 'Rascal1.jpg', 9237, 147, 145),
    (64, 94529, 0, '8380.jpg', 9266, 640, 480),
    (65, 23996, 0, 'pup.jpg', 9319, 300, 282),
    (66, 24956, 0, 'pup2.jpg', 9321, 300, 474),
    (67, 16094, 0, 'pup3.jpg', 9322, 300, 353),
    (68, 14252, 0, '16452004311105750.jpg', 9323, 300, 234),
    (69, 52563, 0, 'street-with-no-beer.jpg', 9369, 800, 600),
    (70, 15501, 0, 'helmet.gif', 9379, 612, 439),
    (71, 70123, 0, 'PICT0344.JPG', 9397, 640, 480),
    (72, 77680, 0, 'PICT0347.JPG', 9398, 640, 480),
    (73, 70309, 0, 'PICT0348.JPG', 9399, 640, 480),
    (74, 45699, 0, 'PICT0403.JPG', 9400, 448, 336),
    (75, 213138, 0, 'PICT0399.JPG', 9401, 1024, 768),
    (76, 31194, 0, 'sunspotmod.jpg', 9476, 297, 219),
    (77, 9768, 0, 'Tv_abc_dick_clark_newyears.jpg', 9485, 217, 174),
    (78, 288008, 0, 'PICT0408.JPG', 9584, 1024, 768),
    (79, 234042, 0, 'PICT0411.JPG', 9585, 1024, 768),
    (80, 104708, 0, 'lily5.jpg', 9672, 379, 450),
    (81, 153767, 0, 'lily2.jpg', 9673, 918, 619),
    (82, 0, 0, 'santa_hat.jpg', 9674, , ),
    (83, 210314, 0, 'xmas_lily.jpg', 9675, 925, 622),
    (84, 12626, 0, '1732.jpg', 9682, 288, 192),
    (85, 14565, 0, '1.jpg', 9685, 288, 192),
    (86, 11357, 0, '2.jpg', 9686, 202, 288),
    (87, 16724, 0, '3.jpg', 9687, 288, 200),
    (88, 20036, 0, '4.jpg', 9688, 288, 201),
    (89, 16150, 0, 'group20001.jpg', 9689, 202, 288),
    (90, 14121, 0, 'group20002.jpg', 9690, 202, 288),
    (91, 15915, 0, 'group20003.jpg', 9691, 288, 202),
    (92, 18634, 0, 'group20004.jpg', 9692, 288, 200),
    (93, 18629, 0, 'group20005.jpg', 9693, 288, 201),
    (94, 17731, 0, 'My_Pictures0001.jpg', 9703, 288, 192),
    (95, 18446, 0, 'My_Pictures0002.jpg', 9704, 205, 288),
    (96, 17405, 0, 'My_Pictures0003.jpg', 9705, 288, 202),
    (97, 15129, 0, 'My_Pictures0004.jpg', 9706, 288, 192),
    (98, 18543, 0, 'My_Pictures0005.jpg', 9707, 288, 203),
    (99, 2762, 0, 'champagne_glasses_confetti_sm_wht.gif', 9744, 50, 50),
    (100, 6025, 0, 'man_head_spinning_sm_blk.gif', 9761, 84, 84);

Caused the error:

    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' ),
    (83, 210314, 0, 'xmas_lily.jpg', 9675, 925, 622),

Thanks!

[vmpre2]

Argh

Not sure if this has anything to do with it, but the file in question xmas_lily.jpg appears to be from an ex member so I am having a hard time tracking down this post in my forum.

The weird thing is that this image is located in my attachments folder. But not listed in a post that I can find.

In fact when I look at the attachments log, this file is no where to be found. So...why does this error show up?

Seems like I have a LOT of attached files that are in posts but NOT in my attachments log.

Does this make any sense?

[vmpre2]

Wow, OK took some tracking but I found something.

I use to run a YaBB 1.3 Gold something or other. Back in Sept of 2005 I moved to Yabb2. What I didnt do was move the old attachments log to the new Yabb2.

So now my new attachments log only lists attachments after Sept 16th 2005. But I still have posts from before Sept 16th 2005 that have attachments that are not accounted for in the new log.

If this converter was still being worked on, I would suggest only looking at the currently active attachments log and ignore any attachments not in the log. Which I guess means those attachments do not get moved. Not sure that would fix my situation.

Any thoughts? I guess I could dump any attachments made before Sept 16. Though that is not the best solution...

[vmpre2]

Confirmed.

I was able to use the old attachments log to find what post had the xmas_lily.jpg file attached. I edited the post to remove the file and re-ran the converter.

As predicted, the converter failed out while converting attachments, but this time on a different attachment.

Anyone have any suggestions? Manually editing 270 posts to remove old attachments is not fun that I would like to have.

[ShawnD]

I think I have a problem with my paths or permission...  Can anybody piont me in the right direction...

Kindest Regards


Warning: file(/home/ravensho/public_html/bbs/Paths.pl) [function.file]: failed to open stream: Permission denied in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 76

Warning: Invalid argument supplied for foreach() in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 79

Notice: Undefined index: boardsdir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91

Notice: Undefined index: datadir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91

Notice: Undefined index: memberdir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91

Notice: Undefined index: sourcedir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91

Notice: Undefined index: vardir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91

Notice: Undefined index: facesdir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91

Notice: Undefined index: uploaddir in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 91

Warning: file(/Settings.pl) [function.file]: failed to open stream: No such file or directory in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 98

Warning: Invalid argument supplied for foreach() in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 99
Converting membergroups...
Warning: file(/membergroups.txt) [function.file]: failed to open stream: No such file or directory in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 120

Warning: Invalid argument supplied for foreach() in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 121
Successful.
Converting members...
Fatal error: Call to a member function on a non-object in /home/ravensho/public_html/forum/yabb21_to_smf.php on line 246

[ShawnD]

Ive learnt a little from reading posts here and have managed to get all the posts, and boards across,  But I stumped, I have NO members, and no attachments..  If anybody can help I would really appreciate it

Does this mean anything to someone that knows, what they are doing, ?
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Successful.
Recalculating forum statistics...
Notice: Undefined index: latestMember in /home/ravensho/public_html/forum/convert.php on line 1088

Notice: Undefined index: latestRealName in /home/ravensho/public_html/forum/convert.php on line 1089
Successful.
Conversion Complete

Cheers Shawn

...