Using 3.3.0 the "auto prone" feature seemed to deleted some users keeping their posts online and moving them to UID 1 (anonymous user).
In old 3.0.x days it was possible to undo that by re-registering a new user and fixing its relation to those 3 tables:
Code: Select all
UPDATE phpbb_posts SET `poster_id` = N WHERE `post_username` = 'the username'; UPDATE phpbb_topics SET `topic_poster` = N WHERE `topic_first_poster_name` = 'the username'; UPDATE phpbb_topics SET `topic_last_poster_id` = N WHERE `topic_last_poster_name` = 'the username';
What about the actual datamodel... what needs to be fixed today on 3.3.0? Any hints are highly appreciated!