• install_from_xmldb_file(string(size 62)) at /var/www/html/mahara/htdocs/lib/upgrade.php:412
• upgrade_plugin(object(stdClass)) at /var/www/html/mahara/htdocs/lib/db/upgrade.php:4073
• xmldb_core_upgrade(string(size 10)) at /var/www/html/mahara/htdocs/lib/upgrade.php:342
• upgrade_core(object(stdClass)) at /var/www/html/mahara/htdocs/admin/upgrade.json.php:87

The error logs weren't working either, so I've had to add some code in just to get them to log, and this is what it#s saying:

Filling in level-1 child artefact paths
Filling in level-2 child artefact paths
Filling in level-3 child artefact paths
Filling in level-4 child artefact paths
Done filling in child artefact paths
Create 'objectionable' table.
Table objectionable exists. Create skipped
Migrating objectionable records to new format
Drop constraint on 'view_access'
Update 'view_access' accesstype
Add 'artefact_access' table.
Table artefact_access exists. Create skipped
Add module related tables
Table module_installed exists. Create skipped
Table module_cron exists. Create skipped
Table module_config exists. Create skipped
Table module_event_subscription exists. Create skipped
Fix up auth_clean_expired_password_requests cron
Add 'feedbacknotify' option to 'group' table
Delete leftover data which are not associated to any institution
Delete leftover custom layouts / usr registration
Check blocktype 'text' is installed
Allow anonymous pages
Add 'allowarchives' column to the 'group' table
Add 'submittedstatus' column to 'view' table
Need to update the submitted status for any existing views that are submitted
Add 'submittedstatus' column to 'collection' table
Need to update the submitted status for any existing collections that are submitted
Adding the export queue / submission tables
Table export_queue exists. Create skipped
Table export_queue_items exists. Create skipped
Table export_archive exists. Create skipped
Table archived_submissions exists. Create skipped
Add the socialprofile artefacttype
12/12
Clean up elasticsearch fields for the old messaging fields
Delete unused, but still installed artefact types
Install the social profile blocktype so users can see their migrated data
Install 'multirecipientnotification' plugin
Make sure default notifications are not set to 'none'
Place skin fonts in their correct directories
Unlock root user grouphomepage template in case it is locked
Add cacheversion and assign random string
Add in 'shortcut' category to 'blocktype_category'
Fix up group homepages so that no duplicate 'groupview' blocks are present
Remove layout preview thumbs directory
Add a 'sortorder' column to 'blocktype_installed_category'
Need to update any dashboard pages to not have skins
Remove bbcode formatting from existing wall posts
preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
Update search config settings
Update block categories for plugins
Updating TinyMCE emoticon locations in mahara database
Updating 'block_instance' data for TinyMCE
4/4
Force install of annotation and webservices plugins
mysqli error: [1050: Table 'artefact_annotation_deletedby' already exists] in EXECUTE("CREATE TABLE artefact_annotation_deletedby (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(50) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)ENGINE=innodb")
Command was: CREATE TABLE artefact_annotation_deletedby (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(50) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)ENGINE=innodb
Could not execute command: CREATE TABLE artefact_annotation_deletedby (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(50) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)ENGINE=innodb
mysqli error: [1050: Table 'artefact_annotation' already exists] in EXECUTE("CREATE TABLE artefact_annotation (
annotation BIGINT(10) NOT NULL,
artefact BIGINT(10) DEFAULT NULL,
view BIGINT(10) DEFAULT NULL,
CONSTRAINT PRIMARY KEY (annotation),
CONSTRAINT arteanno_ann_fk FOREIGN KEY (annotation) REFERENCES artefact (id),
CONSTRAINT arteanno_art_fk FOREIGN KEY (artefact) REFERENCES artefact (id),
CONSTRAINT arteanno_vie_fk FOREIGN KEY (view) REFERENCES view (id)
)ENGINE=innodb")
Command was: CREATE TABLE artefact_annotation (
annotation BIGINT(10) NOT NULL,
artefact BIGINT(10) DEFAULT NULL,
view BIGINT(10) DEFAULT NULL,
CONSTRAINT PRIMARY KEY (annotation),
CONSTRAINT arteanno_ann_fk FOREIGN KEY (annotation) REFERENCES artefact (id),
CONSTRAINT arteanno_art_fk FOREIGN KEY (artefact) REFERENCES artefact (id),
CONSTRAINT arteanno_vie_fk FOREIGN KEY (view) REFERENCES view (id)
)ENGINE=innodb
Could not execute command: CREATE TABLE artefact_annotation (
annotation BIGINT(10) NOT NULL,
artefact BIGINT(10) DEFAULT NULL,
view BIGINT(10) DEFAULT NULL,
CONSTRAINT PRIMARY KEY (annotation),
CONSTRAINT arteanno_ann_fk FOREIGN KEY (annotation) REFERENCES artefact (id),
CONSTRAINT arteanno_art_fk FOREIGN KEY (artefact) REFERENCES artefact (id),
CONSTRAINT arteanno_vie_fk FOREIGN KEY (view) REFERENCES view (id)
)ENGINE=innodb
mysqli error: [1050: Table 'artefact_annotation_feedback' already exists] in EXECUTE("CREATE TABLE artefact_annotation_feedback (
artefact BIGINT(10) NOT NULL,
onannotation BIGINT(10) NOT NULL,
private TINYINT(1) unsigned NOT NULL DEFAULT 0,
deletedby VARCHAR(50) DEFAULT NULL,
requestpublic VARCHAR(50) DEFAULT NULL,
lastcontentupdate DATETIME DEFAULT NULL,
CONSTRAINT PRIMARY KEY (artefact),
CONSTRAINT arteannofeed_art_fk FOREIGN KEY (artefact) REFERENCES artefact (id),
CONSTRAINT arteannofeed_ona_fk FOREIGN KEY (onannotation) REFERENCES artefact (id),
CONSTRAINT arteannofeed_del_fk FOREIGN KEY (deletedby) REFERENCES artefact_annotation_deletedby (name),
CONSTRAINT arteannofeed_req_fk FOREIGN KEY (requestpublic) REFERENCES artefact_annotation_deletedby (name)
)ENGINE=innodb")
Command was: CREATE TABLE artefact_annotation_feedback (
artefact BIGINT(10) NOT NULL,
onannotation BIGINT(10) NOT NULL,
private TINYINT(1) unsigned NOT NULL DEFAULT 0,
deletedby VARCHAR(50) DEFAULT NULL,
requestpublic VARCHAR(50) DEFAULT NULL,
lastcontentupdate DATETIME DEFAULT NULL,
CONSTRAINT PRIMARY KEY (artefact),
CONSTRAINT arteannofeed_art_fk FOREIGN KEY (artefact) REFERENCES artefact (id),
CONSTRAINT arteannofeed_ona_fk FOREIGN KEY (onannotation) REFERENCES artefact (id),
CONSTRAINT arteannofeed_del_fk FOREIGN KEY (deletedby) REFERENCES artefact_annotation_deletedby (name),
CONSTRAINT arteannofeed_req_fk FOREIGN KEY (requestpublic) REFERENCES artefact_annotation_deletedby (name)
)ENGINE=innodb
Could not execute command: CREATE TABLE artefact_annotation_feedback (
artefact BIGINT(10) NOT NULL,
onannotation BIGINT(10) NOT NULL,
private TINYINT(1) unsigned NOT NULL DEFAULT 0,
deletedby VARCHAR(50) DEFAULT NULL,
requestpublic VARCHAR(50) DEFAULT NULL,
lastcontentupdate DATETIME DEFAULT NULL,
CONSTRAINT PRIMARY KEY (artefact),
CONSTRAINT arteannofeed_art_fk FOREIGN KEY (artefact) REFERENCES artefact (id),
CONSTRAINT arteannofeed_ona_fk FOREIGN KEY (onannotation) REFERENCES artefact (id),
CONSTRAINT arteannofeed_del_fk FOREIGN KEY (deletedby) REFERENCES artefact_annotation_deletedby (name),
CONSTRAINT arteannofeed_req_fk FOREIGN KEY (requestpublic) REFERENCES artefact_annotation_deletedby (name)
)ENGINE=innodb
Array to string conversion
Array
Failed to install (check logs for xmldb errors)

