No announcement yet.

Task Pdf Template

  • Filter
  • Time
  • Show
Clear All
new posts

  • Task Pdf Template

    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.

    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.

  • #2
    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.


    • #3
      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"


      • #4
        You seem to have access to the server, maybe look through this
        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.


        • espcrm
          espcrm commented
          Editing a comment
          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