[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
** Changed in: mahara/18.10 Status: Fix Committed => Fix Released -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Fix Released Status in Mahara 18.04 series: Fix Released Status in Mahara 18.10 series: Fix Released Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:94, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948667 2016] [:error] [pid 11881] [clien
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
** Changed in: mahara/18.04 Status: Fix Committed => Fix Released -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Fix Released Status in Mahara 18.04 series: Fix Released Status in Mahara 18.10 series: Fix Committed Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:94, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948667 2016] [:error] [pid 11881] [clie
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
** Changed in: mahara Status: In Progress => Fix Committed ** Also affects: mahara/18.04 Importance: Medium Status: Fix Committed ** Also affects: mahara/18.10 Importance: Undecided Status: New ** Changed in: mahara/18.10 Importance: Undecided => Medium ** Changed in: mahara/18.10 Milestone: None => 18.10.0 ** Changed in: mahara/18.10 Status: New => Fix Committed -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Fix Committed Status in Mahara 18.04 series: Fix Committed Status in Mahara 18.10 series: Fix Committed Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [cli
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
** Changed in: mahara Status: Confirmed => In Progress -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: In Progress Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:94, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948667 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::import_from_requests(object(PluginImportLeap)) at Unknown:0,
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
** Changed in: mahara Milestone: 17.10.0 => 18.04.0 -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Confirmed Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:94, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948667 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::import_from_requests(object(PluginImportLeap)) at Unknown:0, refere
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
** Changed in: mahara Milestone: 17.04.0 => 17.10.0 -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Confirmed Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:94, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948667 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::import_from_requests(object(PluginImportLeap)) at Unknown:0, refere
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
** Changed in: mahara Milestone: 16.10.1 => 17.04.0 -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Confirmed Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:94, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948667 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::import_from_requests(object(PluginImportLeap)) at Unknown:0, refere
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
** Changed in: mahara Milestone: 16.10.0 => 16.10.1 -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Confirmed Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:94, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948667 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::import_from_requests(object(PluginImportLeap)) at Unknown:0, refere
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
When the export was attempted again, the following warning message was displayed on the admin homepage: PHP on your website host does not return a useful value for the timezone identifier (%z) - certain date formatting, such as the Leap2A export, will be broken. %z is a PHP date formatting code. This problem is usually due to a limitation in running PHP on Windows. -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Confirmed Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mah
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
** Tags added: export import ** Changed in: mahara Milestone: None => 16.10.0 ** Changed in: mahara Importance: Undecided => Medium -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Confirmed Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:94, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948667 2016] [:error] [pid 11881] [client 192.168.2.47:33369] *
[Mahara-contributors] [Bug 1594192] Re: Leap2a: Importing a file artefact has failed
We need to make sure $data->mtime is valid before assign it to $artefact at line #472, htdocs/artefact/file/import/leap/lib.php. ** Attachment removed: "mahara-export-leap-user3-2016-06-16_11-18_hVXZzrwN58p9Otuq.zip" https://bugs.launchpad.net/mahara/+bug/1594192/+attachment/4686872/+files/mahara-export-leap-user3-2016-06-16_11-18_hVXZzrwN58p9Otuq.zip -- 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/1594192 Title: Leap2a: Importing a file artefact has failed Status in Mahara: Confirmed Bug description: Version: master (16.10), 16.04, 15.10 For some reasons, the attribute mtime of a file artefact in a leap2a file is empty. This cause the following error when import it. [WAR] fc (lib/errors.php:796) Failed to get a recordset: postgres8 error: [-1: ERROR: invalid input syntax for type timestamp: ""] in adodb_throw(UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? , file,0,60,1,,,2016-06-2010:17:24,,2016-06-2010:17:24,0,MasterofEducationtranscript,,,1,,0,0/60/61,61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948612 2016] [:error] [pid 11881] [client 192.168.2.47:33369] [WAR] fc (lib/errors.php:796) Command was: UPDATE "artefact" SET "artefacttype" = ? , "container" = ? , "parent" = ? , "owner" = ? , "institution" = ? , "group" = ? , "ctime" = ? , "mtime" = ? , "atime" = ? , "locked" = ? , "title" = ? , "description" = ? , "note" = ? , "author" = ? , "authorname" = ? , "allowcomments" = ? , "approvecomments" = ? , "license" = ? , "licensor" = ? , "licensorurl" = ? , "path" = ? WHERE "id" = ? and values was (0:file,1:0,2:60,3:1,4:,5:,6:2016-06-2010:17:24,7:,8:2016-06-2010:17:24,9:0,10:MasterofEducationtranscript,11:,12:,13:1,14:,15:0,16:0,17:,18:,19:,20:/60/61,21:61), referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948629 2016] [:error] [pid 11881] [client 192.168.2.47:33369] Call stack (most recent first):, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948633 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /var/www/html/mahara/master/htdocs/lib/errors.php:95, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948638 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/errors.php:796, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948642 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /var/www/html/mahara/master/htdocs/lib/dml.php:1302, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948646 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * update_record("artefact", object(stdClass), "id") at /var/www/html/mahara/master/htdocs/artefact/lib.php:628, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948649 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactType->commit() at /var/www/html/mahara/master/htdocs/artefact/file/lib.php:1062, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948653 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * ArtefactTypeFile->commit() at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:499, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948657 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_entry_data(object(stdClass), object(PluginImportLeap), "portfolio:artefact148") at /var/www/html/mahara/master/htdocs/artefact/file/import/leap/lib.php:421, referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1 [Mon Jun 20 10:17:24.948661 2016] [:error] [pid 11881] [client 192.168.2.47:33369] * LeapImportFile::create_file_from_request(object(PluginImportLeap), object(stdClass), 60) at /var/www/html/mahara/maste