28 December 2020, 17:16

Hi,

Adding members to the institution may result in an error.

An error does not always occur, but a user who has an error once will always get an error.

Even if an error occurs, it will be displayed to members of the institution member.

Error Message

Site unavailable
A nonrecoverable error occurred. This probably means you have encountered a bug in the system

When the user with the error logs on, an error message is displayed.

Error Message

Site unavailable

A nonrecoverable error occurred. This probably means you have encountered a bug in the system

Apache Server error log when an error occurs

[Mon Dec 28 12:09:16.838350 2020] [proxy_fcgi:error] [pid 32344:tid 140183416366848] [client 122.31.66.230:53474] AH01071: Got error 'PHP message: [WAR] 4c (lib/institution.php:174) 'name' must be a string.PHP message: Call stack (most recent first):PHP message:   * Institution->findByName(integer) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/institution.php:85PHP message:   * Institution->__construct(integer) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/collection.php:837PHP message:   * Collection->can_have_progresscompletion() at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/collection.php:958PHP message:   * Collection->has_progresscompletion() at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/collection.php:1336PHP message:   * Collection->get_url() at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/view.php:1434PHP message:   * View->set_access(array(size 0), array(size 1), string(size 1)) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/view.php:1140PHP message:   * View::update_view_access(array(size 8), array(size 1)) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/collection.php:1141PHP message:   * Collection->add_views(array(size 1)) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/collection.php:419PHP message:   * Collection::create_from_template(array(size 2), string(size 2), string(size 1), false) at /home/xxxxx/xxxxx.com/public_html/maharatest/auth/user.php:1658PHP message:   * User->copy_collections(array(size 1), false) at /home/xxxxx/xxxxx.com/public_html/maharatest/auth/user.php:1722PHP message:   * User->copy_institution_views_collections_to_new_member(string(size 5)) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/institution.php:361PHP message:   * Institution->addUserAsMember(object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/institution.php:432PHP message:   * Institution->add_members(array(size 1)) at /home/xxxxx/xxxxx.com/public_html/maharatest/admin/users/institutionusers.php:259PHP message:   * institutionusers_submit(object(Pieform), array(size 5)) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/pieforms/pieform.php:568PHP message:   * Pieform->__construct(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/pieforms/pieform.php:168PHP message:   * Pieform::process(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/mahara.php:5507PHP message:   * pieform(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/maharatest/admin/users/institutionusers.php:192PHP message: ', referer: https://maharatest.xxxxx.com/admin/users/institutionusers.php?usertype=nonmembers&institution=20202

28 December 2020, 17:37

Once an error occurs, displaying a person who has left the institution on the institution member's screen will result in an error.

The message displayed on the screen is

Site unavailable
A nonrecoverable error occurred. This probably means you have encountered a bug in the system

Apache Server Error Log

[Mon Dec 28 13:33:20.134044 2020] [proxy_fcgi:error] [pid 32344:tid 140183214941952] [client 122.31.66.230:49606] AH01071: Got error 'PHP message: [WAR] 12 (lib/institution.php:174) 'name' must be a string.PHP message: Call stack (most recent first):PHP message:   * Institution->findByName(integer) at /home/xxxxx/xxxxx.com/public_html/maharatest/lib/institution.php:85PHP message:   * Institution->__construct(integer) at /home/xxxxx/xxxxx.com/public_html/maharatest/admin/users/institutionusers.php:102PHP message: ', referer: https://maharatest.xxxxx.com/admin/users/institutionusers.php?usertype=nonmembers&institution=20202

30 December 2020, 5:19

I checked on a different server, I got the same error.
There are pages with many annotations in the collection in the institute.

WheThe collections in the institute are set to be copied to the members.n trying to add multiple members at the same time,

only the first one is added and an error is displayed.

Display Message.
Mahara: Site unavailable
A nonrecoverable error occurred. This probably means you have encountered a bug in the system

Apache Error Log.

