XF 2.2 &amp in post titles and posts


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


XenForo moderator
Staff member
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.


Well-known member
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).