My upgrade script for 19.10 fails with the following message(s):
root@server:/var/www/mahara/htdocs/admin# sudo -u www-data php cli/upgrade.php -f
[INF] 96 (admin/cli/upgrade.php:70) Upgrading Mahara
[INF] 96 (lib/mahara.php:240) artefact.file wird aktualisiert
[DBG] 96 (artefact/file/db/upgrade.php:514) Update m4a, m4b, m4p and m4r file types to be audio/mp4 mimetype
[DBG] 96 (lib/dml.php:180) mysqli error: [1305: PROCEDURE u57370db5nd.search_elasticsearch_queue_artefact_trigger does not exist] in EXECUTE("UPDATE "artefact"
[DBG] 96 (lib/dml.php:180) SET artefacttype = 'audio'
[DBG] 96 (lib/dml.php:180) WHERE id IN (SELECT artefact FROM "artefact_file_files"
[DBG] 96 (lib/dml.php:180) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[DBG] 96 (lib/dml.php:180) ")Command was: UPDATE "artefact"
[DBG] 96 (lib/dml.php:180) SET artefacttype = 'audio'
[DBG] 96 (lib/dml.php:180) WHERE id IN (SELECT artefact FROM "artefact_file_files"
[DBG] 96 (lib/dml.php:180) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[DBG] 96 (lib/dml.php:180)
[WAR] 96 (lib/errors.php:859) Could not execute command: UPDATE "artefact"
[WAR] 96 (lib/errors.php:859) SET artefacttype = 'audio'
[WAR] 96 (lib/errors.php:859) WHERE id IN (SELECT artefact FROM "artefact_file_files"
[WAR] 96 (lib/errors.php:859) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[WAR] 96 (lib/errors.php:859)
Call stack (most recent first):
* log_message(string(size 261), integer, true, true) at /var/www/mahara-19.10.0/htdocs/lib/errors.php:95
* log_warn(string(size 261)) at /var/www/mahara-19.10.0/htdocs/lib/errors.php:859
* SQLException->__construct(string(size 261)) at /var/www/mahara-19.10.0/htdocs/lib/dml.php:181
* execute_sql(string(size 234)) at /var/www/mahara-19.10.0/htdocs/artefact/file/db/upgrade.php:516
* xmldb_artefact_file_upgrade(string(size 10)) at /var/www/mahara-19.10.0/htdocs/lib/upgrade.php:453
* upgrade_plugin(object(stdClass)) at /var/www/mahara-19.10.0/htdocs/lib/mahara.php:274
* upgrade_mahara(array(size 1)) at /var/www/mahara-19.10.0/htdocs/admin/cli/upgrade.php:74
[WAR] 96 (lib/dml.php:181) Could not execute command: UPDATE "artefact"
[WAR] 96 (lib/dml.php:181) SET artefacttype = 'audio'
[WAR] 96 (lib/dml.php:181) WHERE id IN (SELECT artefact FROM "artefact_file_files"
[WAR] 96 (lib/dml.php:181) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[WAR] 96 (lib/dml.php:181)
Call stack (most recent first):
* execute_sql(string(size 234)) at /var/www/mahara-19.10.0/htdocs/artefact/file/db/upgrade.php:516
* xmldb_artefact_file_upgrade(string(size 10)) at /var/www/mahara-19.10.0/htdocs/lib/upgrade.php:453
* upgrade_plugin(object(stdClass)) at /var/www/mahara-19.10.0/htdocs/lib/mahara.php:274
* upgrade_mahara(array(size 1)) at /var/www/mahara-19.10.0/htdocs/admin/cli/upgrade.php:74
A nonrecoverable error occurred. This probably means you have encountered a bug in the systemroot@server:/var/www/mahara/htdoc
I am using
PHP 7.3.11-1+ubuntu16.04.1
Mysql 10.1.41-MariaDB-1
Ubuntu 16.04.6 LTS (GNU/Linux 4.4.0-159-generic x86_64)
My upgrade script for 19.10 fails with the following message(s):
root@server: /var/www/ mahara/ htdocs/ admin# sudo -u www-data php cli/upgrade.php -f cli/upgrade. php:70) Upgrading Mahara php:240) artefact.file wird aktualisiert file/db/ upgrade. php:514) Update m4a, m4b, m4p and m4r file types to be audio/mp4 mimetype search_ elasticsearch_ queue_artefact_ trigger does not exist] in EXECUTE("UPDATE "artefact" file_files" file_files" php:859) Could not execute command: UPDATE "artefact" php:859) SET artefacttype = 'audio' php:859) WHERE id IN (SELECT artefact FROM "artefact_ file_files" php:859) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r')); php:859) string( size 261), integer, true, true) at /var/www/ mahara- 19.10.0/ htdocs/ lib/errors. php:95 string( size 261)) at /var/www/ mahara- 19.10.0/ htdocs/ lib/errors. php:859 >__construct( string( size 261)) at /var/www/ mahara- 19.10.0/ htdocs/ lib/dml. php:181 sql(string( size 234)) at /var/www/ mahara- 19.10.0/ htdocs/ artefact/ file/db/ upgrade. php:516 file_upgrade( string( size 10)) at /var/www/ mahara- 19.10.0/ htdocs/ lib/upgrade. php:453 plugin( object( stdClass) ) at /var/www/ mahara- 19.10.0/ htdocs/ lib/mahara. php:274 mahara( array(size 1)) at /var/www/ mahara- 19.10.0/ htdocs/ admin/cli/ upgrade. php:74
[INF] 96 (admin/
[INF] 96 (lib/mahara.
[DBG] 96 (artefact/
[DBG] 96 (lib/dml.php:180) mysqli error: [1305: PROCEDURE u57370db5nd.
[DBG] 96 (lib/dml.php:180) SET artefacttype = 'audio'
[DBG] 96 (lib/dml.php:180) WHERE id IN (SELECT artefact FROM "artefact_
[DBG] 96 (lib/dml.php:180) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[DBG] 96 (lib/dml.php:180) ")Command was: UPDATE "artefact"
[DBG] 96 (lib/dml.php:180) SET artefacttype = 'audio'
[DBG] 96 (lib/dml.php:180) WHERE id IN (SELECT artefact FROM "artefact_
[DBG] 96 (lib/dml.php:180) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[DBG] 96 (lib/dml.php:180)
[WAR] 96 (lib/errors.
[WAR] 96 (lib/errors.
[WAR] 96 (lib/errors.
[WAR] 96 (lib/errors.
[WAR] 96 (lib/errors.
Call stack (most recent first):
* log_message(
* log_warn(
* SQLException-
* execute_
* xmldb_artefact_
* upgrade_
* upgrade_
[WAR] 96 (lib/dml.php:181) Could not execute command: UPDATE "artefact" file_files" sql(string( size 234)) at /var/www/ mahara- 19.10.0/ htdocs/ artefact/ file/db/ upgrade. php:516 file_upgrade( string( size 10)) at /var/www/ mahara- 19.10.0/ htdocs/ lib/upgrade. php:453 plugin( object( stdClass) ) at /var/www/ mahara- 19.10.0/ htdocs/ lib/mahara. php:274 mahara( array(size 1)) at /var/www/ mahara- 19.10.0/ htdocs/ admin/cli/ upgrade. php:74
[WAR] 96 (lib/dml.php:181) SET artefacttype = 'audio'
[WAR] 96 (lib/dml.php:181) WHERE id IN (SELECT artefact FROM "artefact_
[WAR] 96 (lib/dml.php:181) WHERE oldextension IN ('m4a', 'm4b', 'm4p', 'm4r'));
[WAR] 96 (lib/dml.php:181)
Call stack (most recent first):
* execute_
* xmldb_artefact_
* upgrade_
* upgrade_
A nonrecoverable error occurred. This probably means you have encountered a bug in the systemroot@ server: /var/www/ mahara/ htdoc
I am using 1+ubuntu16. 04.1
PHP 7.3.11-
Mysql 10.1.41-MariaDB-1
Ubuntu 16.04.6 LTS (GNU/Linux 4.4.0-159-generic x86_64)