Duplicate Topic Title search in phpBB3
Posted: 2026-04-01, 06:41
phpmyadmin select database phpBB3 query paste the following then exec
Code: Select all
SELECT topic_title, topic_time, forum_id, topic_first_post_id, topic_first_poster_name, topic_id, topic_poster, COUNT( * ) TotalCount
FROM phpbb_topics
GROUP BY topic_title
HAVING COUNT( * ) >1