Forums | Mahara Community

Support /
Upgrade from 16.10 to 19.04 issue


26 August 2019, 11:10 PM

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'")  

maha-bug.png

How can I fix this?

Thanks!

27 August 2019, 12:15 AM

Ups the corrects versions:

Upgrade from 18.04 to 19.04 issue

28 August 2019, 1:49 AM

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) frown

 

 

Robert Lyon's profile picture
Posts: 516

29 August 2019, 8:47 AM

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, 7:17 PM

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!

5 results