Template to Mail Merge

[LorenzoGreco]

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

[joebordes]

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!

[LorenzoGreco]

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

[joebordes]

have you applied the changeset?

[joebordes]

activate the debug log and show me the offending SQL

[LorenzoGreco]

Yes i did corebos updater apply
i've sended you a private message with link for log

[joebordes]

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

[LorenzoGreco]

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.

[joebordes]

I think the capitalization is important. See the example here:

https://github.com/tsolucio/corebos/tree/master/build/oo-merge

[LorenzoGreco]

I tried directly uploading the sample file.
and it works!
thanks a lot
Lorenzo