Update of wordpress failed via yuno interface (Unable to upgrade wordpress__5)

Support
1

hi

Unable to upgrade wordpress__5
any idea what is wrong ?

2017-12-22 03:04:02,725 INFO moulinette.actionsmap process - processing action [573.36]: yunohost.app.upgrade
2017-12-22 03:04:02,759 INFO yunohost.app app_upgrade - [573.36] Upgrading apps wordpress__5
2017-12-22 03:04:02,765 INFO yunohost.app _fetch_app_from_git - [573.36] Downloading…
2017-12-22 03:04:03,601 INFO yunohost.app _extract_app_from_file - [573.36] Extracting…
2017-12-22 03:04:03,608 INFO yunohost.app _extract_app_from_file - [573.36] Done
2017-12-22 03:04:03,609 INFO yunohost.app _check_manifest_requirements - [573.36] Checking required packages…
2017-12-22 03:04:03,862 INFO yunohost.hook hook_exec - [573.36] Executing script ‘/var/cache/yunohost/from_file/wordpress_ynh-5afdbcb8c291777df60bc18256dd8a09221f415f/scripts/upgrade’…
2017-12-22 03:04:03,883 INFO yunohost.hook - [573.36] + source _common.sh
2017-12-22 03:04:03,886 INFO yunohost.hook - [573.36] + source /usr/share/yunohost/helpers
2017-12-22 03:04:03,886 INFO yunohost.hook - [573.36] +++ run-parts --list /usr/share/yunohost/helpers.d
2017-12-22 03:04:03,890 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,892 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/backend ‘]’
2017-12-22 03:04:03,892 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/backend
2017-12-22 03:04:03,893 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,894 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/filesystem ‘]’
2017-12-22 03:04:03,894 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/filesystem
2017-12-22 03:04:03,895 INFO yunohost.hook - [573.36] +++ CAN_BIND=1
2017-12-22 03:04:03,896 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,897 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/ip ‘]’
2017-12-22 03:04:03,897 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/ip
2017-12-22 03:04:03,898 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,898 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/mysql ‘]’
2017-12-22 03:04:03,898 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/mysql
2017-12-22 03:04:03,899 INFO yunohost.hook - [573.36] +++ MYSQL_ROOT_PWD_FILE=/etc/yunohost/mysql
2017-12-22 03:04:03,899 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,899 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/network ‘]’
2017-12-22 03:04:03,900 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/network
2017-12-22 03:04:03,900 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,900 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/package ‘]’
2017-12-22 03:04:03,900 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/package
2017-12-22 03:04:03,901 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,901 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/print ‘]’
2017-12-22 03:04:03,902 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/print
2017-12-22 03:04:03,902 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,902 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/setting ‘]’
2017-12-22 03:04:03,903 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/setting
2017-12-22 03:04:03,903 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,903 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/string ‘]’
2017-12-22 03:04:03,903 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/string
2017-12-22 03:04:03,904 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,904 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/system ‘]’
2017-12-22 03:04:03,905 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/system
2017-12-22 03:04:03,906 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,906 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/user ‘]’
2017-12-22 03:04:03,906 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/user
2017-12-22 03:04:03,906 INFO yunohost.hook - [573.36] ++ for helper in ‘$(run-parts --list /usr/share/yunohost/helpers.d 2>/dev/null)’
2017-12-22 03:04:03,909 INFO yunohost.hook - [573.36] ++ ‘[’ -r /usr/share/yunohost/helpers.d/utils ‘]’
2017-12-22 03:04:03,909 INFO yunohost.hook - [573.36] ++ . /usr/share/yunohost/helpers.d/utils
2017-12-22 03:04:03,909 INFO yunohost.hook - [573.36] + app=wordpress__5
2017-12-22 03:04:03,910 INFO yunohost.hook - [573.36] ++ ynh_app_setting_get wordpress__5 domain
2017-12-22 03:04:03,910 INFO yunohost.hook - [573.36] ++ sudo yunohost app setting wordpress__5 domain --output-as plain --quiet
2017-12-22 03:04:04,666 INFO yunohost.hook - [573.36] + domain=www.psytranceworld.org
2017-12-22 03:04:04,667 INFO yunohost.hook - [573.36] ++ ynh_app_setting_get wordpress__5 path
2017-12-22 03:04:04,667 INFO yunohost.hook - [573.36] ++ sudo yunohost app setting wordpress__5 path --output-as plain --quiet
2017-12-22 03:04:05,417 INFO yunohost.hook - [573.36] + path_url=/
2017-12-22 03:04:05,418 INFO yunohost.hook - [573.36] ++ ynh_app_setting_get wordpress__5 admin
2017-12-22 03:04:05,419 INFO yunohost.hook - [573.36] ++ sudo yunohost app setting wordpress__5 admin --output-as plain --quiet
2017-12-22 03:04:06,146 INFO yunohost.hook - [573.36] + admin_wordpress=cosmic
2017-12-22 03:04:06,147 INFO yunohost.hook - [573.36] ++ ynh_app_setting_get wordpress__5 language
2017-12-22 03:04:06,147 INFO yunohost.hook - [573.36] ++ sudo yunohost app setting wordpress__5 language --output-as plain --quiet
2017-12-22 03:04:06,855 INFO yunohost.hook - [573.36] + language=en_US
2017-12-22 03:04:06,856 INFO yunohost.hook - [573.36] ++ ynh_app_setting_get wordpress__5 is_public
2017-12-22 03:04:06,856 INFO yunohost.hook - [573.36] ++ sudo yunohost app setting wordpress__5 is_public --output-as plain --quiet
2017-12-22 03:04:07,565 INFO yunohost.hook - [573.36] + is_public=1
2017-12-22 03:04:07,565 INFO yunohost.hook - [573.36] ++ ynh_app_setting_get wordpress__5 multisite
2017-12-22 03:04:07,566 INFO yunohost.hook - [573.36] ++ sudo yunohost app setting wordpress__5 multisite --output-as plain --quiet
2017-12-22 03:04:08,334 INFO yunohost.hook - [573.36] + multisite=0
2017-12-22 03:04:08,335 INFO yunohost.hook - [573.36] ++ ynh_app_setting_get wordpress__5 final_path
2017-12-22 03:04:08,335 INFO yunohost.hook - [573.36] ++ sudo yunohost app setting wordpress__5 final_path --output-as plain --quiet
2017-12-22 03:04:09,126 INFO yunohost.hook - [573.36] + final_path=/var/www/wordpress__5
2017-12-22 03:04:09,127 INFO yunohost.hook - [573.36] ++ ynh_app_setting_get wordpress__5 db_name
2017-12-22 03:04:09,127 INFO yunohost.hook - [573.36] ++ sudo yunohost app setting wordpress__5 db_name --output-as plain --quiet
2017-12-22 03:04:09,899 INFO yunohost.hook - [573.36] + db_name=wordpress__5
2017-12-22 03:04:09,900 INFO yunohost.hook - [573.36] + ‘[’ -z cosmic ‘]’
2017-12-22 03:04:09,900 INFO yunohost.hook - [573.36] + ‘[’ -z /var/www/wordpress__5 ‘]’
2017-12-22 03:04:09,900 INFO yunohost.hook - [573.36] + ‘[’ -z en_US ‘]’
2017-12-22 03:04:09,900 INFO yunohost.hook - [573.36] + ‘[’ 1 = Yes ‘]’
2017-12-22 03:04:09,901 INFO yunohost.hook - [573.36] + ‘[’ 1 = No ‘]’
2017-12-22 03:04:09,901 INFO yunohost.hook - [573.36] + ‘[’ 0 = Yes ‘]’
2017-12-22 03:04:09,902 INFO yunohost.hook - [573.36] + ‘[’ 0 = No ‘]’
2017-12-22 03:04:09,902 INFO yunohost.hook - [573.36] + ‘[’ -z wordpress__5 ‘]’
2017-12-22 03:04:09,902 INFO yunohost.hook - [573.36] + grep ‘add_filter.*auto_update’ /var/www/wordpress__5/wp-config.php
2017-12-22 03:04:09,904 INFO yunohost.hook - [573.36] + ynh_backup_before_upgrade
2017-12-22 03:04:09,905 INFO yunohost.hook - [573.36] + ‘[’ ‘!’ -e /etc/yunohost/apps/wordpress__5/scripts/backup ‘]’
2017-12-22 03:04:09,905 INFO yunohost.hook - [573.36] + backup_number=1
2017-12-22 03:04:09,905 INFO yunohost.hook - [573.36] + old_backup_number=2
2017-12-22 03:04:09,905 INFO yunohost.hook - [573.36] + app_bck=wordpress–5
2017-12-22 03:04:09,906 INFO yunohost.hook - [573.36] + grep -q wordpress–5-pre-upgrade1
2017-12-22 03:04:09,908 INFO yunohost.hook - [573.36] + sudo yunohost backup list
2017-12-22 03:04:10,677 INFO yunohost.hook - [573.36] + sudo yunohost backup create --ignore-system --apps wordpress__5 --name wordpress–5-pre-upgrade1
2017-12-22 03:04:14,458 WARNING yunohost.hook - [573.36] mysqldump: Couldn’t execute ‘show create table wp_wfNet404s’: Table ‘wordpress__5.wp_wfNet404s’ doesn’t exist in engine (1932)
2017-12-22 03:04:14,463 WARNING yunohost.hook - [573.36] !!
2017-12-22 03:04:14,463 WARNING yunohost.hook - [573.36] wordpress__5’s script has encountered an error. Its execution was cancelled.
2017-12-22 03:04:14,463 WARNING yunohost.hook - [573.36] !!
2017-12-22 03:04:14,464 WARNING yunohost.hook - [573.36]
2017-12-22 03:04:14,474 WARNING yunohost.hook - [573.36] Unable to back up the app ‘wordpress__5’
2017-12-22 03:04:14,475 WARNING yunohost.hook - [573.36] There is nothing to save
2017-12-22 03:04:14,532 INFO yunohost.hook - [573.36] + ‘[’ 22 -eq 0 ‘]’
2017-12-22 03:04:14,532 INFO yunohost.hook - [573.36] + ynh_die ‘Backup failed, the upgrade process was aborted.’
2017-12-22 03:04:14,532 INFO yunohost.hook - [573.36] + echo ‘Backup failed, the upgrade process was aborted.’
2017-12-22 03:04:14,533 INFO yunohost.hook - [573.36] + exit 1
2017-12-22 03:04:14,533 WARNING yunohost.hook - [573.36] Backup failed, the upgrade process was aborted.
2017-12-22 03:04:14,594 ERROR yunohost.app app_upgrade - [573.36] Unable to upgrade wordpress__5
2017-12-22 03:04:14,596 INFO geventwebsocket.handler log_request - 127.0.0.1 - - [2017-12-22 03:04:14] “PUT /upgrade/apps?app=wordpress__5 HTTP/1.1” 500 152 11.889935

