Jump to content

Recommended Posts

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

Share this post


Link to post
Share on other sites
  • 4 weeks later...

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.

Share this post


Link to post
Share on other sites
  • 1 month later...

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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More