mahara-contributors team mailing list archive
-
mahara-contributors team
-
Mailing list archive
-
Message #68760
[Bug 2017872] [NEW] Error message when trying to delete collection /or pages
Public bug reported:
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)
Call stack (most recent first):,
log_message(string(size 372), integer, true, true) at www/lib/errors.php:89,
log_warn(string(size 372)) at /www/lib/errors.php:853,
SQLException->__construct(string(size 372)) at www/lib/dml.php:922,
get_column_sql(string(size 102), array(size 2)) at www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039,
View->delete() at www/view/delete.php:125,
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
[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),
Call stack (most recent first):,
get_column_sql(string(size 102), array(size 2)) at /www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039
View->delete() at www/view/delete.php:125
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at /www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
** Affects: mahara
Importance: Undecided
Status: New
** Description changed:
Mahara 21.10 and the PHP version is 7.3
MySQL 5.7.36
- Operating system: Linux.
+ 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
+ log_message(string(size 372), integer, true, true) at www/lib/errors.php:89, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ log_warn(string(size 372)) at/www/lib/errors.php:853, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ SQLException->__construct(string(size 372)) at 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 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 www/lib/view.php:1039, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ View->delete() at www/view/delete.php:125, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ Pieform::process(array(size 5)) at www/lib/mahara.php:5726, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ pieform(array(size 5)) at /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
+ get_column_sql(string(size 102), array(size 2)) at /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 www/lib/view.php:1039, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ View->delete() at www/view/delete.php:125, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ deleteview_submit(object(Pieform), array(size 2)) at /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
+ Pieform::process(array(size 5)) at /www/lib/mahara.php:5726, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ pieform(array(size 5)) at /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
** Description changed:
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
+ [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)
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 www/lib/errors.php:89, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
- log_warn(string(size 372)) at/www/lib/errors.php:853, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ log_warn(string(size 372)) at/www/lib/errors.php:853,
SQLException->__construct(string(size 372)) at 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 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 www/lib/view.php:1039, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
- View->delete() at www/view/delete.php:125, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
- deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
- Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
- Pieform::process(array(size 5)) at www/lib/mahara.php:5726, 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 www/lib/view.php:1039,
+ View->delete() at www/view/delete.php:125,
+ deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
+ Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
+ Pieform::process(array(size 5)) at www/lib/mahara.php:5726,
pieform(array(size 5)) at /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 /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 www/lib/view.php:1039, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
View->delete() at www/view/delete.php:125, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
deleteview_submit(object(Pieform), array(size 2)) at /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 /www/lib/mahara.php:5726, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
pieform(array(size 5)) at /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
** Description changed:
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)
- 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 www/lib/errors.php:89, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ Call stack (most recent first):,
+ log_message(string(size 372), integer, true, true) at www/lib/errors.php:89,
log_warn(string(size 372)) at/www/lib/errors.php:853,
- SQLException->__construct(string(size 372)) at 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 www/lib/dml.php:897, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ SQLException->__construct(string(size 372)) at www/lib/dml.php:922,
+ get_column_sql(string(size 102), array(size 2)) at www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039,
View->delete() at www/view/delete.php:125,
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
- Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
+ Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at www/lib/mahara.php:5726,
- pieform(array(size 5)) at /www/view/delete.php:107, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ pieform(array(size 5)) at /www/view/delete.php:107,
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 /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 www/lib/view.php:1039, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
View->delete() at www/view/delete.php:125, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
deleteview_submit(object(Pieform), array(size 2)) at /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 /www/lib/mahara.php:5726, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
pieform(array(size 5)) at /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
** Description changed:
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)
- Call stack (most recent first):,
+ Call stack (most recent first):,
log_message(string(size 372), integer, true, true) at www/lib/errors.php:89,
log_warn(string(size 372)) at/www/lib/errors.php:853,
- SQLException->__construct(string(size 372)) at www/lib/dml.php:922,
- get_column_sql(string(size 102), array(size 2)) at www/lib/dml.php:897,
+ SQLException->__construct(string(size 372)) at www/lib/dml.php:922,
+ get_column_sql(string(size 102), array(size 2)) at www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039,
View->delete() at www/view/delete.php:125,
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
- 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
+
+ [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),
+ Call stack (most recent first):,
get_column_sql(string(size 102), array(size 2)) at /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 www/lib/view.php:1039, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
- View->delete() at www/view/delete.php:125, 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 www/lib/view.php:1039
+ View->delete() at www/view/delete.php:125
deleteview_submit(object(Pieform), array(size 2)) at /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 /www/lib/mahara.php:5726, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
- pieform(array(size 5)) at /www/view/delete.php:107, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ Pieform::process(array(size 5)) at /www/lib/mahara.php:5726,
+ pieform(array(size 5)) at /www/view/delete.php:107,
referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
** Description changed:
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)
Call stack (most recent first):,
log_message(string(size 372), integer, true, true) at www/lib/errors.php:89,
log_warn(string(size 372)) at/www/lib/errors.php:853,
SQLException->__construct(string(size 372)) at www/lib/dml.php:922,
get_column_sql(string(size 102), array(size 2)) at www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039,
View->delete() at www/view/delete.php:125,
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
[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),
Call stack (most recent first):,
- get_column_sql(string(size 102), array(size 2)) at /www/lib/dml.php:897, referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ get_column_sql(string(size 102), array(size 2)) at /www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039
View->delete() at www/view/delete.php:125
deleteview_submit(object(Pieform), array(size 2)) at /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->__construct(array(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at /www/lib/mahara.php:5726,
- pieform(array(size 5)) at /www/view/delete.php:107,
- referer: https://mahara.uhi.ac.uk/view/delete.php?id=55831
+ pieform(array(size 5)) at /www/view/delete.php:107,
** Description changed:
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)
Call stack (most recent first):,
log_message(string(size 372), integer, true, true) at www/lib/errors.php:89,
log_warn(string(size 372)) at/www/lib/errors.php:853,
SQLException->__construct(string(size 372)) at www/lib/dml.php:922,
get_column_sql(string(size 102), array(size 2)) at www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039,
View->delete() at www/view/delete.php:125,
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
[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),
Call stack (most recent first):,
- get_column_sql(string(size 102), array(size 2)) at /www/lib/dml.php:897,
+ get_column_sql(string(size 102), array(size 2)) at /www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039
View->delete() at www/view/delete.php:125
- deleteview_submit(object(Pieform), array(size 2)) at /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,
+ deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
+ Pieform->__construct(array(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at /www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
** Description changed:
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)
Call stack (most recent first):,
log_message(string(size 372), integer, true, true) at www/lib/errors.php:89,
- log_warn(string(size 372)) at/www/lib/errors.php:853,
+ log_warn(string(size 372)) at /www/lib/errors.php:853,
SQLException->__construct(string(size 372)) at www/lib/dml.php:922,
get_column_sql(string(size 102), array(size 2)) at www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039,
View->delete() at www/view/delete.php:125,
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
[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),
Call stack (most recent first):,
get_column_sql(string(size 102), array(size 2)) at /www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039
View->delete() at www/view/delete.php:125
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
- Pieform->__construct(array(size 5)) at /u0/webroot/virtual/mahara.uhi.ac.uk/www/lib/pieforms/pieform.php:168,
+ Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at /www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/2017872
Title:
Error message when trying to delete collection /or pages
Status in Mahara:
New
Bug description:
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)
Call stack (most recent first):,
log_message(string(size 372), integer, true, true) at www/lib/errors.php:89,
log_warn(string(size 372)) at /www/lib/errors.php:853,
SQLException->__construct(string(size 372)) at www/lib/dml.php:922,
get_column_sql(string(size 102), array(size 2)) at www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039,
View->delete() at www/view/delete.php:125,
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
[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),
Call stack (most recent first):,
get_column_sql(string(size 102), array(size 2)) at /www/lib/dml.php:897,
get_column(string(size 18), string(size 2), string(size 20), string(size 4), string(size 18), string(size 5)) at www/lib/view.php:1039
View->delete() at www/view/delete.php:125
deleteview_submit(object(Pieform), array(size 2)) at /www/lib/pieforms/pieform.php:572,
Pieform->__construct(array(size 5)) at www/lib/pieforms/pieform.php:168,
Pieform::process(array(size 5)) at /www/lib/mahara.php:5726,
pieform(array(size 5)) at /www/view/delete.php:107,
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/2017872/+subscriptions
Follow ups
