[solved]MySQL server has gone away

[CJH]

I have Prestashop v1.6; it's a long-running site with no major problems. I have made no changes recently, no alterations in modules or back office settings, but today I have lost access to the back office. Instead, I have an error page: MySQL Server has gone away. Then:

UPDATE `xx_configuration` SET `value` = '1508599399',`date_upd` = '2017-10-21 16:24:25' WHERE `name` = 'PRESTO_CHANGEO_UC' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1

Then follows a list of more specific errors. These seem to relate to the Presto Changeo module for CategoryQuantityDiscount (which I use on the site, successfully until now).

I'm now having problems regaining Back Office and need some advice. I've tried so far:

• Checked database size - this is well within permitted requirements by the ISP, rather than being too large.
• When I attempt to access the back office, the page takes a long time to try to load then times out (I presume) with the error message. I found an old reference to the _UC note in the error that indicates it is something to do with time. One suggestion was to delete cache/class_index.php; I did, it replaced itself but made no difference.
• The module appears under Modules and also Modules in the Theme. Disabling both by renaming them produces no difference in loading Back Office, but the website itself (which otherwise works) then fails to load correctly
• Renaming the main Modules folder of course causes a total error for the website loading, but the Back Office now loads (empty of everything but the heading etc, but it does now load)
• php settings are quite high for timeouts (10000, memory limit 256M) and have worked for many months

 

So I feel stuck. If it is this module (which I don't understand enough about code and stuff to mean that I am correct in what I am trying to do)< as opposed to some other module or group of modules, I cannot solve things by deleting it alone. I'm unsure if the cache is involved - but I'm unclear what I can delete within this (must I keep all the folders, or can I delete every file in the cache and also the theme/cache?). And even in my notes, I'm unsure what to rely on as being a correct thing to have tried.

Help please?

 

 

 

[selectshop.at]

You have access to database, or not ? If yes disable the module on table ps_module. 1 is for active, 0 is for deactivated.

[selectshop.at]

Ask also provider if there were some updates made on the server. Perhaps he updated the php-version, or something else...

[CJH]

Thank you so much for your help. I do have access to the database, through the phpadmin on the ISP website. I didn't have a table for modules, but there is one for 'module'. In this I set categoryquantitydiscount to 0 and also inixframe to 0 ... That module name appeared in one of the additional error lines and seems to be something that checks whether the Presto Changeo module is up to date.

But, there was no change and the back office still does not load. Perhaps the cache needs removing, but I don't know what I am allowed to delete in this (and in both Modules and under the Themes/Module?)

[CJH]

In reply to the other notes: I've not installed or disabled any new modules for a long time (the site has just run ...). Nothing run as any SQL commander from the BO (I'm not even sure what that is). No change made to the php version by either me or the ISP (it is v5.6 - at present, my payment card module will not run with higher versions of php, but this is unchanged).

[selectshop.at]

as I told disable the module from prestochangeo making problems on table ps_module (sorry was typing error, I corrected afterwards). Set it to inactive (=0)

[CJH]

  On 10/21/2017 at 6:37 PM, selectshop.at said:

as I told disable the module from prestochangeo making problems on table ps_module (sorry was typing error, I corrected afterwards). Set it to inactive (=0)

Expand  

Thanks (I guessed typing error - no problem, I only mentioned in case I was missing something)

Yes, I disabled on the table and set it to inactive. Also others from Prestochangeo that I could find (inixframe seems to check the other module to see if updates are needed, so I also disabled that), but the problem persists. No back office, unless I take out ALL modules (which destroys the website but I can see an empty back office, with uninstalled modules that I guess are being picked up from copies in the theme).

I don't know where to turn next for this.

[selectshop.at]

Did you activated the debug mode ? Any else error displaying ?

[selectshop.at]

Checked for broken indexes on database table as well ? You can use phpMyAdmin for that.

[CJH]

I am getting out of my dedpth more than before - I looked on phpMyAdmin but cannot see where to check for broken indexes, and I don't know about debug mode (I'm very much a novice in this)

Things have changed a little.

I renamed all module folders and therefore a blank back office was accessible, then turned them on one by one. I was left with an operating back office with about five module folders renamed, all linked with Presteo Changeo. Inixframe reconstructed itself and reappeared, though later I replaced the old one (because Presta Apps modules ceased functioning and looking in the .xml, inixframe was used for these).

The website would not correctly load, with error messages relating to missing apps and referring to line entries in override/classes/controller/frontcontroller.php (for duplicateurlredirect) and override/classes/product.php (for categoryquantitydiscount). I commented these out and (because I could now get into the back office) cleared smartycache and the website loaded.

So I now have both back office and website working, though not as before as it lacks several modules that appear to still have some residual affect on the site. One odd thing seems to be that setting 0 instead of 1 in the modules table didn't appear to make any change, and I don't understand that.

At the very least, some of these notes might help someone else, and I must thank you again for your suggestions and help. Where from here, other than building a new site in v1.7 when time allows, I don't know ...

[selectshop.at]

Activate debug mode:

Check and repair broken index/tables on database with phpMyAdmin: http://www.inmotionhosting.com/support/website/databases/check-repair-database

[fercaldas]

Estoy instalando el 1.7.7 desde cero.

Nada de lo que fue puesto aca me resultó... no se xque pusieron solved en el topico.
Yo chequee las tablas, hize el repair y nada

Borre las tablas adentro del DB y ejecute el instalador de nuevo. Me genero 212 tablas, pero no vi cuantas tenia antes para comparar.

Alguien con ese problema en la instalacion del 1.7.7?