updating file config in admin section throws ctime warning

[Hugh Davenport]

[WAR] 81 (lib/errors.php:745) Failed to get a recordset: postgres7 error: [-1: ERROR: null value in column "ctime" violates not-null constraint] in EXECUTE("INSERT INTO "site_content" ("name", "content", "mtime", "mauthor") VALUES (?, ?, ?, ?)")
[WAR] 81 (lib/errors.php:745) Command was: INSERT INTO "site_content" ("name", "content", "mtime", "mauthor") VALUES (?, ?, ?, ?) and values was (uploadcopyright,,2011-06-27 15:56:20,1)
Call stack (most recent first):
  * log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, true, true) at /home/hugh/src/mahara/mahara/htdocs/lib/errors.php:109
  * log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at /home/hugh/src/mahara/mahara/htdocs/lib/errors.php:745
  * SQLException->__construct("Failed to get a recordset: postgres7 error: [-1: E...") at /home/hugh/src/mahara/mahara/htdocs/lib/dml.php:1060
  * insert_record("site_content", object(stdClass)) at /home/hugh/src/mahara/mahara/htdocs/artefact/file/lib.php:1320
  * ArtefactTypeFile::save_config_options(array(size 17)) at Unknown:0
  * call_user_func_array(array(size 2), array(size 1)) at /home/hugh/src/mahara/mahara/htdocs/lib/mahara.php:1202
  * call_static_method("ArtefactTypeFile", "save_config_options", array(size 17)) at /home/hugh/src/mahara/mahara/htdocs/admin/extensions/pluginconfig.php:114
  * pluginconfig_submit(object(Pieform), array(size 17)) at Unknown:0
  * call_user_func_array("pluginconfig_submit", array(size 2)) at /home/hugh/src/mahara/mahara/htdocs/lib/pieforms/pieform.php:512
  * Pieform->__construct(array(size 9)) at /home/hugh/src/mahara/mahara/htdocs/lib/pieforms/pieform.php:161
  * Pieform::process(array(size 9)) at /home/hugh/src/mahara/mahara/htdocs/lib/pieforms/pieform.php:71
  * pieform(array(size 9)) at /home/hugh/src/mahara/mahara/htdocs/admin/extensions/pluginconfig.php:94

[François Marier (fmarier)]

How did you get this? (what page / action did you perform)

[Hugh Davenport (hugh-davenport)]

I was a bit vague there :)

Page was on the Admin->Extensions->File config
otherwise known as /admin/extensions/pluginconfig.php?plugintype=artefact&pluginname=file&type=file

Click save, and that is what happens

[François Marier (fmarier)]

I can't reproduce this on master (tested on MySQL and Postgres).

In my postgres DB, the ctime column of site_content is nullable (i.e. it's not "NOT NULL").

[Hugh Davenport (hugh-davenport)]

https://reviews.mahara.org/556

[Mahara Bot (dev-mahara)]

Reviewed: https://reviews.mahara.org/556
Committed: http://gitorious.org/mahara/mahara/commit/f41b2c335f62f11c8ed39bd94e464b60bc52aef0
Submitter: Richard Mansfield (<email address hidden>)
Branch: master

commit f41b2c335f62f11c8ed39bd94e464b60bc52aef0
Author: Hugh Davenport <email address hidden>
Date: Tue Aug 2 16:08:01 2011 +1200

    Fix ctime constraint on file config page (bug #802337)

    Change-Id: I544009df48c0059c35c8630c84111f1fb9b90490
    Signed-off-by: Hugh Davenport <email address hidden>