Mailhandler array_keys() and sql syntax errors
| Project: | Mailhandler |
| Version: | 6.x-1.8 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | fixed |
Jump to:
Hello. I have mailhandler installed and setup a mailbox. The connection to the email address seems to be working fine. When I use the 'Retrieve' link on the mailhandler setting page I get a message that the message was received followed by 4 separate errors. I'm retrieving mail from a Google Apps mailbox. I have my create node permissions properly set and I'm emailing from a registered user's email address. It seems to be a permissions issue but I don't know where to go from here. Here are the errors I'm receiving.
* warning: array_fill() [function.array-fill]: Number of elements must be positive in /var/www/vhosts/domain.name/httpdocs/includes/database.inc on line 241.
* warning: implode() [function.implode]: Invalid arguments passed in /var/www/vhosts/domain.name/httpdocs/includes/database.inc on line 241.
* warning: array_keys() [function.array-keys]: The first argument should be an array in /var/www/vhosts/domain.name/httpdocs/modules/user/user.module on line 502.
* 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 p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /var/www/vhosts/domain.name/httpdocs/modules/user/user.module on line 502.
Thanks for any help or clues you can offer.
#1
I get the same thing. Anyone have a solution?
#2
I doubt it's related to the mailbox itself (Google apps), but just in case - try configuring another mailbox and see if the problem remains.
Also (perhaps more important), what are your default commands, and which commands do you pass in the mail itself?
#3
The command I pass in the mail is '/ssl' (without the quotes). I don't have any default commands set. The only instructions I found for these were related to taxonomy and the pages editable through the mailhandler do not use taxonomy terms. Did I mention the mailhandler mailbox was set to check an IMAP account?
I just tried setting up a new mailbox and I get the same error. Would it help to post what my full mailbox settings are?
thanks for your help!
#4
If you don't specify any "type" command in the default commands, mailhandler tries to create a blog type. Do you have such a content type?
#5
What command can I use to write to an 'announcement' content type? The only instruction in the Help file I see is for Taxonomy terms?
Thanks.
#6
type: announcement