XF 2.2 &amp in post titles and posts

[gavpeds]

Moved to xenforo from IPS and in several titles etc we have &amp instead of just & any way to fix this?

 

[Paul B]

You can use a query such as:

UPDATE xf_thread SET title = REPLACE(title, '&amp', '&');

Take a backup first just in case there are unexpected results.

Make sure you report the bug for the importer.

 

[Mendalla]

In my working life where I do a fair bit of db work, I generally do a SELECT using the criteria before an UPDATE to see what I am likely going to affect. Avoids surprises, though I can't see too many for something like this.

So SELECT * FROM xf_thread WHERE title LIKE '%&amp%' (or something like that, I've never had to query for something like &amp before).