Code: Select all
UPDATE phpbb_topics SET topic_first_poster_name = (SELECT username FROM phpbb_users WHERE user_id = topic_poster) WHERE topic_first_poster_name = '';If you use a different prefix don't forget to change
phpbb_ to the prefix that you've chosen during installation.