Failed update 5.9.3~ynh2 -> 6.0.2~ynh1

[El-Gavy]

Hello,

Describe the bug

Update from 5.9.3~ynh2 to 6.0.2~ynh1 fails: site is up and running but no content can be found in it (every page is missing).

Updated on other WordPress (same version) on the same server without any issue.

Context

• Hardware: VPS bought online
• YunoHost version: 11.0.9.14 (stable)
• I have access to my server: Through SSH | through the webadmin.
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no
• Using, or trying to install package version/branch:
• If upgrading, current package version: 5.9.3~ynh2 -> 6.0.2~ynh1

Steps to reproduce

Just launch the update :)

Expected behavior

WordPress should be running without content loss.

Logs

https://paste.yunohost.org/raw/juyaxofoki

In the warnings of the logs, this seem to be the issue (not sure) : Table 'wordpress.wp_ppress_sessions' doesn't exist

e.g. :

2022-09-23 11:00:09,696: WARNING - WordPress database error Table 'wordpress.wp_ppress_sessions' doesn't exist for query SELECT * FROM wp_ppress_sessions WHERE session_key = '7f39c60659a51629f97343806ae80673' made by include('phar://wp-cli.phar/php/boot-phar.php'), include('phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, ProfilePress\Core\Classes\PPRESS_Session->init, WP_PPress_Session::get_instance, WP_PPress_Session->__construct, WP_PPress_Session->read_data, WP_PPress_Session_Utils::get_session

Thanks in advance for your help!

[tituspijean]

Are you using ProfilePress plugin? If so, disable or remove it, then try upgrading again and reenabling it afterwards.

[El-Gavy]

@tituspijean very sorry, didn’t have time to try, will do next week and i will keep you informed.

[El-Gavy]

I tried to disable ProfilePress plugin then upgrade again : no error message but i still have the issue explained : every page is missing.

Surprisingly, if i can see the content of the articles if i go in the editor, but i can’t preview or access them on the site. Also, menus are ok :

[El-Gavy]

@tituspijean any idea of something I could try to make this update work?

[El-Gavy]

Well I tried to optimize the database, I disabled all plugins and deleted all non-original wordpress database tables : still the same result. I’m thinking of installing a migration plugin, export all data, then import it in a fresh install.