mahara-contributors team mailing list archive

[Mahara Bot <1402911@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/4097
Committed: http://gitorious.org/mahara/mahara/commit/ab4e88550e4647d9d9fd13b3ef7697baf783481e
Submitter: Son Nguyen (son.nguyen@xxxxxxxxxxxxxxx)
Branch:    master

commit ab4e88550e4647d9d9fd13b3ef7697baf783481e
Author: Aaron Wells <aaronw@xxxxxxxxxxxxxxx>
Date:   Tue Dec 16 17:26:53 2014 +1300

"group" is a reserved word in Postgres.

Bug 1402911

Change-Id: I2c30f9074d90fcd85de8f72cb260d81c589acc6d

-- 
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/1402911

Title:
  Error posting a new forum topic

Status in Mahara ePortfolio:
  In Progress
Status in Mahara 15.04 series:
  In Progress

Bug description:
  Here's an error caused by the new TinyMCE image inserter (Bug 1399054)

  [WAR] 8e (lib/errors.php:745) Failed to get a recordset: postgres8 error: [-2: ERROR:  syntax error at or near "group"
  LINE 1: SELECT group FROM "interaction_instance"  WHERE "id" =  $1
                ^] in EXECUTE("SELECT group FROM "interaction_instance"  WHERE "id" = ? ")
  Command was: SELECT group FROM "interaction_instance"  WHERE "id" = ?  and values was (1)
  Call stack (most recent first):

      log_message("Failed to get a recordset: postgres8 error: [-2: E...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:95
      log_warn("Failed to get a recordset: postgres8 error: [-2: E...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:745
      SQLException->__construct("Failed to get a recordset: postgres8 error: [-2: E...") at /home/aaronw/www/mahara/htdocs/lib/dml.php:477
      get_recordset_sql("SELECT group FROM "interaction_instance" WHERE "i...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:788
      get_field_sql("SELECT group FROM "interaction_instance" WHERE "i...", array(size 1)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:776
      get_field("interaction_instance", "group", "id", 1) at /home/aaronw/www/mahara/htdocs/interaction/forum/edittopic.php:198
      addtopic_submit(object(Pieform), array(size 9)) at Unknown:0
      call_user_func_array("addtopic_submit", array(size 2)) at /home/aaronw/www/mahara/htdocs/lib/pieforms/pieform.php:527
      Pieform->__construct(array(size 4)) at /home/aaronw/www/mahara/htdocs/lib/pieforms/pieform.php:162
      Pieform::process(array(size 4)) at /home/aaronw/www/mahara/htdocs/lib/pieforms/pieform.php:71
      pieform(array(size 4)) at /home/aaronw/www/mahara/htdocs/interaction/forum/edittopic.php:173

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1402911/+subscriptions