Comment 0 for bug 2017872

Mahara 21.10 and the PHP version is 7.3
MySQL 5.7.36

Operating system: Linux.
Browser: Chrome Version 112.0.5615.121 (x86_64)

To reproduce the issue:
Log in.
Navigate to a collection and try to delete it.
Deletion of the collection occurs but the pages remain.
Select the remaining page(s) and try to delete, the attached error message appears and the page is not deleted.

Error message:

[WAR] 30 (lib/errors.php:853) Failed to get a recordset: mysqli error: [1146: Table 'uhi_mdl.module_submissions' doesn't exist] in EXECUTE("SELECT "id" FROM "module_submissions" WHERE "portfolioelementtype" = 'view' AND "portfolioelementid" = '55831' ")Command was: SELECT "id" FROM "module_submissions" WHERE "portfolioelementtype" = ? AND "portfolioelementid" = ? and values was (0:view,1:55831), referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
Call stack (most recent first):, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
log_message(string(size 372), integer, true, true) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/errors.php:89, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
log_warn(string(size 372)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/errors.php:853, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
SQLException->__construct(string(size 372)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/dml.php:922, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
get_column_sql(string(size 102), array(size 2)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/dml.php:897, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/view.php:1039, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
View->delete() at /u0/webroot/virtual/mahara.uhi.ac.uk/www/view/delete.php:125, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
deleteview_submit(object(Pieform), array(size 2)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/pieforms/pieform.php:572, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
Pieform->__construct(array(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/pieforms/pieform.php:168, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
Pieform::process(array(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/mahara.php:5726, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
pieform(array(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/view/delete.php:107, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
[WAR] 30 (lib/dml.php:922) Failed to get a recordset: mysqli error: [1146: Table 'uhi_mdl.module_submissions' doesn't exist] in EXECUTE("SELECT "id" FROM "module_submissions" WHERE "portfolioelementtype" = 'view' AND "portfolioelementid" = '55831' ")Command was: SELECT "id" FROM "module_submissions" WHERE "portfolioelementtype" = ? AND "portfolioelementid" = ? and values was (0:view,1:55831), referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
Call stack (most recent first):, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
get_column_sql(string(size 102), array(size 2)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/dml.php:897, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/view.php:1039, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
View->delete() at /u0/webroot/virtual/mahara.uhi.ac.uk/www/view/delete.php:125, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
deleteview_submit(object(Pieform), array(size 2)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/pieforms/pieform.php:572, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
Pieform->__construct(array(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/pieforms/pieform.php:168, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
Pieform::process(array(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/mahara.php:5726, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
pieform(array(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/view/delete.php:107, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831