Forums | Mahara Community
Support
/
Upgrade from 16.10 to 19.04 issue
26 August 2019, 23:10
Hello,
Getting an error Failed to upgrade - trying to upgrade from 16.10 to 19.04 no other information:
[DBG] 3d (lib/dml.php:157) mysqli error: [1305: PROCEDURE bs2_2019.search_elasticsearch_queue_trigger does not exist] in EXECUTE("UPDATE "block_instance" SET configdata = 'a:4:{s:5:\"count\";s:2:\"10\";s:11:\"retractable\";i:0;s:15:\"retractedonload\";i:0;s:11:\"artefactids\";a:1:{i:0;i:35548;}}'WHERE id = '66258'")
How can I fix this?
Thanks!
28 August 2019, 1:49
So,
I solved like this for the trigger:
mysqldump --routines
(to import sql, then I re-imported the bdd)
Now I have this problem:
[DBG] 72 (lib/dml.php:157) mysqli error: [1146: Table 'bs2_test1.artefact_tag' doesn't exist] in EXECUTE("INSERT INTO "tag" (tag,resourcetype,resourceid,ownertype,ownerid,editedby,ctime,mtime)
SELECT xt.tag, 'artefact' AS resourcetype, xt.artefact AS resourceid,
CASE WHEN x.owner IS NOT NULL THEN 'user'
WHEN x.group IS NOT NULL THEN 'group'
ELSE 'institution'
END AS ownertype,
CASE WHEN x.owner IS NOT NULL THEN x.owner
WHEN x.group IS NOT NULL THEN x.group
ELSE x.institution
END AS ownerid,
NULL AS editedby, x.ctime AS ctime, x.mtime AS mtime
FROM "artefact_tag" xt
JOIN "artefact" x ON x.id = xt.artefact")Command was: INSERT INTO "tag" (tag,resourcetype,resourceid,ownertype,ownerid,editedby,ctime,mtime)
SELECT xt.tag, 'artefact' AS resourcetype, xt.artefact AS resourceid,
CASE WHEN x.owner IS NOT NULL THEN 'user'
WHEN x.group IS NOT NULL THEN 'group'
ELSE 'institution'
END AS ownertype,
CASE WHEN x.owner IS NOT NULL THEN x.owner
WHEN x.group IS NOT NULL THEN x.group
ELSE x.institution
END AS ownerid,
NULL AS editedby, x.ctime AS ctime, x.mtime AS mtime
FROM "artefact_tag" xt
JOIN "artefact" x ON x.id = xt.artefact
[WAR] 72 (lib/errors.php:858) Could not execute command: INSERT INTO "tag" (tag,resourcetype,resourceid,ownertype,ownerid,editedby,ctime,mtime)
SELECT xt.tag, 'artefact' AS resourcetype, xt.artefact AS resourceid,
CASE WHEN x.owner IS NOT NULL THEN 'user'
WHEN x.group IS NOT NULL THEN 'group'
ELSE 'institution'
END AS ownertype,
CASE WHEN x.owner IS NOT NULL THEN x.owner
WHEN x.group IS NOT NULL THEN x.group
ELSE x.institution
END AS ownerid,
NULL AS editedby, x.ctime AS ctime, x.mtime AS mtime
FROM "artefact_tag" xt
JOIN "artefact" x ON x.id = xt.artefact
Perhaps the problem comes from the MySQL version (5.5) 
29 August 2019, 8:47
Hi,
That error sounds like the an upgrade attempt has already moved information from the 'artefact_tag' table to the 'tag' table. Can you check your database to see if you have a 'tag' table that is populated with data? And no artefact_tag, view_tag, collection_tag tables?
If that is the case you can comment out the block of code in the htdocs/lib/db/upgrade.php file that begins with
if ($oldversion < 2018061801) {
Cheers
Robert
29 August 2019, 19:17
Hi Robert,
Thank you for answer. I solved the problem by going directly to the link:
http://mywebsite.com/admin/upgrade.php?rerun=1&urlsecret=mysupercode
I don't know why in "console mode" (with php 7.1) Mahara could not migrate.
Thanks again!