
Question about the notification about inactivity for Micha (Technics)
Hello
In both cases I get a warning.
I think, it is a auto-cast problem.
Yes, you are right.
Please use the data base table instead of this query. Check out the true result using
SELECT `last_login`, (`last_login` - (NOW() - INTERVAL 3 YEAR)) FROM `mlf2_userdata` WHERE `user_lock` = 0 AND `user_type` = 0 AND `inactivity_notification` = FALSE ORDER BY `last_login` ASC;
I took the query, executed it with and without the user_type
and with addition of the name and the (optional) addition of AND `last_login` > (NOW() - INTERVAL 3 YEAR)
. In every case I get the correct results.
*btw*: IMHO AND `last_login` > (NOW() - INTERVAL 3 YEAR)
has a better readability than AND (`last_login` - (NOW() - INTERVAL 3 YEAR)) < 0
even both conditions work.
Tschö, Auge
--
Trenne niemals Müll, denn er hat nur eine Silbe!
Complete thread:
- Question about the notification about inactivity for Micha -
Auge,
2022-05-09, 21:15
- Not receiving password reset emails -
bers,
2022-05-10, 05:28
- Not receiving password reset emails -
Micha,
2022-05-10, 06:29
- Not receiving password reset emails -
bers,
2022-05-10, 11:04
- Not receiving password reset emails -
Micha,
2022-05-10, 13:48
- Not receiving password reset emails -
bers,
2022-05-11, 04:39
- Not receiving password reset emails -
Auge,
2022-05-11, 06:26
- Not receiving password reset emails - bers, 2022-05-11, 07:36
- Not receiving password reset emails -
Micha,
2022-05-11, 07:28
- Not receiving password reset emails -
bers,
2022-05-11, 07:40
- Not receiving password reset emails -
Micha,
2022-05-11, 08:14
- Not receiving password reset emails -
bers,
2022-05-13, 08:45
- Not receiving password reset emails - bers, 2022-05-13, 08:55
- Not receiving password reset emails -
bers,
2022-05-13, 08:45
- Not receiving password reset emails -
Micha,
2022-05-11, 08:14
- Not receiving password reset emails -
bers,
2022-05-11, 07:40
- Not receiving password reset emails -
Auge,
2022-05-11, 06:26
- Not receiving password reset emails -
bers,
2022-05-11, 04:39
- Not receiving password reset emails -
Micha,
2022-05-10, 13:48
- Not receiving password reset emails -
bers,
2022-05-10, 11:04
- Not receiving password reset emails -
Micha,
2022-05-10, 06:29
- Question about the notification about inactivity for Micha - Micha, 2022-05-10, 06:28
- Answering the question about the inactivity notification -
Auge,
2022-05-12, 18:07
- Answering the question about the inactivity notification -
Micha,
2022-05-12, 19:07
- Answering the question about the inactivity notification -
Auge,
2022-05-13, 12:12
- Answering the question about the inactivity notification - Micha, 2022-05-13, 12:29
- Answering the question about the inactivity notification -
Auge,
2022-05-13, 12:12
- Answering the question about the inactivity notification -
Micha,
2022-05-12, 19:07
- Question about the notification about inactivity for Micha -
Auge,
2022-05-12, 18:25
- Question about the notification about inactivity for Micha -
Micha,
2022-05-12, 19:28
- Question about the notification about inactivity for Micha -
Auge,
2022-05-13, 08:02
- Question about the notification about inactivity for Micha -
Micha,
2022-05-13, 08:08
- Question about the notification about inactivity for Micha - Auge, 2022-05-13, 11:46
- Question about the notification about inactivity for Micha -
Micha,
2022-05-13, 08:08
- Question about the notification about inactivity for Micha -
Auge,
2022-05-13, 08:02
- Question about the notification about inactivity for Micha -
Micha,
2022-05-12, 19:28
- Not receiving password reset emails -
bers,
2022-05-10, 05:28