[Mahara-contributors] [Bug 1715288] Re: Failed to Import Custom Layout Porfolio
** Changed in: mahara Status: Incomplete => Invalid -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1715288 Title: Failed to Import Custom Layout Porfolio Status in Mahara: Invalid Bug description: Hello, I'm using Mahara 16.10 in my Centos server using PHP 5.6.30. I encountered a bug while I'm importing Portfolio which I created using custom layout (6 rows 1 column) and I also attach some files inside the portfolio. I suspect the error occurred because of log below : [WAR] ff (lib/errors.php:859) Failed to get a recordset: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails ("mahoodle"."view_rows_columns", CONSTRAINT "viewrowscolu_vie_fk" FOREIGN KEY ("view") REFERENCES "view" ("id"))] in EXECUTE("INSERT INTO "view_rows_columns" ("row", "columns") VALUES (1, 3)"), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php [Wed Sep 06 10:14:36 2017] [error] [client 10.40.1.46] [WAR] ff (lib/errors.php:859) Command was: INSERT INTO "view_rows_columns" ("row", "columns") VALUES (?, ?) and values was (row:1,columns:3), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php This isn't happening in my older version mahara (15.10). Thank you. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1715288/+subscriptions ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1715288] Re: Failed to Import Custom Layout Porfolio
Dear Cecilia, Thank you for your respond. I already apply and test the patch and it solves the problem for now. It's just like you said, the bug comes from an unknown view id because the user didn't created it yet. It surprises me that this bug wasn't show up in older version. -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1715288 Title: Failed to Import Custom Layout Porfolio Status in Mahara: Incomplete Bug description: Hello, I'm using Mahara 16.10 in my Centos server using PHP 5.6.30. I encountered a bug while I'm importing Portfolio which I created using custom layout (6 rows 1 column) and I also attach some files inside the portfolio. I suspect the error occurred because of log below : [WAR] ff (lib/errors.php:859) Failed to get a recordset: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails ("mahoodle"."view_rows_columns", CONSTRAINT "viewrowscolu_vie_fk" FOREIGN KEY ("view") REFERENCES "view" ("id"))] in EXECUTE("INSERT INTO "view_rows_columns" ("row", "columns") VALUES (1, 3)"), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php [Wed Sep 06 10:14:36 2017] [error] [client 10.40.1.46] [WAR] ff (lib/errors.php:859) Command was: INSERT INTO "view_rows_columns" ("row", "columns") VALUES (?, ?) and values was (row:1,columns:3), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php This isn't happening in my older version mahara (15.10). Thank you. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1715288/+subscriptions ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1715288] Re: Failed to Import Custom Layout Porfolio
I can't replicate the bug with Mahara 16.10 STABLE and mysql Ver 14.14 Distrib 5.7.19 But we have a patch for a similar bug: while importing a view, if it has a layout that doesn't exist in the site it will create it, but it fails when adding a row in table "view_rows_columns" because it doesn't have a view id since it hasn't been created yet. You could try this patch to see if it fixes the problem: https://reviews.mahara.org/#/c/7808 Please let us know if works for you. ** Changed in: mahara Importance: Low => Medium ** Changed in: mahara Status: New => Incomplete -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1715288 Title: Failed to Import Custom Layout Porfolio Status in Mahara: Incomplete Bug description: Hello, I'm using Mahara 16.10 in my Centos server using PHP 5.6.30. I encountered a bug while I'm importing Portfolio which I created using custom layout (6 rows 1 column) and I also attach some files inside the portfolio. I suspect the error occurred because of log below : [WAR] ff (lib/errors.php:859) Failed to get a recordset: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails ("mahoodle"."view_rows_columns", CONSTRAINT "viewrowscolu_vie_fk" FOREIGN KEY ("view") REFERENCES "view" ("id"))] in EXECUTE("INSERT INTO "view_rows_columns" ("row", "columns") VALUES (1, 3)"), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php [Wed Sep 06 10:14:36 2017] [error] [client 10.40.1.46] [WAR] ff (lib/errors.php:859) Command was: INSERT INTO "view_rows_columns" ("row", "columns") VALUES (?, ?) and values was (row:1,columns:3), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php This isn't happening in my older version mahara (15.10). Thank you. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1715288/+subscriptions ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1715288] Re: Failed to Import Custom Layout Porfolio
** Changed in: mahara Importance: Undecided => Low -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1715288 Title: Failed to Import Custom Layout Porfolio Status in Mahara: New Bug description: Hello, I'm using Mahara 16.10 in my Centos server using PHP 5.6.30. I encountered a bug while I'm importing Portfolio which I created using custom layout (6 rows 1 column) and I also attach some files inside the portfolio. I suspect the error occurred because of log below : [WAR] ff (lib/errors.php:859) Failed to get a recordset: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails ("mahoodle"."view_rows_columns", CONSTRAINT "viewrowscolu_vie_fk" FOREIGN KEY ("view") REFERENCES "view" ("id"))] in EXECUTE("INSERT INTO "view_rows_columns" ("row", "columns") VALUES (1, 3)"), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php [Wed Sep 06 10:14:36 2017] [error] [client 10.40.1.46] [WAR] ff (lib/errors.php:859) Command was: INSERT INTO "view_rows_columns" ("row", "columns") VALUES (?, ?) and values was (row:1,columns:3), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php This isn't happening in my older version mahara (15.10). Thank you. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1715288/+subscriptions ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1715288] Re: Failed to Import Custom Layout Porfolio
** Attachment added: "Exported Portfolio" https://bugs.launchpad.net/mahara/+bug/1715288/+attachment/4945122/+files/mahara-export-leap-user3-2017-09-06_02-21_d7DKApxu6l98oBra.zip ** Description changed: Hello, I'm using Mahara 16.10 in my Centos server using PHP 5.6.30. I encountered a bug while I'm importing Portfolio which I created using - custom layout (6 rows 1 column). I suspect this error occurred because - of log below : + custom layout (6 rows 1 column) and I also attach some files inside the + portfolio. I suspect the error occurred because of log below : [WAR] ff (lib/errors.php:859) Failed to get a recordset: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails ("mahoodle"."view_rows_columns", CONSTRAINT "viewrowscolu_vie_fk" FOREIGN KEY ("view") REFERENCES "view" ("id"))] in EXECUTE("INSERT INTO "view_rows_columns" ("row", "columns") VALUES (1, 3)"), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php [Wed Sep 06 10:14:36 2017] [error] [client 10.40.1.46] [WAR] ff (lib/errors.php:859) Command was: INSERT INTO "view_rows_columns" ("row", "columns") VALUES (?, ?) and values was (row:1,columns:3), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php - This isn't happening if I'm using default layout (3rows 1 column) and re - import my exported portfolio. + This isn't happening in my older version mahara (15.10). Thank you. -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1715288 Title: Failed to Import Custom Layout Porfolio Status in Mahara: New Bug description: Hello, I'm using Mahara 16.10 in my Centos server using PHP 5.6.30. I encountered a bug while I'm importing Portfolio which I created using custom layout (6 rows 1 column) and I also attach some files inside the portfolio. I suspect the error occurred because of log below : [WAR] ff (lib/errors.php:859) Failed to get a recordset: mysqli error: [1452: Cannot add or update a child row: a foreign key constraint fails ("mahoodle"."view_rows_columns", CONSTRAINT "viewrowscolu_vie_fk" FOREIGN KEY ("view") REFERENCES "view" ("id"))] in EXECUTE("INSERT INTO "view_rows_columns" ("row", "columns") VALUES (1, 3)"), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php [Wed Sep 06 10:14:36 2017] [error] [client 10.40.1.46] [WAR] ff (lib/errors.php:859) Command was: INSERT INTO "view_rows_columns" ("row", "columns") VALUES (?, ?) and values was (row:1,columns:3), referer: http://elearning.telkomuniversity.ac.id/mahara/import/index.php This isn't happening in my older version mahara (15.10). Thank you. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1715288/+subscriptions ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp