Quote Originally Posted by Wulf359 View Post
This site has begun pulling this error after upgrading to 1.5.7b:
ZC1.5.7b, in version 3.1 of this mod (zen_admin_demo) was replaced, but after looking, it was one area that was untouched and needed some more work. You may still be using an older version of the admin page.. I would pull a copy off GitHub and compare. I just pushed up the change as follows..
Code:
        case 'purgeunconfirmed':
           
           $expireTest = $db->Execute('SELECT COUNT(*) AS total FROM ' . TABLE_SUBSCRIBERS . ' WHERE confirmed != 1 and (customers_id IS NULL or customers_id = 0) and DATE_SUB(CURDATE(),INTERVAL 30 DAY) > subscribed_date ');
          if($expireTest->fields['total'] > 0) {
            $db->Execute('delete from ' . TABLE_SUBSCRIBERS . ' where confirmed != 1 and (customers_id IS NULL or customers_id = 0) and DATE_SUB(CURDATE(),INTERVAL 30 DAY) > subscribed_date ');
            $messageStack->add(TEXT_INFO_SUBSCRIPTIONS_PURGED, 'success');
          } else {
            $messageStack->add(TEXT_ERROR_SUBSCRIPTIONS_PURGED, 'info');
          }
          
          $action = '';
         break;
Well send an update shortly..