2006 MySQL server has gone away Error while saving H5P content

Submitted by jeanpaulbouvet on Mon, 01/25/2021 - 12:16
Forums: 
Installation and server related problems

I'v no problem on my own local server with H5P on Drupal 8, it works perfectly. But with the same installation on the shared Hosting (Hostinger) I work with, I can use all H5P Content except Branching Scenario, Column, Course Presentation, Image Pairing, Interactive Book. I have changed any PHP parameters I can change (because of the limitation of Sharing Hosting) :

  • max_execution_time : 120
  • max_input_time: 240
  • max_input_vars: 5000
  • memory_limit: 512
  • post_max_size: 256
  • upload_max_filesize: 256

but oftentimes when I save these contents I have an error "Message Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away:" an then send back to the adresse the_ site/core/install.php.

I have seen on differents Forums that it could be the mysql value of max_allowed_packet not high enough. But on Sharde Hosting I cannot change the value. And the School where I have to install the site only have Shared Hosting. Is there a solution because we need mostly Presentation Curse and Interactive Video.

Thank you for helping

JPB

We work with Drupal core 8.9.13  + H5P - 8.x-1.0-rc17

NB: I have notice that with Opigno 1 (drupal 7) H5P on this Shared Hosting all contents work perfectly