[@netweb Keymaster 10 years, 6 months ago]

I’ve just got my copy of Xenforo up and running locally, I don’t have an issue with reply authors here, see this screenshot https://cloudup.com/c_epfx4Q4z8

Can you open up phpMyAdmin and run this SQL query on your Xenfor database:

SELECT 
convert(post.post_id USING "utf8mb4") AS post_id,
convert(thread.thread_id USING "utf8mb4") AS thread_id,
convert(post.thread_id USING "utf8mb4") AS thread_id,
convert(post.user_id USING "utf8mb4") AS user_id,
convert(post.message USING "utf8mb4") AS message,
convert(post.post_date USING "utf8mb4") AS post_date 

FROM xf_post AS post 
LEFT JOIN xf_thread AS thread 
USING (thread_id) 
WHERE thread.first_post_id != post.post_id 

You might have to change the following two lines if your database does not use xf_ as the forum prefix:

From:

FROM xf_post AS post 
LEFT JOIN xf_thread AS thread 

To:

FROM myprefix_post AS post 
LEFT JOIN myprefix_thread AS thread