mattheoh

here are all the special characters I had in URLS and I replace in the database !

UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#233;’, ‘é’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#234;’, ‘ê’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#232;’, ‘è’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#224;’, ‘à’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#200;’, ‘è’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#235;’, ‘?’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#238;’, ‘?’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#169;’, ‘?’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#239;’, ‘?’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#231;’, ‘?’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#201;’, ‘é’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#252;’, ‘ü’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#226;’, ‘a’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#8364;’, ‘€’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#199;’, ‘?’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#246;’, ‘?’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#251;’, ‘?’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ‘&#185;’, ‘1’ ) ;

the main are well read by your plugin (é,à,è ..)
it seems that some are not (€,?…) but that’s not really allowed characters in URL , so that’s completely normal I guess.

Thanks again for your help and time.
I put the topic solved.

I think I m going to execute my SQL query, and I will see to correct the display images problem in a second time.
After that, I will confirm you that I have no more broken links.
Thanks again for your precious help.

OK, I activated the log trace.
I ll see what it says.

last question.
When I replace all the special HTML characs in the database ( example : &_#_2_3_3_; per é), your plugin works well and doesn’t mark these kind of links as broken.
the only problem I have if I do that, is that the images don’t display no more on the website (but I can display it alone in the browser – open image in a new window)
I know it’s out from your plugin but would you have an idea, to make them display well in the post ?! :-/
Thanks again for your time.

My answers :

– That URL contains an HTML entity and not a plain UTF-8 character, correct?
=> here’is an URL marked as broken copied from a post :
https://www.mafamillezen.com/wp-content/uploads/2010/04/fess&_#_2_3_3_;e.jpg
(I just added the underscores to answer you, if not you would see a normal é)

– You started started the global recheck after installing the development version, yes?
=> Yes, i push the button to force recheck after the update yesterday

– As a test, you can force the plugin to re-parse a specific post by making some minor change, like editing a single word or adding a line break.
=> where is this option ? what do you want me to add /modifiy exactly in the post ?.

You looked at the database before. Could you also verify that the “wp_blc_links” table uses the “utf8” character set?
=> utf8_general_ci

The “url” column is especially important in this case and should also use “utf8”.
=> utf8_bin

Take a look at the “wp_options” table. What is the “blog_charset” option set to?
=> UTF-8

Does the character set of the “wp_blc_links” table match the character set of the “wp_posts” table?
=> I can’t see directly in the database cause it’s blob format, but if I open the blob file from URL column for the example I gave you in the previous post. I have this URL : https://www.mafamillezen.com/wp-content/uploads/2010/04/fess
that means I don’t have the HTML character and the URL is cut as I see it in the back office.

Thanks again !

unfortunately, doesn’t seem to work…
for example this URL : https://www.mafamillezen.com/wp-content/uploads/2010/04/fessée.jpg

is still marked as broken (see capture) : https://i.imgur.com/eWXRIT6.png
the URL noticed by the plugin is cut, where there is the special character.

I updated it. thanks.
I just sent a global recheck of the links.
It will take a few hours.
I will tell you tomrrow, if my links with raw characters are still marked as broken links.
Thanks again for your help.

lol ! sorry it was tranformed when I publish the comment :-/
I m going to put an undersocre between each charachter :
for example : é in my database is inserted as &_#_2_3_3_;

Thanks for the fast answer.
I went further… in fact , my special characters like ” é ” are inserted in the post-content column in wp-posts table as ” é “
that’s this type of character I think your plugin can’t decode.
I made an SQL query in the database, to change all this ” é ” per ” é “
and it seems after that your plugin can read the url with special characters. (I will confirm you cause it’s still scanning)
Unfortunately for me, when I do that, my images (with special char) can’t display no more in the website ?? (despite of they can be read by the browser when I display them alone)
In my case it seems , I haven’t any good solution…

Your link worked as a charm !
Thanks Damian.

Hi,
Is it possible to send me the link to automtically transform pending users, waiting you commit your correction in the extension files ?
Other thing, did you see my remark about auto login ?
Thanks per advance.

I just tested the new update.
I made a new inscription and indeed my user was automatically activated !
that’s perfect, thanks Damian.

Just two notes :
1. the link on fix doesn’t seem to work. (no action)
Javascript problem or mistake in the code ?
here’s a picture : https://hpics.li/01f045b

2. I put the auto login on enabled and it wasn’t the case, when I made my inscription… did you notice that ?

Thanks again for this new update !

Thanks a lot Damian for your quick answer and solution ! ??

Hi,

I got the same problem here (WP 3.9.2, Buddy Press 2.0.1 and BP DAR 1.1)
someone found a solution ?

I just saw I have 1700 pendings user ! and not sure about the fact WP recognizes them as activated (everything OK with BP) ;-/

Thanks per advance