[SMF Converter] phpBB - 2.0.19+

Started by JayBachatero, January 13, 2007, 02:47:08 AM

Previous topic - Next topic

JayBachatero

Haiyu did you by any chance drop any of the indexes in the members table?  Run this query in phpMyAdmin.


SHOW KEYS
FROM smf_members;


What does it return?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Bernie

Quick question:  If a phpBB2 (2.0.22) system had over 1,500 smilies, and was converted over, how would they be handled by SMF 1.1.1?
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

Haiyu

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
smf_members 0 PRIMARY 1 ID_MEMBER A 1109 NULL NULL   BTREE
smf_members 1 memberName 1 memberName A 1109 30 NULL   BTREE
smf_members 1 dateRegistered 1 dateRegistered A 1109 NULL NULL   BTREE
smf_members 1 ID_GROUP 1 ID_GROUP A 3 NULL NULL   BTREE
smf_members 1 birthdate 1 birthdate A 0 NULL NULL   BTREE
smf_members 1 posts 1 posts A 69 NULL NULL   BTREE
smf_members 1 lastLogin 1 lastLogin A 554 NULL NULL   BTREE
smf_members 1 lngfile 1 lngfile A 0 30 NULL   BTREE
smf_members 1 ID_POST_GROUP 1 ID_POST_GROUP A 1 NULL NULL   BTREE


This is what I get.. I'm not sure if I dropped anything.I don't think I did?  

JayBachatero

Quote from: Bernie on January 31, 2007, 07:43:07 PM
Quick question:  If a phpBB2 (2.0.22) system had over 1,500 smilies, and was converted over, how would they be handled by SMF 1.1.1?
To tell you the truth I don't even know.  I think they will probably be transfered as hidden.

Quote from: Haiyu on January 31, 2007, 09:56:51 PM
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
smf_members 0 PRIMARY 1 ID_MEMBER A 1109 NULL NULL   BTREE
smf_members 1 memberName 1 memberName A 1109 30 NULL   BTREE
smf_members 1 dateRegistered 1 dateRegistered A 1109 NULL NULL   BTREE
smf_members 1 ID_GROUP 1 ID_GROUP A 3 NULL NULL   BTREE
smf_members 1 birthdate 1 birthdate A 0 NULL NULL   BTREE
smf_members 1 posts 1 posts A 69 NULL NULL   BTREE
smf_members 1 lastLogin 1 lastLogin A 554 NULL NULL   BTREE
smf_members 1 lngfile 1 lngfile A 0 30 NULL   BTREE
smf_members 1 ID_POST_GROUP 1 ID_POST_GROUP A 1 NULL NULL   BTREE


This is what I get.. I'm not sure if I dropped anything.I don't think I did? 
Can you PM me a test admin and a tes regular account?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Bernie

Quote from: JayBachatero on January 31, 2007, 10:33:44 PM
Quote from: Bernie on January 31, 2007, 07:43:07 PM
Quick question:  If a phpBB2 (2.0.22) system had over 1,500 smilies, and was converted over, how would they be handled by SMF 1.1.1?
To tell you the truth I don't even know.  I think they will probably be transfered as hidden.


I'll let you know how it works out.  :)
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

JayBachatero

Ok it seems like it won't hide them or anything.  Give me a few mins to look into it.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

JayBachatero

Ok give this a try.  SInge phpBB doesn't have a column to show if a smiley is hidden i made it that it will show the first 25 smileys and add the rest of the smileys to the popup.

! Add smileys with an id higher than 25 to the smileys popup. (phpbb2_to_smf.sql)
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Bernie

I'll give it a try and let you know what happens.

At a later date I'll be doing a mod to put them back in categories, as they were on the phpBB2 system.  Have to get them into the system first though.   ;)
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

JayBachatero

Well I don't really know how phpBB does this.  I should look more into it and see if I can make the converter use the categories to it's advantage.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Bernie

Quote from: JayBachatero on January 31, 2007, 11:52:28 PM
Well I don't really know how phpBB does this.  I should look more into it and see if I can make the converter use the categories to it's advantage.

It's a mod, not standard for phpBB2, so it would only be of very limited use.  I would imagine you'd prefer to keep your converter for a "plain vanilla" install of phpBB?

A similar mod for SMF would probably be a good idea, which is why I intend to create one, once I'm more familiar with the software.  I've made a number of my own mods for phpBB2 in the past, but I have nil experience with SMF yet.
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

JayBachatero

Well we support the attachments mod in the converter.  Then again that mod is one of the most popular mods fr phpBB.  I guess it all depends on how much people request the mod.

That would be great to see more mods for SMF :).
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Bernie

