after update to 3.0.8, apostrophes are ’

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
Sajaki
Registered User
Posts: 1354
Joined: Mon Mar 02, 2009 1:41 pm
Name: Andreas
Contact:

Re: after update to 3.0.8, apostrophes are ’

Post by Sajaki » Wed Feb 09, 2011 10:40 pm

i have a conversion list for these:

Code: Select all

$old=array(‘ä’,'ö’,'ü’,'Ä’,'Ö’,'Ãœ’,'µ’,'ß’,'´’,'²’,'³’,'§’,'°’,'¯’,'¼’,'½’,'¾’,'€’,'–’,'„’,'“’,'‰’,’.’,'”‘,’»’,'«’);

Code: Select all

$new=array(‘ä’,'ö’,'ü’,'Ä’,'Ö’,'Ü’,'µ’,'ß’,'´’,'²’,'³’,'§’,'°’,'¯’,'¼’,'½’,'¾’,'EUR’,'-’,'”‘,’”‘,’o/oo’,’ ‘,’%22′,’»’,'«’);

Bramster.
Registered User
Posts: 151
Joined: Thu Mar 04, 2010 7:42 am

Re: after update to 3.0.8, apostrophes are ’

Post by Bramster. » Thu Feb 10, 2011 12:21 pm

Thanks guys, thats is what I needed. Could I have a look at your complete list Dicky ?

What code are you using to locate the characters ?

I use this to first check out things before I do an update on the database. I want to be sure I am doing the right thing.

Code: Select all

SELECT `post_id`,`post_text` FROM `phpbb_posts` WHERE `post_text` REGEXP '…'
Unfortunately this does not locate all character because when doing the update there are normally more hits then during the select

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: after update to 3.0.8, apostrophes are ’

Post by D¡cky » Fri Feb 11, 2011 1:06 am

Bramster. wrote:Thanks guys, thats is what I needed. Could I have a look at your complete list Dicky ?
It is not in a presentable format. I am working on getting it so you can see it, plus I am trying to check it for accuracy as best as I can.
Bramster. wrote:What code are you using to locate the characters ?

I use this to first check out things before I do an update on the database. I want to be sure I am doing the right thing.

Code: Select all

SELECT `post_id`,`post_text` FROM `phpbb_posts` WHERE `post_text` REGEXP '…'
Unfortunately this does not locate all character because when doing the update there are normally more hits then during the select
This is what I use to replace the characters

Code: Select all

update phpbb_posts set post_text = replace(post_text, 'old_character', 'new_character')
Unfortunately, with this method only one character at a time is fixed. You also need to start with the longest characters leaving the shortest characters for last.
Have you hugged someone today?

Bramster.
Registered User
Posts: 151
Joined: Thu Mar 04, 2010 7:42 am

Re: after update to 3.0.8, apostrophes are ’

Post by Bramster. » Fri Feb 11, 2011 7:55 am

It is not in a presentable format. I am working on getting it so you can see it, plus I am trying to check it for accuracy as best as I can.
Hold your horses, I am working on a Excel table myself as well.
This is what I use to replace the characters
I first search for the charater, so I know how many hits there are and what is gonna get changed, because doing an updatewithout knowing what is gonna happen is way too dangerous. Therefore I would like people to evaluate my select code, which is:

Code: Select all

SELECT `post_id`,`post_text` FROM `phpbb_posts` WHERE `post_text` REGEXP 'the-xcharacter'

Wert
Former Team Member
Posts: 3676
Joined: Tue Jul 03, 2001 8:33 pm
Location: Sacramento, CA
Name: Chris Aguilar

Re: after update to 3.0.8, apostrophes are ’

Post by Wert » Fri Jun 10, 2011 3:25 am

I had this problem in a major way and the sql update fixed it right up.

For those who might need it, here's that conversion table that someone posted, converted to nice excel format.
Attachments
conversion_table.xls
(8 KiB) Downloaded 70 times
Chris Aguilar - AKA "Wert"

elsa23
Registered User
Posts: 180
Joined: Sun Jul 25, 2010 3:36 am

Re: after update to 3.0.8, apostrophes are ’

Post by elsa23 » Fri May 04, 2012 10:07 am

Hi,

Is this can work ?

Code: Select all

update phpbb_posts set post_text = replace(post_text, 'Ã ', 'à')
there are one space after Ã

thanks a lot :)
sorry for my bad english

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21683
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: after update to 3.0.8, apostrophes are ’

Post by Mick » Fri May 04, 2012 12:26 pm

elsa23 wrote:Is this can work ?
Backup your database and try it.
"The more connected we get the more alone we become" - Kyle Broflovski

elsa23
Registered User
Posts: 180
Joined: Sun Jul 25, 2010 3:36 am

Re: after update to 3.0.8, apostrophes are ’

Post by elsa23 » Fri May 04, 2012 12:35 pm

Thanks !

And this ?

Code: Select all

update phpbb3_posts set post_text = replace(post_text, '’', '`')
sorry for my bad english

User avatar
Erik Frèrejean
Former Team Member
Posts: 9899
Joined: Tue Oct 09, 2007 9:09 am
Location: The Netherlands, 3.0.x Support Forum
Name: Erik Frèrejean
Contact:

Re: after update to 3.0.8, apostrophes are ’

Post by Erik Frèrejean » Fri May 04, 2012 12:41 pm

Mick wrote:Backup your database and try it.
;)
Support Toolkit | Support Request Template | Knowledge Base | phpBB 3.0.x documentation
I don't give support via PM or IM! (all unsolicited pms will be trashed!)

User avatar
DionDesigns
Registered User
Posts: 515
Joined: Sun Feb 26, 2012 11:22 pm
Location: Uncertain due to momentum.
Contact:

Re: after update to 3.0.8, apostrophes are ’

Post by DionDesigns » Fri May 04, 2012 6:42 pm

There should be no need for fancy "conversion tables"...make a backup of the table first, then try this:

Code: Select all

UPDATE phpbb_posts SET post_text = CONVERT(CONVERT(CONVERT(post_text USING latin1) USING binary) USING utf8)
You should also do the following:

Code: Select all

UPDATE phpbb_posts SET post_subject = CONVERT(CONVERT(CONVERT(post_subject USING latin1) USING binary) USING utf8)
UPDATE phpbb_topics SET topic_title = CONVERT(CONVERT(CONVERT(topic_title USING latin1) USING binary) USING utf8)

User avatar
joshuadenmark
Registered User
Posts: 35
Joined: Sat Aug 07, 2010 11:54 am
Contact:

Re: after update to 3.0.8, apostrophes are ’

Post by joshuadenmark » Sat Nov 23, 2013 9:22 am

DionDesigns wrote:There should be no need for fancy "conversion tables"...make a backup of the table first, then try this:

Code: Select all

UPDATE phpbb_posts SET post_text = CONVERT(CONVERT(CONVERT(post_text USING latin1) USING binary) USING utf8)
You should also do the following:

Code: Select all

UPDATE phpbb_posts SET post_subject = CONVERT(CONVERT(CONVERT(post_subject USING latin1) USING binary) USING utf8)
UPDATE phpbb_topics SET topic_title = CONVERT(CONVERT(CONVERT(topic_title USING latin1) USING binary) USING utf8)
Worked great on posts, thanks.

Is it possible to do the same "trick" on the private messages?

Best regards
Peter

Locked

Return to “[3.0.x] Support Forum”