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 : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