Does anyone know what I need to do to fix this?

Do I need to upgrade to a lower version first, and then upgrade to the latest one?

Thanks

• get_recordset_sql(string(size 108), array(size 3)) at /var/www/html/mahara/htdocs/lib/dml.php:825
• get_field_sql(string(size 108), array(size 3)) at /var/www/html/mahara/htdocs/lib/dml.php:813
• get_field(string(size 22), string(size 2), string(size 6), string(size 3), string(size 12), string(size 8), string(size 10), string(size 3)) at/var/www/html/mahara/htdocs/lib/embeddedimage.php:87
• EmbeddedImage::prepare_embedded_images(string(size 1654), string(size 8), string(size 3), null, string(size 1)) at/var/www/html/mahara/htdocs/artefact/blog/db/upgrade.php:75
• xmldb_artefact_blog_upgrade(string(size 10)) at /var/www/html/mahara/htdocs/lib/upgrade.php:418
• upgrade_plugin(object(stdClass)) at /var/www/html/mahara/htdocs/admin/upgrade.json.php:87

Looking at the code, it looks like in the blog upgrade, it's calling this method:

EmbeddedImage::prepare_embedded_images

Which in turn is calling this:

$imgispublic = get_field('artefact_file_embedded', 'id', 'fileid', $imgid, 'resourcetype', $resourcetype, 'resourceid', $resourceid);

But because it is running the artefact.blog upgrade before the artefect.file upgrade, that artefact_file_embedded table hasn't been created yet, so it fails.

For now I will just have to try and create that table beforehand and see if that works, but it looks like that's a error in the upgrade script?