Skip to main content

PluginMail fails sending to multiple groups

Status
Open
Subject
PluginMail fails sending to multiple groups
Version
15.x
Category
  • Error
Feature
Webmail
Resolution status
New
Submitted by
bfw25
Lastmod by
bfw25
Rating
(1)
Description

PluginMail fails when the address list contains two groups with users being members of both groups.

I tested with 3 groups:

Group10 (user11, user 12)
Group20 (user21, user 22)
Group30 (user11, user 12, user21, user 22, user31, user 32)
Sending mail to Group 10+Group20 works
Sending mail to Group 10+Group30 returns an error like

Copy to clipboard
System error. The following error message was returned: The query was: select `email` from `users_users` where `userId` in (?,?,?,?,?,?,?) Values: 1. 8 2. 9 3. 6 4. 7 5. 10 6. 11 7. 1 The built query was likely: select `email` from `users_users` where `userId` in ('8','9','6','7','10','11','1')

Workaround

Workaround 1:
A simple solution could be to address the groups one by one, however then some recipients will get the mail several times.

Workaround 2:
Try to edit file wikiplugin_mail.php
Replace in Line 267 in function wikiplugin_mail_to

$to = array_unique($to);

with

$to = array_values(array_unique($to));

Importance
8
Priority
40
Demonstrate Bug (Tiki 18
Please demonstrate your bug on show2.tiki.org
 About show2.tiki.org

To help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.

Version: Create show2.tiki.org instance
Demonstrate Bug (older Tiki versions)
This bug has been demonstrated on show.tikiwiki.org
 Accessing the Tiki instance that demonstrates this bug

The URL for the show.tikiwiki.org instance that demonstrates this bug is at: http://bfw-11773-6429.show.tikiwiki.org. Note that if you get a popup asking for a username/password, please just enter "show" and "show". This is different from the initial login and password for a new Tiki which is "admin" and "admin".

For the install log, see http://bfw-11773-6429.show.tikiwiki.org/info.txt

Note that if you see PHP errors or a Tiki claiming to be missing third party software, the instance creation is probably not finished. Please wait a couple minutes and reload.

 Snapshots

Snapshots are database dumps of the configuration that developers can download for debugging. Once you have reproduced your bug on the show.tikiwiki.org instance, create a snapshot that can then be downloaded by developers for further investigation.

Snapshots can be accessed at: http://bfw-11773-6429.show.tikiwiki.org/snapshots/. Note that if you get a popup asking for a username/password, please just enter "show" and "show".

Create new snapshot
Ticket ID
6429
Created
Monday 14 August, 2017 17:31:40 GMT-0000
by bfw25
LastModif
Friday 01 September, 2017 11:07:10 GMT-0000

Attachments

 filenamecreatedhitscommentversionfiletype 
No attachments for this item