Template to Mail Merge - Printable Version +- CoreBOSBB (https://discussions.corebos.org) +-- Forum: Support (https://discussions.corebos.org/forum-17.html) +--- Forum: User Support (https://discussions.corebos.org/forum-6.html) +--- Thread: Template to Mail Merge (/thread-574.html) Pages:
1
2
|
Template to Mail Merge - LorenzoGreco - 02-21-2017 I was unable to use Template to mail merge, in contact modules, I tried with rtf, (made with wordpad) .doc (microsoft) but i've always a fatal error Fatal error: Call to a member function FetchRow() on boolean in /home/xxxxxxxx/public_html/vt_test/include/database/PearDatabase.php on line 618 I'm using php 5.6 but i've tried also with 7 and 5.5 without UUID, opcache enabled any ideas? Lorenzo RE: Template to Mail Merge - joebordes - 02-21-2017 well, that was interesting. I hadn't visited that part of the code in a while, specially after the massive update we have made for PHP7 and MYSQL support. I have cleaned and tested the files. I eliminated a bunch of warning message and fixed a couple of errors, mostly related to MySQL strict mode. It seems to be working correctly now for all four supported modules. Update you code when you can and give it a try. Note: I have tried OpenOffice document and I am almost sure RTF will work. I truely doubt Microsoft will work because they used an ActiveX component which is most probably totally obsolete, but give it a shot and let us know how it goes. Thanks! RE: Template to Mail Merge - LorenzoGreco - 02-22-2017 git pull Tried now also with a native ODT document so made NOME: $contacts-firstname$ COGNOME: $contacts-lastname$ CITTA’ NASCITA: DATA NASCITA: $contacts-birthday Fatal error: Call to a member function FetchRow() on boolean in /home/XXXXXXXX/public_html/vt_test/include/database/PearDatabase.php on line 621 whith php 5.6 P.S. I've custom fields in contact module RE: Template to Mail Merge - joebordes - 02-22-2017 have you applied the changeset? RE: Template to Mail Merge - joebordes - 02-22-2017 activate the debug log and show me the offending SQL RE: Template to Mail Merge - LorenzoGreco - 02-22-2017 Yes i did corebos updater apply i've sended you a private message with link for log RE: Template to Mail Merge - joebordes - 02-22-2017 That did the trick (I hope). There was a missing condition in Contacts, Leads and Tickets. Update your code and try again. Let me know how it goes https://github.com/tsolucio/corebos/commit/b291afc735678aa3ca0a1fef5cae4bbef8cad0dd RE: Template to Mail Merge - LorenzoGreco - 02-22-2017 quite... so now i arrive to Download merged document ( openoffice format) I downloaded the file, but was NOME: $contacts-firstname$ COGNOME: $contacts-lastname$ CITTA’ NASCITA: DATA NASCITA: $contacts-birthday doesn't merge the field. RE: Template to Mail Merge - joebordes - 02-22-2017 I think the capitalization is important. See the example here: https://github.com/tsolucio/corebos/tree/master/build/oo-merge RE: Template to Mail Merge - LorenzoGreco - 02-22-2017 I tried directly uploading the sample file. and it works! thanks a lot Lorenzo |