X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Ftask_functions.php;h=47d9f1cd55552040cb6d6c625010e1294cac918a;hp=13ddfd2bb38022c063f19ae8acd7ee3c47466791;hb=0fada672e2066043b76ed5d57f852f451a49a3a3;hpb=e1cf98e08d4d92edf492396b82c67efa97a0ece8

diff --git a/inc/libs/task_functions.php b/inc/libs/task_functions.php
index 13ddfd2bb3..47d9f1cd55 100644
--- a/inc/libs/task_functions.php
+++ b/inc/libs/task_functions.php
@@ -274,7 +274,7 @@ ORDER BY
 
 	if ((isExtensionInstalledAndNewer('sql_patches', '0.3.4')) && (isExtensionActive('user'))) {
 		// Check for accounts without referal
-		addSql("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `refid`=0 ORDER BY `userid` ASC");
+		addSql("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `refid`=0 OR `refid` IS NULL ORDER BY `userid` ASC");
 		$DESCRs[] = '{--ADMIN_TASK_LIST_ACCOUNT_NOREF--}';
 		$TITLEs[] = '{--ADMIN_TASK_LIST_ACCOUNT_NOREFERAL_TITLE--}';
 		$WHATs[]  = 'list_user&mode=norefs';