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/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, 
referer: http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1
  [Mon Jun 20 10:17:24.948670 2016] [:error] [pid 11881] [client 
192.168.2.47:33369]   * call_user_func_array(array(size 2), array(size 1)) at 
/var/www/html/mahara/master/htdocs/lib/mahara.php:1714, referer: 
http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1
  [Mon Jun 20 10:17:24.948675 2016] [:error] [pid 11881] [client 
192.168.2.47:33369]   * call_static_method("LeapImportFile", 
"import_from_requests", object(PluginImportLeap)) at 
/var/www/html/mahara/master/htdocs/import/leap/lib.php:299, referer: 
http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1
  [Mon Jun 20 10:17:24.949820 2016] [:error] [pid 11881] [client 
192.168.2.47:33369]   * 
PluginImportLeap->call_import_method_plugins("import_from_requests") at 
/var/www/html/mahara/master/htdocs/import/leap/lib.php:314, referer: 
http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1
  [Mon Jun 20 10:17:24.949837 2016] [:error] [pid 11881] [client 
192.168.2.47:33369]   * PluginImportLeap->do_import_from_requests() at 
/var/www/html/mahara/master/htdocs/import/index.php:311, referer: 
http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1
  [Mon Jun 20 10:17:24.949846 2016] [:error] [pid 11881] [client 
192.168.2.47:33369]   * do_import() at 
/var/www/html/mahara/master/htdocs/import/index.php:71, referer: 
http://192.168.2.47:8080/mahara/master/htdocs/import/index.php?action=1

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1594192/+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

Reply via email to