Duplicate [1.2] Error when @ was used in an old post without username


Well-known member
I'm working on a conversion follow-up, and while trying to remove some left-over HTML tags, I came across an error related to a user using the "@" sign in a post. It was basically a replacement of the word "at", but the new tagging functionality caused the forum to throw an error because no username was following the @ sign:

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM xf_user AS user WHERE () ORDER BY LENGTH(user.username) DESC' at line 3 - library/Zend/Db/Statement/Mysqli.php:77