MySQL Query worked in 3.23 but not 4.1 (Help Requested)

[WetWired]

Hmm, well, if you're running

'DELETE FROM user WHERE (lastvisit<'.(time() - (60 * 60 * 24 * 487)).') AND (usergroupid IN (2, 3, 10, 11))'

and you're not getting any deletions, maybe there aren't any users that meet the criteria. Really, though, shouldn't you be doing a

'SELECT userid FROM user WHERE (lastvisit<'.(time() - (60 * 60 * 24 * 487)).') AND (usergroupid IN (2, 3, 10, 11))'

then doing a delete for each user table? Otherwise, you leave a whole bunch of orphaned records in your DB; in fact, I think the usertext table entry will usually be larger than the user table entry if the user was ever active.