[Wed Dec 30 01:03:33.705725 2020] [proxy_fcgi:error] [pid 841:tid 140537696679680] [client 122.31.66.230:35806] AH01071: Got error 'PHP message: [WAR] e4 (lib/institution.php:174) 'name' must be a string.PHP message: Call stack (most recent first):PHP message:   * Institution->findByName(integer) at /home/xxxxx/xxxxx.com/public_html/competency/lib/institution.php:85PHP message:   * Institution->__construct(integer) at /home/xxxxx/xxxxx.com/public_html/competency/lib/collection.php:837PHP message:   * Collection->can_have_progresscompletion() at /home/xxxxx/xxxxx.com/public_html/competency/lib/collection.php:958PHP message:   * Collection->has_progresscompletion() at /home/xxxxx/xxxxx.com/public_html/competency/lib/collection.php:1336PHP message:   * Collection->get_url() at /home/xxxxx/xxxxx.com/public_html/competency/lib/view.php:1421PHP message:   * View->set_access(array(size 0), array(size 2), string(size 1)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/view.php:1140PHP message:   * View::update_view_access(array(size 8), array(size 2)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/collection.php:1141PHP message:   * Collection->add_views(array(size 2)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/collection.php:419PHP message:   * Collection::create_from_template(array(size 2), string(size 2), string(size 1), false) at /home/xxxxx/xxxxx.com/public_html/competency/auth/user.php:1658PHP message:   * User->copy_collections(array(size 2), false) at /home/xxxxx/xxxxx.com/public_html/competency/auth/user.php:1722PHP message:   * User->copy_institution_views_collections_to_new_member(string(size 5)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/institution.php:361PHP message:   * Institution->addUserAsMember(object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/institution.php:432PHP message:   * Institution->add_members(array(size 1)) at /home/xxxxx/xxxxx.com/public_html/competency/admin/users/institutionusers.php:259PHP message:   * institutionusers_submit(object(Pieform), array(size 5)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/pieforms/pieform.php:568PHP message:   * Pieform->__construct(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/pieforms/pieform.php:168PHP message:   * Pieform::process(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/mahara.php:5507PHP message:   * pieform(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/competency/admin/users/institutionusers.php:192PHP message: ', referer: https://competency.xxxxx.com/admin/users/institutionusers.php?usertype=nonmembers&institution=20202

30 December 2020, 5:41

I deleted the collection and then added members.

I waited a long time and got an error.

504 Gateway Timeout

Apache Error Log

