Stritix Posted May 7, 2016 Posted May 7, 2016 I have just upgraded my community from IPB3 to IPS4, however there are two issues. Posts have weird characters and broken words. For example: "Good, on a system I own and around £20 are my requirements" there should be no "Â". There's a post which randomly contains " ​" for no apparent reason. There's a lot of similar issues with other posts. There's also huge gaps in posts where users have put spaces. How do I fix these issues?
Stritix Posted May 7, 2016 Author Posted May 7, 2016 Another example "To develop a rival to Nintendo’s Mario, Sega hosted an in-house design contest that produced a new hedgehog mascot codenamed “Mr. Needlemouse.� Artists colored him cobalt blue and outfitted him in large red shoes that evoked allusions to boots warn by Michael Jackson and Santa Claus. Styled as an underdog with attitude, Sonic appealed to Generation X gamers."
IveLeft... Posted May 7, 2016 Posted May 7, 2016 Your database isnt utf8-mb4 You really need to run the database convert script to update the db to utf8-mb4 before you upgrade, have you got a backup The script is in /admin/convertutf8/
Stritix Posted May 7, 2016 Author Posted May 7, 2016 Just now, Cloud 9 said: Your database isnt utf8-mb4 You really need to run the database convert script to update the db to utf8-mb4 before you upgrade, have you got a backup The script is in admin/utf8convert I have got a backup. Where can I find the database convert script? I assumed the IPS4 upgrade process handled this. The upgrade said everything was fine before it began.
IveLeft... Posted May 7, 2016 Posted May 7, 2016 Its in the IPS4 download in /admin/convertutf8/ Youll need to go back to 3.4.x first i think, run the dB converter ( from memory you need to run the full convert i think - been a while since i did it) and then upgrade to IPS4
Stritix Posted May 7, 2016 Author Posted May 7, 2016 Thank you. Hopefully it works. What about the spacing issues? Can anything be done about them? It looks quite unusual.
Stritix Posted May 7, 2016 Author Posted May 7, 2016 36 minutes ago, Cloud 9 said: Its in the IPS4 download in /admin/convertutf8/ Youll need to go back to 3.4.x first i think, run the dB converter ( from memory you need to run the full convert i think - been a while since i did it) and then upgrade to IPS4 It says everything is fine. I used the tools featured to check and fix as well. I don't understand what the problem is. Welcome The database tables are UTF-8, collations are correct and there is nothing to convert. You can proceed with the upgrade.
IveLeft... Posted May 7, 2016 Posted May 7, 2016 Dont know then, it worked for me, raise a support ticket, also look at your tables and see what it says they are Are you sure your looking at the old db ?
Stritix Posted May 7, 2016 Author Posted May 7, 2016 10 hours ago, Cloud 9 said: Dont know then, it worked for me, raise a support ticket, also look at your tables and see what it says they are Are you sure your looking at the old db ? I'm sure. It's quite unusual. I raised a support ticket yesterday.
Martin A. Posted May 7, 2016 Posted May 7, 2016 My guess would be that you're still waiting on your post content being rebuilt. On the ACP dashboard you'll probably see a bunch of background processes working, or waiting in line. Just wait for them to finish before you panic.
Stritix Posted May 7, 2016 Author Posted May 7, 2016 Just now, Martin A. said: My guess would be that you're still waiting on your post content being rebuilt. On the ACP dashboard you'll probably see a bunch of background processes working, or waiting in line. Just wait for them to finish before you panic. All background processes finished before I posted this topic.
Stritix Posted May 8, 2016 Author Posted May 8, 2016 The character issue has been resolved, though I'm still wondering about the larger spaces in posts?
Simon Woods Posted May 8, 2016 Posted May 8, 2016 17 hours ago, Stritix said: The character issue has been resolved, though I'm still wondering about the larger spaces in posts? Do you have any screenshots or links to show this happening?
TSP Posted September 13, 2016 Posted September 13, 2016 Older posts from before the upgrade is unfortunately rebuilt in such a way it can add extra amount of space in previous posts. Unfortunately there's nothing that can be done with that, unless you make a script to fix it yourself.
Allen Bradford Posted September 13, 2016 Posted September 13, 2016 The character spacing is controlled here: ACP → Customization → Editor → Settings → Return Key Behaviour I had my 14 year old board converted to IPS and spacing from converted Topics was screwy. The IPS Board keyboard return default is Start New Paragraph. Change yours to Go To Next Line. This may close up some of the spaces, not sure but worth a try.
Simon Woods Posted September 13, 2016 Posted September 13, 2016 There is this: But it has not been updated since February so it's not a sure thing.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.