num47 Posted January 5, 2021 Share Posted January 5, 2021 I was trying to install the new latest release of Prestashop 1.7.7.0 and i was getting this error at the final step. ERROR [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" ["exception" => PDOException { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => "SQLSTATE[HY000]: General error: 2006 MySQL server has gone away"] Can anyone tell me what seems to be the problem? Link to comment Share on other sites More sharing options...
PrestaServicePro Posted January 5, 2021 Share Posted January 5, 2021 Hi, Check this link: https://stackoverflow.com/questions/33250453/how-to-solve-general-error-2006-mysql-server-has-gone-away timeout issue and need to set it higher Link to comment Share on other sites More sharing options...
num47 Posted January 5, 2021 Author Share Posted January 5, 2021 2 hours ago, PrestaServicePro said: Hi, Check this link: https://stackoverflow.com/questions/33250453/how-to-solve-general-error-2006-mysql-server-has-gone-away timeout issue and need to set it higher Thanks a lot for your reply. I PHP script is given there but this time out problem should not be happening on prestashop, i guess. Can you kindly give me an idea if i have to change something on the pretashop code or update something on my web server? Thank you again Link to comment Share on other sites More sharing options...
PrestaServicePro Posted January 6, 2021 Share Posted January 6, 2021 Hi, Contact your host provider and ask to increase it to the max value: memory_limit max_execution_time Link to comment Share on other sites More sharing options...
num47 Posted January 8, 2021 Author Share Posted January 8, 2021 On 1/6/2021 at 4:11 PM, PrestaServicePro said: Hi, Contact your host provider and ask to increase it to the max value: memory_limit max_execution_time memory_limit = 512 M max_execution_time = 300 second That should do it, right? But, i am still facing the problem. Any idea, bro? Link to comment Share on other sites More sharing options...
Lucio Crusca Posted March 27, 2021 Share Posted March 27, 2021 @num47 I'm facing the same problem as yours, tried the same solutions and I'm still stuck there. Did you manage to solve it? Link to comment Share on other sites More sharing options...
num47 Posted March 27, 2021 Author Share Posted March 27, 2021 2 hours ago, Lucio Crusca said: @num47 I'm facing the same problem as yours, tried the same solutions and I'm still stuck there. Did you manage to solve it? To be honest, nope, couldn't find any solution. Most likely it was a problem with the server configuration. MySql connection wasn't keeping up long enough for the installation. I had to use softaculous to install it. Later, I have installed 1.7.7.2 later by myself without facing any trouble. Maybe my server provider had fixed the issue by then. You try to install 1.7.7.2 and see if you can install it without facing any trouble. If it shows you the problem then it could be the server that is causing the problem. Link to comment Share on other sites More sharing options...
leonardomarinio Posted August 11, 2021 Share Posted August 11, 2021 On 27/3/2021 at 10:49, num47 said: Para ser honesto, no, no pude encontrar ninguna solución. Lo más probable es que haya sido un problema con la configuración del servidor. La conexión MySql no se mantuvo el tiempo suficiente para la instalación. Tuve que usar softaculous para instalarlo. Más tarde, instalé 1.7.7.2 más tarde por mí mismo sin enfrentar ningún problema. Quizás mi proveedor de servidor ya había solucionado el problema. Intenta instalar 1.7.7.2 y vea si puede instalarlo sin tener ningún problema. Si le muestra el problema, entonces podría ser el servidor el que está causando el problema. Hola, pudieron solucionarlo? Tengo el mismo problema al instalar PS 1.7.7.4 y 1.7.7.5 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now