Forums | Mahara Community

Support /
Page edit mode doesn't load


Shen Zhang's profile picture
Posts: 72

26 May 2015, 10:42 AM

Hi,

One of our students has come across an issue with the edit view of a page doesn't load. It simply showing "loading" but the page never loads. The display view of the page seems ok. When she tries to change the layout, it says:

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

When I check in the error log, here is the message in the log:

=======================================

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103] [WAR] 21 (lib/errors.php:736) Failed to get a recordset: postgres7 error: [-5: ERROR:  duplicate key value violates unique constraint "blocinst_vierowcolord_uk"] in adodb_throw(UPDATE "block_instance" SET "order" = ?  WHERE "order" = ? AND "view" = ? AND "row" = ? AND "column" = ?, Array), referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103] [WAR] 21 (lib/errors.php:736) Command was: UPDATE "block_instance" SET "order" = ?  WHERE "order" = ? AND "view" = ? AND "row" = ? AND "column" = ? and values was (0,2,57156,5,1), referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103] Call stack (most recent first):, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * log_message("Failed to get a recordset: postgres7 error: [-5: E...", 8, true, true) at /usr/local/apps/mahara/htdocs/lib/errors.php:93, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * log_warn("Failed to get a recordset: postgres7 error: [-5: E...") at /usr/local/apps/mahara/htdocs/lib/errors.php:736, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * SQLException->__construct("Failed to get a recordset: postgres7 error: [-5: E...") at /usr/local/apps/mahara/htdocs/lib/dml.php:890, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * set_field_select("block_instance", "order", 0, ""order" = ? AND "view" = ? AND "row" = ? AND "colu...", array(size 4)) at /usr/local/apps/mahara/htdocs/lib/view.php:2587, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * View->shuffle_cell("5", 1, null, "2") at /usr/local/apps/mahara/htdocs/lib/view.php:2430, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * View->removecolumn(array(size 3)) at /usr/local/apps/mahara/htdocs/lib/view.php:2548, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * View->removerow(array(size 2)) at /usr/local/apps/mahara/htdocs/view/layout.php:230, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * viewlayout_submit(object(Pieform), array(size 5)) at Unknown:0, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * call_user_func_array("viewlayout_submit", array(size 2)) at /usr/local/apps/mahara/htdocs/lib/pieforms/pieform.php:528, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * Pieform->__construct(array(size 6)) at /usr/local/apps/mahara/htdocs/lib/pieforms/pieform.php:170, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * Pieform::process(array(size 6)) at /usr/local/apps/mahara/htdocs/lib/pieforms/pieform.php:71, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * pieform(array(size 6)) at /usr/local/apps/mahara/htdocs/view/layout.php:155, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103] , referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103] [WAR] 21 (lib/dml.php:890) Failed to get a recordset: postgres7 error: [-5: ERROR:  duplicate key value violates unique constraint "blocinst_vierowcolord_uk"] in adodb_throw(UPDATE "block_instance" SET "order" = ?  WHERE "order" = ? AND "view" = ? AND "row" = ? AND "column" = ?, Array), referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103] [WAR] 21 (lib/dml.php:890) Command was: UPDATE "block_instance" SET "order" = ?  WHERE "order" = ? AND "view" = ? AND "row" = ? AND "column" = ? and values was (0,2,57156,5,1), referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103] Call stack (most recent first):, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * set_field_select("block_instance", "order", 0, ""order" = ? AND "view" = ? AND "row" = ? AND "colu...", array(size 4)) at /usr/local/apps/mahara/htdocs/lib/view.php:2587, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * View->shuffle_cell("5", 1, null, "2") at /usr/local/apps/mahara/htdocs/lib/view.php:2430, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * View->removecolumn(array(size 3)) at /usr/local/apps/mahara/htdocs/lib/view.php:2548, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * View->removerow(array(size 2)) at /usr/local/apps/mahara/htdocs/view/layout.php:230, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * viewlayout_submit(object(Pieform), array(size 5)) at Unknown:0, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * call_user_func_array("viewlayout_submit", array(size 2)) at /usr/local/apps/mahara/htdocs/lib/pieforms/pieform.php:528, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * Pieform->__construct(array(size 6)) at /usr/local/apps/mahara/htdocs/lib/pieforms/pieform.php:170, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * Pieform::process(array(size 6)) at /usr/local/apps/mahara/htdocs/lib/pieforms/pieform.php:71, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103]   * pieform(array(size 6)) at /usr/local/apps/mahara/htdocs/view/layout.php:155, referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

[Tue May 26 10:08:53 2015] [error] [client 156.62.36.103] , referer: https://myportfolio.aut.ac.nz/view/layout.php?id=57156

=======================================

Has anyone here come across such issue? We are on Mahara 1.8.3. Any idea how we can fix the page?

 

Kind regards,

Shen

Robert Lyon's profile picture
Posts: 400

15 June 2015, 2:00 PM

Hi Shen,

Sorry for the late reply.

I'm not sure if you've fixed this problem but the error looks to be due to you wanting to save a block on a page and there is already one existing at the same view/column/row/order position and so the database is throwing the error as it can't have two blocks in the exact same position.

But how it thinks that is the mystery.

Are you able to check the database table block_instance to see what blocks are attached to the view? There might be some corrupt data?

Cheers

Robert

2 results