Quote from: JayBachatero on February 01, 2007, 12:34:28 AM
Well we support the attachments mod in the converter.  Then again that mod is one of the most popular mods fr phpBB.  I guess it all depends on how much people request the mod.

That would be great to see more mods for SMF :).

Looks like we only have partial success Jay...

Converting smileys... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting attachment mod (if installed)...
Parse error: parse error in /home/******/*****.com/html/forums/convert.php(668) : eval()'d code on line 63
Error in convert script phpbb2_to_smf.sql on line 1039!
Successful.
Recalculating forum statistics... Successful.


It seems to have balked at the attachments.  I've had problems with them in the past (forum was hacked 18 months ago) and I suspect there may be a couple of attachments that are missing.

What was the next step in the script?

Uh-oh...  Just checked the forum and none of the smilies went to the popup.  All 1,537 of 'em are in the top section.  LOL  Sure makes for a crowded screen when posting!

Yes, I know, you've got to be asking, "What the heck does he need all those smilies for?"

Long story, let's just say I have some very strange people on my system, and that there would be a revolution if I got rid of very many of them.

*Suggestion*  Make the script put all the smilies in the popup, and then I can just move the ones I want to the menu.

BTW Jay, I just want to thank you again for the help you give all the visitors here, not just me.
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

JayBachatero

Ok I had a typo for the attachments stuff thus the error.

Yea I already asked myself that question :P.  Why the heck does he has so many of them :P.  I just use ~3 :P :) and ;)

Also I changed the smileys stuff around to see if the query would run now.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

JayBachatero

Also thanks for the comment.  Just trying to help ;).
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Bernie

Quote from: JayBachatero on February 01, 2007, 09:43:12 AM
Also thanks for the comment.  Just trying to help ;).

And doing a great job of it.  I admire your consistently cheerful and helpful demeanor on here.  It's not an easy job, and you're pulling it off with style.  
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

Bernie

Jay, a question, and a couple of suggestions for improving your converter...

Question:

Should anything, in particular, be done before running the new script?  (ie: delete the smilies, etc.)

Suggestions:

  • On importing the ban list(s) from phpBB make the IP address, email address, etc. the actual name of the ban, rather than "migrated_ban_1006" or whatever.  Makes it difficult to know what each one is, or find one in particular to modify.  (I have 144 pages of them now.)  Yes, I realize you can browse by trigger, but the 'Notes' section already says it's migrated and the default listing shows them by name.
  • Give an option to combine all of a particular type of ban (IP, email, etc.) into a single ban, with multiple triggers, or as individual bans.
  • When importing smileys, put them into a new set named "imported".
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

JayBachatero

Quote from: Bernie on February 01, 2007, 01:11:19 PM
Quote from: JayBachatero on February 01, 2007, 09:43:12 AM
Also thanks for the comment.  Just trying to help ;).

And doing a great job of it.  I admire your consistently cheerful and helpful demeanor on here.  It's not an easy job, and you're pulling it off with style. 
Thanks for the kind words Bernie. :)

Quote from: Bernie on February 01, 2007, 02:54:37 PM
Question:
Should anything, in particular, be done before running the new script?  (ie: delete the smilies, etc.)
No need to.  If anything needs to be done the converter will do it for you.

Quote from: Bernie on February 01, 2007, 02:54:37 PM
Suggestions:

  • On importing the ban list(s) from phpBB make the IP address, email address, etc. the actual name of the ban, rather than "migrated_ban_1006" or whatever.  Makes it difficult to know what each one is, or find one in particular to modify.  (I have 144 pages of them now.)  Yes, I realize you can browse by trigger, but the 'Notes' section already says it's migrated and the default listing shows them by name.
  • Give an option to combine all of a particular type of ban (IP, email, etc.) into a single ban, with multiple triggers, or as individual bans.
  • When importing smileys, put them into a new set named "imported".
To be honest I would have to look into how the banning works in SMF.  Never really had to work with it so never looked into how it works.  It shouldn't be to hard to do.

The smileys are kept in the original dir that they wre in phpBB.  They are just copied over.  So I'm not sure about moving them to 1 separate dir.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Bernie

Quote from: JayBachatero on February 01, 2007, 10:32:45 PM
Quote from: Bernie on February 01, 2007, 02:54:37 PM
Suggestions:

  • On importing the ban list(s) from phpBB make the IP address, email address, etc. the actual name of the ban, rather than "migrated_ban_1006" or whatever.  Makes it difficult to know what each one is, or find one in particular to modify.  (I have 144 pages of them now.)  Yes, I realize you can browse by trigger, but the 'Notes' section already says it's migrated and the default listing shows them by name.
  • Give an option to combine all of a particular type of ban (IP, email, etc.) into a single ban, with multiple triggers, or as individual bans.
  • When importing smileys, put them into a new set named "imported".
