Geeklog Forums

I have just started using the manual digest to email stories (1.3.7 sr2), When sending them out the mdigest plugin would not complete (lastemailed variable not set), but email would be sent - to more users than I would have expected. Looking at lib-common under the COM_emailUserTopics function I see:

// Get users who want stories emailed to them $usersql = "SELECT username,email,etids,{$_TABLES['users']}.uid AS uuid " . "FROM {$_TABLES['users']}, {$_TABLES['userindex']} " . "WHERE {$_TABLES['userindex']}.uid = {$_TABLES['users']}.uid AND (etids <> '-')";

By changing etids <> '-' to etids <> '' this seemed to correct the error, and the email was only sent to the correct people. The mdigest also completed properly. Maybe I've screwed something up somewhere else (user table?) if this isn't a bug.

The meaning of the etids field changed in 1.3.7. To quote from the source (usersettings.php):

bye, Dirk

Yep, that will be it - I returned it to '-' and changed the database table.... I also had the problem with the empty $grouplist that someone else reported - it was the same problem - group admin didn't belong to any groups...