2

The error is here.
Did you retry the upgrade ?

It can be a temporary error.

3

i just tried and same error

i also tried with another WP install i had and managed to make it work without any problem…

the install that is not updating is a “default” install ( i didn’t do any hacks / customs or anything like that )

4

Are you sure there’s nothing like a plugin Wordfence ? This table seems to be referred to this plugin.
I’m sure that there’s no table named wp_wfNet404s in a default installation.

5

well there are several plugin install including Wordfence.
but i suppose the update can work with any plugin installed ?

p.s. when i said nothing custom, i mean that my WP was installed via yunohost standard interface

6

Any plugins which don’t break the database exports.
Any research I try on this table give me errors with exports.
You can have a look here maybe, Error: Tables 'wp_wfNet404s' and 'wp_wfVulnScanners' "doesn't exist in | WordPress.org

7

so what exactly this update does ?

is the final results is same as going to admin interface and “update” wordpress ?

8

The upgrade of the package, for wordpress, doesn’t upgrade wordpress itself but only the scripts around.
Mainly for this upgrade some fixes for ldap and http_auth plugins.

But, in your case, it’s not the upgrade script which doesn’t work but the backup script. So that means, you can’t backup your wordpress unless you fix this error with your database.
And the upgrade script try to backup your wordpress before changing anything.