I've added webform2pdf to one site recently, and I'm now strugling with sending the resulting PDF through e-mail. After submitting the form I'm presented with following error message:
- 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 ') ORDER BY sid ASC, cid ASC, no ASC' at line 1 query: SELECT s.*, sd.cid, sd.no, sd.data, u.name, u.mail, u.status FROM webform_submissions s LEFT JOIN webform_submitted_data sd ON sd.sid = s.sid LEFT JOIN users u ON u.uid = s.uid WHERE sd.nid = 0 AND s.sid IN () ORDER BY sid ASC, cid ASC, no ASC in /data/www/seniorpraha.cz/www.seniorpraha.cz/sites/all/modules/webform2pdf/webform2pdf.module on line 502.
- warning: Invalid argument supplied for foreach() in /data/www/seniorpraha.cz/www.seniorpraha.cz/sites/all/modules/webform2pdf/webform2pdf.module on line 231.
- warning: Invalid argument supplied for foreach() in /data/www/seniorpraha.cz/www.seniorpraha.cz/sites/all/modules/webform2pdf/webform2pdf.module on line 278.
The e-mail arrives to my mailbox, but the attached PDF is blank, with only one czech word "není" - which can be translated to English as "none".
When I try to open the PDF from the results table, it is possible, but there are no psecial czech characters (ěščřžýáíé) - so it is not usable.
I've used this module on another site, without this problems.
Can you please direct me to some solution?
I'm running D6.22, Webform 3.11, Webform2PDF 2.2, MimeMail 6.x-1.0-beta2 on PHP 5.3.6 server.
If you need additional info, just ask.
Thank you in advance.
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | webform2pdf-issue-1248974.patch | 4.77 KB | BBaptiste |
| #2 | webform2pdf-issue-1248974.patch | 4.76 KB | mr.york |
Comments
Comment #1
petr illekEDIT: "When I try to open the PDF from the results table, it is possible, but there are no psecial czech characters (ěščřžýáíé) - so it is not usable." it's apparently not module problem. I've seen this behaviour on Mac OS, but on Win (Vista) all the characters are correct. It's weird.
The rest of issue is still active.
EDIT2: After some more digging, I've narrowed the problem. There is something wrong between Webform2PDF and MimeMail module. Because as soon as I disabled the MimeMail, everthing just works. But I need the MimeMail module to sending simplenews html e-mails.
So this is not a solution for me. :(
Comment #2
mr.york commentedYou can try to resolve character encoding problems by changing character type in the template settings.
6.x-2.2 already supports mimemail-6.x-1.0-beta2. Please try this patch, if it resolve this problem.
Comment #3
BBaptiste commentedHello,
I've the same error. When submitting a Webform have no PDF attached to the mail sent if the Mime Mail module is enabled.
But if the Mime Mail module is disabled, Webform2PDF works !
Patch on #2 doesn't work.
I use : Mime Mail 6.x-1.0-beta2 / Webform 6.x-3.14 / WebForm2PDF 6.x-2.2
Comment #4
BBaptiste commentedProblem resolved for me, can you try this patch ?
$message['attachments'][] = $a;$message['params']['attachments'][] = $attachments;Comment #5
mr.york commentedThanks, committed to webform2pdf 6.x.
Comment #7
bevin commentedThanks. But the patch #4 doesn't work for me. Still no PDF attachement in email.
I am using webform-6x-3.1, mime-6x-1.1, webform2pdf-6x-2.3
Can anybody fix this bug?