Forums | Mahara Community
Support
/
DB-error deleting pages (table module_submissions)
14 January 2023, 2:55
Hi everyone,
we got the issue that deletion of pages doesn´t work anymore. All pages are affected, new created pages as well as already longer existing pages. Here ist the error-message:
- log_message("Failed to get a recordset: mysqli error: [1146: Ta...", 8, true, true) at /var/www/html/mahara/htdocs/lib/errors.php:89
- log_warn("Failed to get a recordset: mysqli error: [1146: Ta...") at /var/www/html/mahara/htdocs/lib/errors.php:853
- SQLException->__construct("Failed to get a recordset: mysqli error: [1146: Ta...") at /var/www/html/mahara/htdocs/lib/dml.php:922
- get_column_sql("SELECT "id" FROM "module_submissions" WHERE "port...", array(size 2)) at /var/www/html/mahara/htdocs/lib/dml.php:897
- get_column("module_submissions", "id", "portfolioelementtype", "view", "portfolioelementid", 75523) at /var/www/html/mahara/htdocs/lib/view.php:1089
- View->delete() at /var/www/html/mahara/htdocs/view/delete.php:125
- deleteview_submit(object(Pieform), array(size 2)) at /var/www/html/mahara/htdocs/lib/pieforms/pieform.php:577
- Pieform->__construct(array(size 5)) at /var/www/html/mahara/htdocs/lib/pieforms/pieform.php:173
- Pieform::process(array(size 5)) at /var/www/html/mahara/htdocs/lib/mahara.php:5744
- pieform(array(size 5)) at /var/www/html/mahara/htdocs/view/delete.php:107
- get_column_sql() at /var/www/html/mahara/htdocs/lib/dml.php:897
- get_column() at /var/www/html/mahara/htdocs/lib/view.php:1089
- View->delete() at /var/www/html/mahara/htdocs/view/delete.php:125
- deleteview_submit() at /var/www/html/mahara/htdocs/lib/pieforms/pieform.php:577
- Pieform->__construct() at /var/www/html/mahara/htdocs/lib/pieforms/pieform.php:173
- Pieform::process() at /var/www/html/mahara/htdocs/lib/mahara.php:5744
- pieform() at /var/www/html/mahara/htdocs/view/delete.php:107
Any ideas how it is caused?
I have never heard of or even seen a table named "module_submissions".
System environment:
Mahara 22.04.3
DB: mySQL 8.0.30
PHP 7.4.33
RHEL 8.7
Tanks for your support!
kind regards
Klaus
16 January 2023, 14:09
Hi Klaus,
This is a known issue https://bugs.launchpad.net/mahara/+bug/1995527
and there is a fix for this problem here: https://reviews.mahara.org/c/mahara/+/13422 that is going through our code review process.
Let me know if that patch works for you
Cheers
Robert
16 January 2023, 22:58
Hi Robert,
thanks a lot for pointing out! I added our page-deletion error-message to the "Unable to delete a group" bug comments.
Applying the patch works like a charm! We have appylied it in our testing system and are planning the integration to our productive system (after some additional manual tests).
Thank you and cheers
Klaus
28 January 2023, 1:40
We hit the same problem.
As a matter of interest... what does the disabled "submissions" plugin actually do? I couldn't find any documentation.
30 January 2023, 12:54
Hi Howard,
'Submissions' is a functionality that you can use in groups to submit portfolios for assessment. The functionality is also used for LTI (and MNet) to submit portfolios via an LMS.
Cheers
Kristina