Closed (fixed)
Project:
Account reminder
Version:
6.x-1.0-beta2
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
18 Apr 2008 at 02:47 UTC
Updated:
23 May 2008 at 17:19 UTC
I have an account on one of my sites that has never been logged in. Cron runs on subject site once an hour, and today starting at around 5pm I got account reminder messages every hour for 5 hours. I've disabled the module for the time being.
Comments
Comment #1
jaydub commentedFresh install of this version or an upgrade from either Drupal 5 or
previous Drupal 6 version?
MySQL or PostgreSQL?
Comment #2
adam640kb commentedIt's an upgrade from a previous Drupal 6 version, not certain when the upgrade was installed (assuming the same day the issue started happening). Using MySQL. I will go ahead and uninstall and do a fresh install to see where that gets me. Thanks.
Comment #3
adam640kb commentedI've uninstalled the module, deleted all files and re-uploaded beta2, the issue still occured. I then tried beta1 again, issue doesn't occur. Uninstalled beta1, deleted all files, tried beta2 again, reminder emails are still sent on every cron run.
I was going to try deleting the 'never accessed' accounts and move forward with beta2. However, I took a look at all of my users and they all now report they have accessed the site, I'm not sure how/when this happened, but I know there were a handful of accounts that used to be listed as 'never' under 'last access'. I can verify that two of them never accessed the site. Not sure where to go from here.
More digging... checked the logs, after each entry for "Reminder email sent to..." the following four errors are logged:
array_fill() [function.array-fill]: Number of elements must be positive in /home/.katch/adam640kb/drupal/includes/database.inc on line 235.
implode() [function.implode]: Bad arguments. in /home/.katch/adam640kb/drupal/includes/database.inc on line 235.
array_keys() [function.array-keys]: The first argument should be an array in /home/.katch/adam640kb/drupal/modules/user/user.module on line 500.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT p.perm FROM default_role r INNER JOIN default_permission p ON p.rid = r.rid WHERE r.rid IN () in /home/.katch/adam640kb/drupal/modules/user/user.module on line 500.
Comment #4
jaydub commentedCan you try the development snapshot version?
http://ftp.drupal.org/files/projects/account_reminder-6.x-1.x-dev.tar.gz
There was one change that mistakenly didn't get into the beta2
release. I think this should address your problem and if so then
i'll make a new release.
Comment #5
adam640kb commentedExcellent, that appears to have fixed the issue for me. Thanks for the module and the help.
Comment #6
jaydub commented