phpBB 3.2.x to SMF 2.0.x - what gets converted, and what doesn't?

Started by Antechinus, May 13, 2020, 06:31:13 PM

Previous topic - Next topic

Antechinus

Just wondering which bits are likely to work and which bits aren't. Does anyone have a list?

  • I realise PM attachments will not work. What happens to those?
  • What about permissions? How are they handled?
  • I assume the base installation of SMF 2.0.x would have to be set up for UTF-8. Yes, or no?
  • Any other pitfalls?

vbgamer45

Converts: categories, boards, membergroups, attachments,polls, personal messages


1. PM attachments would not be converted. They just would not be carried over to the new forum.
2. Permissions are not currently handled by the convertor. board_permissions are converted though
3. Yes would suggest to be on utf8
4. Passwords require file changes on SMF to convert over: Check out https://www.simplemachines.org/community/index.php?topic=572741.0
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Antechinus

Ok. What about inline attachments? I assume they would just be converted as standard (not inline) ones. Or do they get binned?

The other thing is if I convert the board to SMF I'd be running Doug's Inline Attachments mod, which means it'd be really cool if there was a way of hooking up phpBB inline attachments to the same code in the mod after conversion. Has anyone ever tried that trick?

I assume there would be some way of making it possible, perhaps involving some custom db queries. The converted posts would presumably still have the required markup in the post content, and the attachments should still be there as standard attachments, so hooking them up somehow should be feasible.

Massl

Quote from: Antechinus on May 14, 2020, 07:15:24 PM
The converted posts would presumably still have the required markup in the post content
Yes, almost all messages have these problems.


Antechinus

Did you find a solution for that problem?
Without a solution, there is no functional converter.

Massl

Unfortunately no, you are right it cannot be used  :(
I haven't checked but I think it's the same for phpBB 3.3.0 too.

Antechinus

Ok, so at the moment there is no functioning converter phpBB for 3.2.x to SMF 2.0.x.
Good to know.

Antechinus

Any likelihood of this being fixed, so the converter is usable?

vbgamer45

Yes, at some point I can take a look at it probably will be a while though.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Antechinus

Oh here's a related question: what happens to the phpBB directory for attached images? Does that get duplicated to make a new SMF directory?

The reason I ask is that it is relevant to disc storage limits in my current situation. If it gets duplicated, that could be a bit of an issue.

Antechinus

OK, bugger this. Since answers are not forthcoming, I will have to try it myself and see what goes wrong (probably plenty).

First thing I have noticed is that the latest phpbb32x_to_smf.sql from GitHub has a stack of syntax errors in it, due to someone using PHP comment syntax (ie: // Comment here...) instead of SQL comment syntax (ie: /* Comment here... */).

It might work with the wrong syntax (although I have known of other cases where incorrect syntax totally screws an SQL file) but there's no reason to not use the correct syntax, and using the wrong syntax borks code highlighting, which is bound to be a nuisance if the file needs editing (which it undoubtedly will, to some extent).

So...

Here is an edited copy which uses the correct SQL syntax for comments everywhere. Literally a 5 minute job. No, I am not logging in to Github at this stage.

vbgamer45

The // comments are are actually ok when its part of the php code. The .sql files the convertors use is a mix of
PHP and MySQL. PHP starts with ---{ and ends with ---}


This syntax is used to output a title to the screen such as below on a conversion step.
/******************************************************************************/
--- Converting polls...
/******************************************************************************/



Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Antechinus

Quote from: Antechinus on April 17, 2022, 02:40:06 AMIt might work with the wrong syntax (although I have known of other cases where incorrect syntax totally screws an SQL file) but there's no reason to not use the correct syntax, and using the wrong syntax borks code highlighting, which is bound to be a nuisance if the file needs editing (which it undoubtedly will, to some extent).
I can increase the font size, if that will help.

Advertisement: