Sorry, but this is way too technical and I don´t understand what to do.
Is the database corrupt due to the upgrade? Everything was working fine before the upgrade to 12.1

Either use [extension by Piwigo Team] LocalFiles Editor or create the file local/config/config.inc.php manually and in that case make sure you add the php tags as well (LocalFiles editor does that for you), not just the one line, so

<?php
$conf['check_upgrade_feed'] = true;
?>

erAck wrote:

Either use [extension by Piwigo Team] LocalFiles Editor or create the file local/config/config.inc.php manually and in that case make sure you add the php tags as well (LocalFiles editor does that for you), not just the one line, so

Code:

<?php
$conf['check_upgrade_feed'] = true;
?>

Thank you, will give a try to "LocalFiles Editor" once I have managed to upgrade to 12.1.0.
I did a full backup just before the failed upgrade to 12.1.0 and asked my ISP to restore it.
So now I am back at version 11.5.0.
Now my question is : how to make sure the upgrade to 12.1.0 will not fail again ?
For info, I had 3 plugins activated: Embedded Videos. Extended Description and Physical2Virtual.
I also had 5 themes : Sylvia, clear, stripped, Stripped & Columns and dark (the one which was active was 'stripped').
What would you recommend to do ? Deactivate all plugins before retrying upgrade ?
I heard there is a 'manual upgrade' procedure, but not sure where it is. If it requires having ssh access to the server I won't be able to use it, I have only cPanel.

Any advice is welcome !

Here is what was shown during the failed upgrade:

Warning:  [mysql error 2006] MySQL server has gone away

TRUNCATE TABLE piwigo_user_cache_categories; in /home/choeu530/public_html/toutee.com/piwigo/include/dblayer/functions_mysqli.inc.php on line 864



Warning:  [mysql error 2006] MySQL server has gone away

TRUNCATE TABLE piwigo_user_cache; in /home/choeu530/public_html/toutee.com/piwigo/include/dblayer/functions_mysqli.inc.php on line 864


Warning: Cannot modify header information - headers already sent by (output started at /home/choeu530/public_html/toutee.com/piwigo/include/dblayer/functions_mysqli.inc.php:863) in /home/choeu530/public_html/toutee.com/piwigo/include/page_header.php on line 94

Fatal error: Uncaught --> Smarty: property 'literals' does not exist. <-- thrown in /home/choeu530/public_html/toutee.com/piwigo/include/smarty/libs/sysplugins/smarty_internal_extension_handler.php on line 92


Warning:  [mysql error 2006] MySQL server has gone away

REPLACE INTO piwigo_sessions
  (id,data,expiration)
  VALUES('4A38deu3u8fticunc3np2plln7r0k1','pwg_show_metadata|b:1;pwg_device|s:7:\"desktop\";pwg_mobile_theme|b:0;pwg_uid|i:1;',now())
; in /home/choeu530/public_html/toutee.com/piwigo/include/dblayer/functions_mysqli.inc.php on line 864

¸

And then later, when I tried to go admin, the error on the lounge table missing.

Last edited by djom (2021-11-23 01:25:23)

erAck wrote:

> Warning:  [mysql error 2006] MySQL server has gone away

That is a critical error, especially during upgrade, no wonder the upgrade failed. The connection between web server and MySQL server stopped. The cause may be anything from timeouts to insufficient memory. If it persists talk to your hoster.


> Deactivate all plugins before retrying upgrade ?

The upgrade process disables all plugins anyway.

Thank you for the reply. I will see with Hostpapa if I can get temporarily extra memory and CPU units during the upgrade.
Is there any log file which would show when the upgrade failed ?

So.... now it works.

Instead of pointing my browser to     .../upgrade_feed.php, I pointed it to .../upgrade.php
It told me I was still on 11.x and there was an upgrade availabe, so I ran the upgrade and now it works.
Afterwards removed the temporary '$conf['check_upgrade_feed'] = true;'

I should be good to go, thanks!

Pim