[Wed Dec 30 01:29:19.911718 2020] [proxy_fcgi:error] [pid 8845:tid 140537721857792] [client 122.31.66.230:43538] AH01068: Got bogus version 32, referer: https://competency.xxxxx.com/view/institutionviews.php
[Wed Dec 30 01:35:49.253890 2020] [proxy_fcgi:error] [pid 14778:tid 140537151153920] [client 122.31.66.230:52468] AH01071: Got error 'PHP message: [WAR] c5 (lib/errors.php:853) Failed to get a recordset: mysqli error: [2006: MySQL server has gone away] in EXECUTE("SELECT * FROM "notification_internal_activity" WHERE "id" = 1")Command was: SELECT * FROM "notification_internal_activity" WHERE "id" = ? and values was (0:1)PHP message: Call stack (most recent first):PHP message:   * log_message(string(size 246), integer, true, true) at /home/xxxxx/xxxxx.com/public_html/competency/lib/errors.php:89PHP message:   * log_warn(string(size 246)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/errors.php:853PHP message:   * SQLException->__construct(string(size 246)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/dml.php:541PHP message:   * get_recordset_sql(string(size 61), array(size 1), string(size 0), string(size 0)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/dml.php:738PHP message:   * get_records_sql_array(string(size 61), array(size 1)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/dml.php:1496PHP message:   * update_record(string(size 30), object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/activity.php:846PHP message:   * ActivityType->notify_user(object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/activity.php:908PHP message:   * ActivityType->notify_users() at /home/xxxxx/xxxxx.com/public_html/competency/lib/activity.php:78PHP message:   * handle_activity(object(stdClass), object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/activity.php:46PHP message:   * activity_occurred(string(size 13), object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/institution.php:363PHP message:   * Institution->addUserAsMember(object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/institution.php:432PHP message:   * Institution->add_members(array(size 2)) at /home/xxxxx/xxxxx.com/public_html/competency/admin/users/institutionusers.php:259PHP message:   * institutionusers_submit(object(Pieform), array(size 5)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/pieforms/pieform.php:568PHP message:   * Pieform->__construct(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/pieforms/pieform.php:168PHP message:   * Pieform::process(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/mahara.php:5507PHP message:   * pieform(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/competency/admin/users/institutionusers.php:192PHP message: PHP message: [WAR] c5 (lib/dml.php:541) Failed to get a recordset: mysqli error: [2006: MySQL server has gone away] in EXECUTE("SELECT * FROM "notification_internal_activity" WHERE "id" = 1")Command was: SELECT * FROM "notification_internal_activity" WHERE "id" = ? and values was (0:1)PHP message: Call stack (most recent first):PHP message:   * get_recordset_sql(string(size 61), array(size 1), string(size 0), string(size 0)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/dml.php:738PHP message:   * get_records_sql_array(string(size 61), array(size 1)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/dml.php:1496PHP message:   * update_record(string(size 30), object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/activity.php:846PHP message:   * ActivityType->notify_user(object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/activity.php:908PHP message:   * ActivityType->notify_users() at /home/xxxxx/xxxxx.com/public_html/competency/lib/activity.php:78PHP message:   * handle_activity(object(stdClass), object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/activity.php:46PHP message:   * activity_occurred(string(size 13), object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/institution.php:363PHP message:   * Institution->addUserAsMember(object(stdClass)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/institution.php:432PHP message:   * Institution->add_members(array(size 2)) at /home/xxxxx/xxxxx.com/public_html/competency/admin/users/institutionusers.php:259PHP message:   * institutionusers_submit(object(Pieform), array(size 5)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/pieforms/pieform.php:568PHP message:   * Pieform->__construct(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/pieforms/pieform.php:168PHP message:   * Pieform::process(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/mahara.php:5507PHP message:   * pieform(array(size 3)) at /home/xxxxx/xxxxx.com/public_html/competency/admin/users/institutionusers.php:192PHP message: PHP message: [WAR] c5 (lib/errors.php:853) Failed to get a recordset: mysqli error: [2006: MySQL server has gone away] in EXECUTE("PHP message: [WAR] c5 (lib/errors.php:853)         SELECTPHP message: [WAR] c5 (lib/errors.php:853)             (CASEPHP message: [WAR] c5 (lib/errors.php:853)                 WHEN t.tag LIKE 'tagid_%' THEN CONCAT(i.displayname, ': ', t2.tag)PHP message: [WAR] c5 (lib/errors.php:853)                 ELSE t.tagPHP message: [WAR] c5 (lib/errors.php:853)             END) AS tag, COUNT(t.tag) AS countPHP message: [WAR] c5 (lib/errors.php:853)         FROM "tag" tPHP message: [WAR] c5 (lib/errors.php:853)         LEFT JOIN "tag" t2 ON t2.id = SUBSTRING(t.tag, 7)PHP message: [WAR] c5 (lib/errors.php:853)         LEFT JOIN "institution" i ON i.name = t2.owneridPHP message: [WAR] c5 (lib/errors.php:853)         WHERE t.resourcetype IN ('artefact', 'view', 'collection', 'blocktype')PHP message: [WAR] c5 (lib/errors.php:853)         AND t.ownertype = 'user'PHP message: [WAR] c5 (lib/errors.php:853)         AND t.ownerid = '1'PHP message: [WAR] c5 (lib/errors.php:853)         GROUP BY 1PHP message: [WAR] c5 (lib/errors.php:853)         ORDER BY COUNT(1) DESC LIMIT 20")Command was: PHP message: [WAR] c5 (lib/errors.php:853)         SELECTPHP message: [WAR] c5 (lib/errors.php:853)             (CASEPHP message: [WAR] c5 (lib/errors.php:853)                 WHEN t.tag LIKE 'tagid_%' THEN CONCAT(i.displayname, ': ', t2.tag)PHP message: [WAR] c5 (lib/errors.php:853)                 ELSE t.tagPHP message: [WAR] c5 (lib/errors.php:853)             END) AS tag, COUNT(t.tag) AS countPHP message: [WAR] c5 (lib/errors.php:853)         FROM "tag" tPHP message: [WAR] c5 (lib/errors.php:853)         LEFT JOIN "tag" t2 ON t2.id = SUBSTRING(t.tag, 7)PHP message: [WAR] c5 (lib/errors.php:853)         LEFT JOIN "institution" i ON i.name = t2.owneridPHP message: [WAR] c5 (lib/errors.php:853)         WHERE t.resourcetype IN ('artefact', 'view', 'collection', 'blocktype')PHP message: [WAR] c5 (lib/errors.php:853)         AND t.ownertype = 'user'PHP message: [WAR] c5 (lib/errors.php:853)         AND t.ownerid = ?PHP message: [WAR] c5 (lib/errors.php:853)         GROUP BY 1PHP message: [WAR] c5 (lib/errors.php:853)         ORDER BY COUNT(1) DESC LIMIT 20 and values was (0:1)PHP message: Call stack (most recent first):PHP message:   * log_message(string(size 1174), integer, true, true) at /home/xxxxx/xxxxx.com/public_html/competency/lib/errors.php:89PHP message:   * log_warn(string(size 1174)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/errors.php:853PHP message:   * SQLException->__construct(string(size 1174)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/dml.php:541PHP message:   * get_recordset_sql(string(size 524), array(size 1), string(size 0), string(size 0)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/dml.php:738PHP message:   * get_records_sql_array(string(size 524), array(size 1)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/mahara.php:4081PHP message:   * get_my_tags(string(size 2)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/mahara.php:4117PHP message:   * tags_sideblock() at /home/xxxxx/xxxxx.com/public_html/competency/lib/web.php:188PHP message:   * smarty(array(size 0), array(size 0), array(size 0), array(size 1)) at /home/xxxxx/xxxxx.com/public_html/competency/lib/errors.php:676PHP message:   * 
[Wed Dec 30 01:35:49.254276 2020] [proxy_fcgi:error] [pid 14778:tid 140537151153920] [client 122.31.66.230:52468] AH01071: Got error 'ion(object(SQLException)) at Unknown:0PHP message: PHP message: [DBG] c5 (lib/errors.php:686) Exception thrown by smarty call while handling exception:PHP message: [DBG] c5 (lib/errors.php:686) [SQLException]: Failed to get a recordset: mysqli error: [2006: MySQL server has gone away] in EXECUTE("PHP message: [DBG] c5 (lib/errors.php:686)         SELECTPHP message: [DBG] c5 (lib/errors.php:686)             (CASEPHP message: [DBG] c5 (lib/errors.php:686)                 WHEN t.tag LIKE 'tagid_%' THEN CONCAT(i.displayname, ': ', t2.tag)PHP message: [DBG] c5 (lib/errors.php:686)                 ELSE t.tagPHP message: [DBG] c5 (lib/errors.php:686)             END) AS tag, COUNT(t.tag) AS countPHP message: [DBG] c5 (lib/errors.php:686)         FROM "tag" tPHP message: [DBG] c5 (lib/errors.php:686)         LEFT JOIN "tag" t2 ON t2.id = SUBSTRING(t.tag, 7)PHP message: [DBG] c5 (lib/errors.php:686)         LEFT JOIN "institution" i ON i.name = t2.owneridPHP message: [DBG] c5 (lib/errors.php:686)         WHERE t.resourcetype IN ('artefact', 'view', 'collection', 'blocktype')PHP message: [DBG] c5 (lib/errors.php:686)         AND t.ownertype = 'user'PHP message: [DBG] c5 (lib/errors.php:686)         AND t.ownerid = '1'PHP message: [DBG] c5 (lib/errors.php:686)         GROUP BY 1PHP message: [DBG] c5 (lib/errors.php:686)         ORDER BY COUNT(1) DESC LIMIT 20")Command was: PHP message: [DBG] c5 (lib/errors.php:686)         SELECTPHP message: [DBG] c5 (lib/errors.php:686)             (CASEPHP message: [DBG] c5 (lib/errors.php:686)                 WHEN t.tag LIKE 'tagid_%' THEN CONCAT(i.displayname, ': ', t2.tag)PHP message: [DBG] c5 (lib/errors.php:686)                 ELSE t.tagPHP message: [DBG] c5 (lib/errors.php:686)             END) AS tag, COUNT(t.tag) AS countPHP message: [DBG] c5 (lib/errors.php:686)         FROM "tag" tPHP message: [DBG] c5 (lib/errors.php:686)         LEFT JOIN "tag" t2 ON t2.id = SUBSTRING(t.tag, 7)PHP message: [DBG] c5 (lib/errors.php:686)         LEFT JOIN "institution" i ON i.name = t2.owneridPHP message: [DBG] c5 (lib/errors.php:686)         WHERE t.resourcetype IN ('artefact', 'view', 'collection', 'blocktype')PHP message: [DBG] c5 (lib/errors.php:686)         AND t.ownertype = 'user'PHP message: [DBG] c5 (lib/errors.php:686)         AND t.ownerid = ?PHP message: [DBG] c5 (lib/errors.php:686)         GROUP BY 1PHP message: [DBG] c5 (lib/errors.php:686)         ORDER BY COUNT(1) DESC LIMIT 20 and values was (0:1)', referer: https://competency.xxxxx.com/admin/users/institutionusers.php?usertype=nonmembers&institution=20201a

