07 March 2023, 1:47

Hi,

I just encountered a bug in the version 22.10.0 while trying to release a submitted portfolio:

I set the result on "revise" - our students have to submit their portfolios serveral times during the learning process - an released it. Then I got the error shown above and the portfolio is stucked in the archiving process. So the students can't work on their portfolio anymore.

Here is also the stacktrace:

[Mon Mar 06 11:07:00.526866 2023]   [WAR] 59 (lib/group.php:3882) Trying to get property 'id' of non-object, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526901 2023]   Call stack (most recent first):, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526905 2023]     * log_message(string(size 41), integer, true, true, string(size 56), integer) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/errors.php:514, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526908 2023]     * error(integer, string(size 41), string(size 56), integer, array(size 1)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/group.php:3882, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526911 2023]     * group_external_group(integer) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/collection.php:1775, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526915 2023]     * Collection->pendingrelease(object(LiveUser)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/view/view.php:354, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526930 2023]     * releaseview_submit(object(Pieform), array(size 4)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/pieforms/pieform.php:563, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526933 2023]     * Pieform->__construct(array(size 7)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/pieforms/pieform.php:159, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526936 2023]     * Pieform::process(array(size 7)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/mahara.php:5787, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526939 2023]     * pieform(array(size 7)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/view/view.php:335, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526942 2023]     * release_form(string(size 164), true) at /var/www/mahara.kim.uni-konstanz.de/htdocs/view/view.php:269, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.526945 2023]   , referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528478 2023]   [WAR] 59 (lib/errors.php:852) Failed to get a recordset: mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?  LIMIT 1' at line 1] in EXECUTE("SELECT * FROM "lti_assessment"  WHERE "group" = ?  LIMIT 1")Command was: SELECT * FROM "lti_assessment"  WHERE "group" = ? , referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528496 2023]   Call stack (most recent first):, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528499 2023]     * log_message(string(size 343), integer, true, true) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/errors.php:89, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528502 2023]     * log_warn(string(size 343)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/errors.php:852, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528505 2023]     * SQLException->__construct(string(size 343)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/dml.php:540, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528508 2023]     * get_recordset_sql(string(size 50), false, integer, integer) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/dml.php:244, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528511 2023]     * record_exists_sql(string(size 50), array(size 0)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/dml.php:208, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528514 2023]     * record_exists(string(size 14), string(size 5), null) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/group.php:3882, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528517 2023]     * group_external_group(integer) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/collection.php:1775, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528519 2023]     * Collection->pendingrelease(object(LiveUser)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/view/view.php:354, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528529 2023]     * releaseview_submit(object(Pieform), array(size 4)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/pieforms/pieform.php:563, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528533 2023]     * Pieform->__construct(array(size 7)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/pieforms/pieform.php:159, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528535 2023]     * Pieform::process(array(size 7)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/lib/mahara.php:5787, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528538 2023]     * pieform(array(size 7)) at /var/www/mahara.kim.uni-konstanz.de/htdocs/view/view.php:335, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528541 2023]     * release_form(string(size 164), true) at /var/www/mahara.kim.uni-konstanz.de/htdocs/view/view.php:269, referer: https://mahara.uni-konstanz.de/
[Mon Mar 06 11:07:00.528544 2023]   , referer: https://mahara.uni-konstanz.de/

It would be great, if there's some solution to the problem. Without working submissions we can't use Mahara proberly :(

Christine

08 June 2023, 13:37

Hi Christine,

We have worked it out and the fix is in the patch where your dev can see the code and backport it to your version of Mahara.

Cheers

Kristina