Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Template to Mail Merge
#1
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
Reply
#2
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!
Joe
TSolucio
Reply
#3
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
Reply
#4
have you applied the changeset?
Joe
TSolucio
Reply
#5
activate the debug log and show me the offending SQL
Joe
TSolucio
Reply
#6
Yes i did corebos updater apply
i've sended you a private message with link for log
Reply
#7
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
Joe
TSolucio
Reply
#8
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.
Reply
#9
I think the capitalization is important. See the example here:

https://github.com/tsolucio/corebos/tree/master/build/oo-merge
Joe
TSolucio
Reply
#10
I tried directly uploading the sample file.
and it works!
thanks a lot
Lorenzo
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)