Progblems during upgrade the plugin, using wp-cli

Testing to downgrade first in order to upgrade. This is reproduce-able every time I run it.

% wp plugin update real-media-library-lite –version=4.21.16
Installing Real Media Library: Media Library Folder & File Manager (4.21.16)
Downloading installation package from https://downloads.wordpress.org/plugin/real-media-library-lite.4.21.16.zip…
Unpacking the package…
Installing the plugin…
Removing the old version of the plugin…
Plugin updated successfully.
Success: Installed 1 of 1 plugins.
% wp plugin update real-media-library-lite
WordPress database error Cannot load from mysql.proc. The table is probably corrupted for query SHOW FUNCTION STATUS LIKE ‘wp_fn_realmedialibrary_childs’ made by include(‘phar:///usr/bin/wp/php/boot-phar.php’), include(‘phar:///usr/bin/wp/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, MatthiasWeb\RealMediaLibrary\base\Core->updateDbCheck, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->dbDelta, MatthiasWeb\RealMediaLibrary\Activator->supportsChildQuery, MatthiasWeb\RealMediaLibrary\Activator->checkDirtyFunction
WordPress database error Cannot load from mysql.proc. The table is probably corrupted for query DROP FUNCTION IF EXISTS wp_fn_realmedialibrary_childs made by include(‘phar:///usr/bin/wp/php/boot-phar.php’), include(‘phar:///usr/bin/wp/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, MatthiasWeb\RealMediaLibrary\base\Core->updateDbCheck, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->dbDelta, MatthiasWeb\RealMediaLibrary\Activator->supportsChildQuery, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->createChildQueryFunction
Enabling Maintenance mode…
Downloading update from https://downloads.wordpress.org/plugin/real-media-library-lite.4.21.17.zip…
Unpacking the update…
Installing the latest version…
Removing the old version of the plugin…
Plugin updated successfully.
Disabling Maintenance mode…
+————————-+————-+————-+———+
| name | old_version | new_version | status |
+————————-+————-+————-+———+
| real-media-library-lite | 4.21.16 | 4.21.17 | Updated |
+————————-+————-+————-+———+
Success: Updated 1 of 1 plugins.
% wp plugin update real-media-library-lite
WordPress database error Cannot load from mysql.proc. The table is probably corrupted for query SHOW FUNCTION STATUS LIKE ‘wp_fn_realmedialibrary_childs’ made by include(‘phar:///usr/bin/wp/php/boot-phar.php’), include(‘phar:///usr/bin/wp/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, MatthiasWeb\RealMediaLibrary\base\Core->updateDbCheck, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->dbDelta, MatthiasWeb\RealMediaLibrary\Activator->supportsChildQuery, MatthiasWeb\RealMediaLibrary\Activator->checkDirtyFunction
WordPress database error Cannot load from mysql.proc. The table is probably corrupted for query DROP FUNCTION IF EXISTS wp_fn_realmedialibrary_childs made by include(‘phar:///usr/bin/wp/php/boot-phar.php’), include(‘phar:///usr/bin/wp/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, MatthiasWeb\RealMediaLibrary\base\Core->updateDbCheck, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->dbDelta, MatthiasWeb\RealMediaLibrary\Activator->supportsChildQuery, MatthiasWeb\RealMediaLibrary\Activator->install, MatthiasWeb\RealMediaLibrary\Activator->createChildQueryFunction
Success: Plugin already updated.
% wp plugin update real-media-library-lite
Success: Plugin already updated.

It does not warn when you try to upgrade again after this… until the next version comes.

PS: Due to permissions settings we only run updates using another server account (not the web server account) and not via the web interface.

• This reply was modified 1 year, 4 months ago by erikmelkersson.