Advanced Search - problems with special character in forum titles

[MrNase]

Hello there!

I just upgraded my test board to 3.8.0 RC2 and I think I found a problem with special characters in forum titles at the advanced search.

It doesn't display the quotes found in the name of the forum but it displays the HTML-code instead.



die Mercedes Benz „Pagode“


The first screenshot is from 3.7.5 (my live board), the second one is from 3.8.0 RC2.

[Scott MacVicar]

I can't reproduce this? What is in the database for that forum?

[MrNase]

vBulletin 3.7.5
forum.title -> die Mercedes Benz & #0132;Pagode& #0147; (without the spaces)
forum.title_clean -> doesn't even exist.


vBulletin 3.8.0 RC2
forum.title -> die Mercedes Benz & #0132;Pagode& #0147; (without the spaces)
forum.title_clean -> die Mercedes Benz „Pagode“

[Scott MacVicar]

ok title_clean was added in 3.5.0 beta 2, are you sure its missing?

I'm unsure how the entities get double encoded, as we use htmlspecialchars_uni in the forum dm, can you try editing it and removing the extra amp and see what happens?

[MrNase]

Sure, I'll update my post with the new information. :)

Bild 1.png -> 3.7.5
Bild 2.png -> 3.8.0 RC2

I now removed the & from forum.title_clean but the problem still exists.


Ok, I think I found the solution: I edited the forum in question and saved it without a change. Now the database looks like shown in attachment 'Bild 3.png'. :)

[Mike Sullivan]

I just noticed that the schema order between the 3.7.5 and 3.8.0 RC2 DBs is different, so that would indicate that it's not simply an upgrade.

How'd you get that data into 3.8 then? ImpEx? There's nothing that would change that data between 3.7 and 3.8.

[MrNase]

I used Impex several months ago but I was using 3.7.2 or even an older version. :)

[Mike Sullivan]

This sounds like an ImpEx bug to me then, so I'll move this to that project.

[Jerry]

Which if the images are which ? Which is an imported one and which is newer ?

I'd need to know the source system as well.

Though to fix this, update your forum titles and descriptions and save them in the forum manager.