I already couldn't imagine I would be the only one facing this problem, luckily you tested it and can confirm it.
Maybe somewhere during an update in the past, USER_NEW field was introduced and pre-set with value "1".
Don't know, but the value of that field should not be used to determine if a user is actually new.
That is because the query does not look to the inactive day, but for the registration day, which is in your test case 2006; more then 30 days ago.leschek wrote:....
member since 2006
It even didn't wait for 30 days I set in "Delete inactive users:" option.
Wouldn't be a problem if it was working properly, but I really think the
USER_INACTIVE_REASONfield should be checked in the query instead of
there is your error.John P wrote:...
user_new is set to 0 if the user is removed from the NRG ...
In 2006 (for example), there was no NRG, it got introduced with phpBB 3.0.x if i recall correctly
Users registered before the date the board owner updated to phpBB 3.0.x never where in the NRG, so never got removed from the NRG, ergo: USER_NEW kept value 1.
Our board dates back from 2003, we updated from phpBB 2.x to phpBB 3.0.x somewhere 2012, so literally thousands of users ....
...that really explains...
come to think of it: WHAT when a board owner does not user the NRG ?
Newly registered users will not come into the NRG => never leave the NRG => USER_NEW keeps value of 1 ?
* NRG == Newly Registered users Group