30 December 2020, 15:45

Once an error occurs, I will not be able to create a new institution with a double-byte institution name.

The language used is Japanese.

21 January 2021, 9:24

Hi AB-Net,

Can you please provide the setup and steps that would be needed on Mahara to reproduce the error you encountered? Some questions:

• How many institutions do you have set up? What are they called when you set them up? To what did you change the name?
• Do you add students directly to the institutions or upload them first to 'No institution'?

It would help greatly to get a step-by-step description of how you set things up so we can replicate exactly these steps, e.g.

1. Set up a site with 1 institution that has an English name.
2. Change the institution's display name to a Japanese name.
   Expected result: ...
   Actual result (if the error already occurs then): ...

Thank you

Kristina

22 January 2021, 15:49

Hi Kristina,

> How many institutions do you have set up?

I have created 4 institutions.

> What are they called when you set them up? 

I named the four institutions in Japanese.

"2020年度認定動物看護師職種資格枠組" Short Name "2020"

"2020宮崎ペットワールド専門学校2年生テスト" Short Name "20202"

"2020宮崎ペットワールド専門学校1年生テスト" Short Name "20203"

"inst" Short Name "inst"

Renamed the institution named "inst" to "2020年度入学美容総合科高度ビューティコース"

> Do you add students directly to the institutions or upload them first to 'No institution'?

I upload them first to 'No institution'.

22 January 2021, 15:54

Expected result:

1.I add a collection to the institution.

2.I  add students to " No institution".

3.I add students to the institution.

4.The collection is automatically copied to students.

09 February 2021, 23:05

Hi,

You have a couple of different error messages. One says that the institution name, i.e. shortname, must be a string and not just a number, but your institutions all have numbers. Mahara from version 20.04 supports that. The second error message mentions portfolio completion. Does your collection contain the portfolio completion progress page and the required sign-off blocks?

Thanks

Kristina

08 May 2021, 17:19

Hi Kristina,

Sorry for the late contact.

I gave up using it in the business until March, upgraded it to 21.04, and tried to use it again.

Is the portfolio completion progress page a progress page?

I'm not sure about the required sign-off blocks, so please tell me a little more.

Thank you.

AB-Net.