Error posting a new forum topic

[Aaron Wells]

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

[Mahara Bot (dev-mahara)]

Patch for "master" branch: https://reviews.mahara.org/4097

[Kristina Hoeppner (kris-hoeppner)]

I suspect it also affects 1.10?

[Kristina Hoeppner (kris-hoeppner)]

Actually, just seeing that a patch was merged, I think it related to Bug #1399054. So it would only affect 15.04.

[Aaron Wells (u-aaronw)]

Yes, this one is 15.04 only.

[Mahara Bot (dev-mahara)]

Reviewed: https://reviews.mahara.org/4097
Committed: http://gitorious.org/mahara/mahara/commit/ab4e88550e4647d9d9fd13b3ef7697baf783481e
Submitter: Son Nguyen (<email address hidden>)
Branch: master

commit ab4e88550e4647d9d9fd13b3ef7697baf783481e
Author: Aaron Wells <email address hidden>
Date: Tue Dec 16 17:26:53 2014 +1300

"group" is a reserved word in Postgres.

Bug 1402911

Change-Id: I2c30f9074d90fcd85de8f72cb260d81c589acc6d