Forums | Mahara Community

Support /
DB-error deleting pages (table module_submissions)


Klaus Steitz's profile picture
Posts: 18

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:

[WAR] 11 (lib/errors.php:853) Failed to get a recordset: mysqli error: [1146: Table 'mahara.module_submissions' doesn't exist] in EXECUTE("SELECT "id" FROM "module_submissions"  WHERE "portfolioelementtype" = ?  AND "portfolioelementid" = ? ")Command was: SELECT "id" FROM "module_submissions"  WHERE "portfolioelementtype" = ?  AND "portfolioelementid" = ?  and values was (0:view,1:75523)
Call stack (most recent first):
  • 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
[WAR] 11 (lib/dml.php:922) Failed to get a recordset: mysqli error: [1146: Table 'mahara.module_submissions' doesn't exist] in EXECUTE("SELECT "id" FROM "module_submissions"  WHERE "portfolioelementtype" = ?  AND "portfolioelementid" = ? ")Command was: SELECT "id" FROM "module_submissions"  WHERE "portfolioelementtype" = ?  AND "portfolioelementid" = ?  and values was (0:view,1:75523)
Call stack (most recent first):
  • 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

Robert Lyon's profile picture
Posts: 748

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

Klaus Steitz's profile picture
Posts: 18

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

Howard Miller's profile picture
Posts: 191

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. 

Kristina Hoeppner's profile picture
Posts: 4706

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

5 results