I have mailhandler and listhandler happily importing a mailing list on a test site, and besides a couple of newbie/clueless moments, it went pretty smoothly.

But setting it up now on my "real" site I'm getting an odd SQL error. When I manually import mail from my mailbox with mailhandler, it complains:

* warning: array_keys(): The first argument should be an array in /home/.../modules/user.module on line 352.
* warning: implode(): Bad arguments. in /home/.../modules/user.module on line 352.
* user warning: 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 DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/.../includes/database.mysql.inc on line 121.

Can someone enlighten me as to what the problem might be?

Comments

IntnsRed’s picture

To answer my own question, it seems this error was generated by not having the ListHandler module enabled. I was trying to first get MailHandler working before I did anything with ListHandler (as per the instructions). I don't understand why MailHandler did not work alone, but hey, everything works great now. :-)

--
A GNU/Linux newbie since 1992!