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?
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
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.
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 (https://www.simplemachines.org/community/index.php?topic=572741.msg4052276#msg4052276).
Did you find a solution for that problem?
Without a solution, there is no functional converter.
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.
Ok, so at the moment there is no functioning converter phpBB for 3.2.x to SMF 2.0.x.
Good to know.
Any likelihood of this being fixed, so the converter is usable?
Yes, at some point I can take a look at it probably will be a while though.
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.
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.
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...
/******************************************************************************/
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.