To be honest I would have to look into how the banning works in SMF.  Never really had to work with it so never looked into how it works.  It shouldn't be to hard to do.

The smileys are kept in the original dir that they wre in phpBB.  They are just copied over.  So I'm not sure about moving them to 1 separate dir.

Ah, that's good to know.  I had not really looked at where and how the smilies that were imported were being stored yet.  If I understand you correctly then they are still in the directory that phpBB stored them in, so deleting the phpBB directories after the conversion would lose all those graphics files.  I'll have to create a new directory for them, and change the path in SMF.

Being a high rated site (Google) ours had significant problems with spammers and spammer bots.  The cure, for us, was in banning certain IP addresses, or ranges of IP addresses, as well as dozens of email domains.  Thus, 144 pages of bans that were imported.

BTW, the converter is not working well with the attachments.  I'm getting a lot of errors about missing files (possible, as I noted earlier) and bombing out with an SQL error.

Unsuccessful!
This query:

    INSERT INTO `smf`.smf_attachments
    (ID_ATTACH, ID_MSG, filename, size, downloads, width, height)
    VALUES
    (295, 96271, SUBSTRING('Advancing under smoke cover.jpg', 1, 255), 300707, 0, 800, 600),
    (296, 12701, SUBSTRING('the_tennis_court.zip', 1, 255), 141255, 12, , ),
    (297, 96267, SUBSTRING('Image1.jpg', 1, 255), 34291, 427, 456, 298),
    (298, 96259, SUBSTRING('VAZ2105.JPG', 1, 255), 19143, 177, 350, 214),
    (299, 96267, SUBSTRING('Image2..jpg', 1, 255), 38631, 427, 574, 366),
    (300, 96267, SUBSTRING('Image3.jpg', 1, 255), 60379, 7, 529, 407),
    (301, 96336, SUBSTRING('T5.JPG', 1, 255), 184267, 7, 800, 600),
    (302, 96211, SUBSTRING('HPIM0387.JPG', 1, 255), 40566, 44, 773, 576),
    (303, 96211, SUBSTRING('HPIM0385.JPG', 1, 255), 48839, 44, 773, 576),
    (304, 96211, SUBSTRING('HPIM0381.JPG', 1, 255), 25813, 8, 576, 773),
    (305, 96355, SUBSTRING('Italian Inf gun.png', 1, 255), 447245, 3, 474, 276),
    (306, 96375, SUBSTRING('RKHGBFI01.jpg', 1, 255), 38411, 169, 250, 355),
    (307, 96359, SUBSTRING('UO0002.JPG', 1, 255), 200849, 10, 800, 600),
    (308, 96361, SUBSTRING('T6.JPG', 1, 255), 184330, 7, 800, 600),
    (309, 96375, SUBSTRING('RKHGBRG05.jpg', 1, 255), 20384, 169, 200, 230),
    (310, 100734, SUBSTRING('T-10-ECent-Trying-to-hold-o.jpg', 1, 255), 164022, 5, 668, 537),
    (311, 96426, SUBSTRING('t7.JPG', 1, 255), 188191, 6, 800, 600),
    (312, 96433, SUBSTRING('German Advance Soviet Delay July 1942.doc', 1, 255), 68608, 15, , ),
    (313, 96438, SUBSTRING('PBM form.doc', 1, 255), 31232, 7, , ),
    (314, 96448, SUBSTRING('Bersaglieri_motociclisti_sotto_lArco_dei_Fileni.jpg', 1, 255), 59172, 0, 605, 963),
    (315, 96448, SUBSTRING('Bersaglieri_moto_Lybia.jpg', 1, 255), 114760, 1, 1046, 790),
    (316, 2713, SUBSTRING('commando_camp.zip', 1, 255), 322800, 92, , ),
    (317, 96271, SUBSTRING('Enemy veihicles neutralized.jpg', 1, 255), 282005, 1, 800, 600),
    (318, 96211, SUBSTRING('HPIM0393.JPG', 1, 255), 45519, 9, 576, 773),
    (319, 96211, SUBSTRING('HPIM0392.JPG', 1, 255), 54953, 0, 576, 773),
    (320, 96271, SUBSTRING('Sturmpionners crossed the river.jpg', 1, 255), 301583, 0, 800, 600),
    (321, 100734, SUBSTRING('T-10 N-Barely Holding On.jpg', 1, 255), 428822, 3, 668, 540),
    (322, 97596, SUBSTRING('map_winner.gif', 1, 255), 5493, 130, 125, 125),
    (323, 96211, SUBSTRING('HPIM0377.JPG', 1, 255), 64170, 1, 576, 773),
    (324, 96211, SUBSTRING('HPIM0376.JPG', 1, 255), 75947, 6, 773, 576),
    (325, 96266, SUBSTRING('neighbors_rig.jpg', 1, 255), 73812, 2, 490, 421),
    (326, 96266, SUBSTRING('New_panel2.jpg', 1, 255), 49507, 42, 441, 683),
    (327, 96256, SUBSTRING('t3.JPG', 1, 255), 182537, 7, 800, 600),
    (328, 96266, SUBSTRING('New_Panel1.jpg', 1, 255), 85606, 0, 790, 672),
    (329, 96260, SUBSTRING('t19.JPG', 1, 255), 167303, 2, 800, 600),
    (330, 96367, SUBSTRING('cannone_65-17.jpg', 1, 255), 9962, 91, 300, 125),
    (331, 95716, SUBSTRING('view1.jpg', 1, 255), 184521, 20, 666, 538),
    (332, 96242, SUBSTRING('Lancia 3Ro_2.jpg', 1, 255), 291784, 12, 740, 413),
    (333, 96242, SUBSTRING('Lancia 3RO.jpg', 1, 255), 256708, 11, 914, 336),
    (334, 96242, SUBSTRING('Lancia 3RO_3.jpg', 1, 255), 289601, 11, 1176, 295),
    (335, 96240, SUBSTRING('T17M.JPG', 1, 255), 184918, 0, 800, 600),
    (336, 96130, SUBSTRING('Open pit2.jpg', 1, 255), 44834, 93, 600, 464),
    (337, 95886, SUBSTRING('JACKSON_T-SHIRT_EDITED.jpg', 1, 255), 46869, 162, 480, 640),
    (338, 95889, SUBSTRING('Russian Arty plots.JPG', 1, 255), 149946, 9, 800, 600),
    (339, 95651, SUBSTRING('200_278.zip', 1, 255), 779183, 27, , ),
    (340, 96227, SUBSTRING('Turn2.JPG', 1, 255), 167715, 6, 800, 600),
    (341, 96211, SUBSTRING('HPIM0391.JPG', 1, 255), 53452, 1, 773, 576),
    (342, 96211, SUBSTRING('HPIM0396.JPG', 1, 255), 50249, 1, 576, 773),
    (343, 96211, SUBSTRING('HPIM0404.JPG', 1, 255), 53833, 2, 773, 576),
    (344, 96171, SUBSTRING('SJT11-Armor.jpg', 1, 255), 274525, 2, 800, 600),
    (345, 96171, SUBSTRING('SJT11-Almost.jpg', 1, 255), 267476, 2, 800, 600),
    (346, 96171, SUBSTRING('SJT11-Surrounded.jpg', 1, 255), 272743, 5, 800, 600),
    (347, 96149, SUBSTRING('414-418 Art 113 Complete Series ENHANCED.zip', 1, 255), 171579, 117, , ),
    (348, 96137, SUBSTRING('elec_layout.jpg', 1, 255), 46032, 59, 511, 264),
    (349, 96130, SUBSTRING('R689.jpg', 1, 255), 48765, 93, 511, 300),
    (350, 96130, SUBSTRING('Large Dutch 8c_1.jpg', 1, 255), 18931, 93, 400, 300),
    (351, 96130, SUBSTRING('Large gun.jpg', 1, 255), 18090, 93, 500, 333),
    (352, 15771, SUBSTRING('SealionCh1Campaign.zip', 1, 255), 345848, 83, , ),
    (353, 96130, SUBSTRING('Open pit.jpg', 1, 255), 27981, 93, 500, 345),
    (354, 96130, SUBSTRING('Med size105mm_R671.jpg', 1, 255), 81253, 1, 800, 600),
    (355, 95652, SUBSTRING('200_261enh.zip', 1, 255), 661358, 35, , ),
    (356, 14548, SUBSTRING('Scen406.zip', 1, 255), 50091, 36, , ),
    (357, 96130, SUBSTRING('S169 Large.jpg', 1, 255), 49416, 93, 559, 300);

Caused the error:

    You have an error in your SQL syntax near ' ),
    (297, 96267, SUBSTRING('Image1.jpg', 1, 255), 34291, 427, 456, 298),
    ' at line 6

(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

JayBachatero

Here is the fixed version.  Fixed it yesterday but forgot to post it.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Bernie

Ummm, Jay?  You did post it.  And I used it.  That's what this output is from.

:D
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

Advertisement: