Task Pdf Template

[mstzyrt]

I created a pdf theme for the task. But I couldn't show the attachments in pdf.
My current version: 5.7.11 version.
In updating to version 5.8, I get an error saying "SQLSTATE [HY000]: General error: 2006 MySQL server has gone away". The log file creates a 50 mb file each time an error is returned.
Log: https://drive.google.com/file/d/1mdx...ew?usp=sharing

To add the attached image file to the pdf;

<img src = "{{attachmentsIds}}">
<img src = "{{file attachmentsIds}}">

<img src = "{{attachmentsNames}}">



I tried but could not succeed in any of them.

In the new version, I can add images, but I cannot use it because I cannot update the software.

I would like to ask you for your help in updating or adding images before version 5.8.0.

Thank you Espo Crm Family.

[esforim]

Are you upgrading through the Admin menu or through CLI/SSH?

I get that error too because I'm on shared hosting and they restrict how many and how long can connection stay alive for. If your server allow, you can try increase the PHP Timeout time and maximum concurrent user for MySQL.

[mstzyrt]

Thank you for the answer.
I am upgrading from the admin menu. The same problem persists even though I set max_execution_time = 900.
"SQLSTATE [HY000]: General error: 2006 MySQL server has gone away"

[esforim]

You seem to have access to the server, maybe look through this https://stackoverflow.com/questions/...-has-gone-away
to see if you can change some of the setting too, especially the wait_timeout

I remember there was also a "max user" or something along this line when I talked to my hosting, I ask them to increase it but they said no I have to upgrade to VPS.

Lastly, it is also related to the PHP extension PDO I believe, you can try nd_PDO extensions to see if it work for you, I know some of my nd_ version work for whereas some nd_ will totally crash the server.

[esforim]

wait_timeout - Time in seconds that the server waits for a connection to become active before closing it.
interactive_timeout - Time in seconds that the server waits for an interactive connection.
max_allowed_packet - Maximum size in bytes of a packet or a generated/intermediate string. Set as large as the largest BLOB, in multiples of 1024