VanillaPorter 2.3 Help | Porting IP.Board 3.3.0
Hello everyone, Thanks ahead of time to anyone who can help me out.
I'm trying to port over forums/users from IP.Board 3.3.0, I stuck the Vanilla2export.php in my main IP.Board directory and gave it 0777 permissions to run.
After navigating to host/forums/vanilla2export.php and providing it with the mysql host, ibf_ prefix, login/pass with Export Type "All supported data" with Avatars and Files unchecked, then clicking "Begin Export" I'm getting the following error:
select TagID, '0' as CategoryID, tag_meta_id as DiscussionID, t.tag_added
from ibf_core_tags t
left join z_tag zt on t.tag_text = zt.FullName;Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Error in forums/vanilla2export.php line 1203: (1024) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
- How can I get past this? I'm not that good with mysql nor do I understand this error fully.
I didn't have experience in IP.B (just moderation) but I will try to help.
First of all, make a backups of your database.
Next, I think that your database contrains table encodés in utf8_unicode_ci and Vanilla need it to utf8_general_ci.
This is what I understand.
Hey, Thanks. I converted the database to utf8_general_ci and the exporter was able to proceed!
There's one more remaining problem, I get a:
" Error in forums/vanilla2export.php line 8252: (1024) Source avatar folder '' does not exist. Even though there is an avatar folder?
Is there a way to configure or set that folder?
Hm, Odd. In a lot of posts I am seeing both double usernames and HTML
tags visible as well and not taken into account. is there any way to fix that?
if I make a new post with a line break
, it works fine. But old converted posts just display it in plain text.
Oh. Can you tell us:
I also did a migration from IP Board 3 to Vanilla and am facing the issue with HTML Tags in posts being visible.
Could someone give a solution to this?
I seem to have it fixed for me. I noticed that my private messages where showing up correctly.
In case you experience the same (messed up Posts/Threads, working Private Messages) you might want to try what I did:
This made it work for me, hope it helps you too!
It works, but just because "IPB" is not a valid format and so it defaults to Html
Valid possibilities for format are:
So just in case the default may change at one time in the future, I would suggest that you change format to "Html"
Thanks for the Update. I figured since it was automatically assigned after the import, it would be a valid format. I updated it to Html just in case. Thank you
BBCode is valid, but it doesn't "allow" HTML tags, they are just echoed as they are. How has that been in your forum? Did your forum had BBCode mixed with HTML?
@JDBArtist and @R_J
I ran both:
update GDN_Discussion set Format = 'Html';
update GDN_Comment set Format = 'Html';
^^ But this resulted in BB Code being displayed in posts but HTML working fine.
1) It does seem I have mixed HTML and BBCode in posts?
Now I'll see things like: [u][b]Text here![/b][/u] but I won't see
If I switch back to BBCode Format, I'll see the html tags again but not BBCode.
2) Usernames appear "doubled" at times, where some users names will show twice in posts / threads. Odd.
Thanks for all the help so far!
Double displayed names like this:
I have seen that "doubled" user names before. I guess it happens when the users avatar cannot be displayed for whatever reason (company firewall?)
Concerning the BBCode/HTML problem: it looks as if IPB allows a mixture of HTML and BBCode, which is not allowed in Vanilla. That's why you get either one or the other which looks quite poor.
But now you are dealing with Vanilla, you will soon find out that Vanilla is the king of customization! Please create the file
/conf/bootstrap.before.phpand paste the following lines into that file
If the file already existed, you can skip the first line.
The last thing to do is to change the Format column to IPB, which is now a known custom format. Isn't that sweet?
Yeah, that's the avatars showing their alt text. Possibly you didn't bring them over / modify their paths. Not all the Porter packages can do that.
@Echelon & @JDBArtist
And would you please be so kind and report back if that solved those BBCode/HTML markup problems?
Thanks again for everyone's help so far, wanted to say that first before continuing:
@R_J and @Linc
That's exactly what happened, for some reason when I ported over the DB, in renamed the filenames to peoples avatars for some reason, say for my avatar, it was "av3.jpg" but it inserted a "p" infront like "pav3.jpg" , unsure why the porter did that.
To test, I renamed the actual .jpg from av3.jpg to pav3.jpg, I still saw a double name of my user account.
**Fixed it by going to Edit Profile --> Edit my Thumbnail and defining my thumbnail. This removed the double name so I suppose every user once I fully port over the forums will need to do that, unless somehow I can set a "default" thumbnail for users until they set their own, to prevent double names.
I tried your fix @R_J, It worked great with one issue which I think is my converted DB's fault after using your custom php and defining format to IPB! As far as not showing BBCode OR showing HTML now, it's great! Really neat that Vanilla is so open to customization.
The issue is that a ton of user comments in the forum will look like this:
(They'll have double html line breaks for some reason? 2x "br /" tags)
Not sure if I am able to help with that. Could you give an example from out of your database which gets this doubled line breaks? Enclose what you post with three tildes like that so that it doesn't get converted:
I edited the post to add a code block.
Here's another example:
(These are forums for a non-profit/free/Independent game. Which is why Vanilla is especially a good option due to having 0 revenue and prior forum solutions costing out of pocket money, Which is also why our IPB Version is so old and vulnerable to many exploits and attacks!
Don't worry I won't post which game as to not advertise etc.)
I looked at a pre-converted forums DB from IPB, and it has the same kind of formatting. (From the same forum and IPB 3.3.0 version)
We'll be holding a meeting
Let's make the meeting Sunday
We need to provide more feedback on pressing matters like rulesets, etc. and discuss whether we have the resources and time to get X Feature out the door
As well as:
*The items 1-5 on the original forums are not bulleted or spaced like that sorry, they have just a text "-" in front of them. It's more like the below with no space under As well as and item 1:
As well as: