General error: 2006 MySQL server has gone away

[edwinLeal]

Hola a todos,

Estoy intentando instalar prestashop, y todo va bien hasta que llega a la parte de instalación de módulos Addons. Se queda pensando hasta que me sale el siguiente error:

" Se ha producido un error durante la instalación...

Puede utilizar los enlaces que se encuentran en la columna de la izquierda para volver a los pasos anteriores, o también reiniciar el proceso de instalación haciendo clic aquí.

1: An exception occurred while executing 'SELECT t0.id_tab AS id_tab_1, t0.id_parent AS id_parent_2, t0.position AS position_3, t0.module AS module_4, t0.class_name AS class_name_5, t0.route_name AS route_name_6, t0.active AS active_7, t0.enabled AS enabled_8, t0.hide_host_mode AS hide_host_mode_9, t0.icon AS icon_10 FROM ps_tab t0 WHERE t0.class_name = ? LIMIT 1' with params ["AdminGamification"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away "

He buscado soluciones pero no encuentro ninguna para mi caso. Podría alguien ayudarme a solucionarlo??

Gracias, un saludo

[Callie]

I've encountered this a number of times and I've normally found the answer to be a very low default setting of max_allowed_packet.

Raising it in /etc/my.cnf (under [mysqld]) to 8 or 16M usually fixes it. (The default in MySql 5.7 is 4194304, which is 4MB.)

[mysqld] max_allowed_packet=16M

Note: Just create the line if it does not exist

Note: This can be set on your server as it's running.

Use set global max_allowed_packet=104857600. This sets it to 100MB.

[Mikein]

Hi all. 

I have the same error as the user above, once the process reaches 75% it fails at installing addons modules with the following message: 

Quote

1: An exception occurred while executing 'SELECT t0.id_tab AS id_tab_1, t0.id_parent AS id_parent_2, t0.position AS position_3, t0.module AS module_4, t0.class_name AS class_name_5, t0.route_name AS route_name_6, t0.active AS active_7, t0.enabled AS enabled_8, t0.hide_host_mode AS hide_host_mode_9, t0.icon AS icon_10 FROM ps_tab t0 WHERE t0.class_name = ? LIMIT 1' with params ["AdminGamification"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

I am using cPanel 94.0.4 and PHP version 7.2 (using Chrome also). Some of the configuration parameters of this PHP are:

max_execution_time = 30

max_input:tim = -1

max_input_vars = 30000

memory_limit = 1024M

post_max_size = 2048M

upload_max_filesize = 2048M

Any ideas would be more than welcome, I don't know what else to try. 

Thanks!