I had some threads and posts showing as there, but the poster is " , " empty... i double checked the same threads / posts on the phpbb3 installation forum, the users are there, but when clicking on that user(s) it says they're deleted. So I ran the queries for threads
DELETE FROM thread WHERE postuserid='0';
and for posts
DELETE FROM post WHERE userid='0';
updated counters. done. that's fine.
The other issue is, some have posters listed there, but the dates are 01-01-1970. When clicking thread titles, it shows empty threads. I found another thread on here with similar issue from vBulletin 3.x.x but didn't offer much help at all.
https://www.vbulletin.com/forum/show...hreads-by-year


Is there any easy way to remove threads like this? As seen in that other similar thread above screenshots, apparently that guy figured out how many days back 1970 is and tried pruning that way, and still didn't work. I did run all the counters I could think of, and rebuild thread, rebuild search index, rebuild post counts, remove orphan threads and posts ... didn't work... How else can I mass handle these? Thanks
DELETE FROM thread WHERE postuserid='0';
and for posts
DELETE FROM post WHERE userid='0';
updated counters. done. that's fine.
The other issue is, some have posters listed there, but the dates are 01-01-1970. When clicking thread titles, it shows empty threads. I found another thread on here with similar issue from vBulletin 3.x.x but didn't offer much help at all.
https://www.vbulletin.com/forum/show...hreads-by-year
Is there any easy way to remove threads like this? As seen in that other similar thread above screenshots, apparently that guy figured out how many days back 1970 is and tried pruning that way, and still didn't work. I did run all the counters I could think of, and rebuild thread, rebuild search index, rebuild post counts, remove orphan threads and posts ... didn't work... How else can I mass handle these? Thanks