mahara-contributors team mailing list archive

[Aaron Wells <1220028@xxxxxxxxxxxxxxxxxx>]

Using git bisect, it looks like the problem is caused by something added
in the Pagemaker mega-change:

8b34dc82d4f25e8fec7f97658e5a53789dce8058 is the first bad commit
commit 8b34dc82d4f25e8fec7f97658e5a53789dce8058
Author: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
Date:   Mon Aug 5 09:45:29 2013 +1200

    Merging flexible layouts + artefact chooser panel + new UI changes
    
    - Bugs #1201258, #1181010, #1199563
    
    As these are all integrated together it is easier to test them as
    one patchset.
    
    Change-Id: I5ce68a4ea2de1de8b9deeb7d95380fcdcae095a0
    Signed-off-by: Robert Lyon <robertl@xxxxxxxxxxxxxxx>

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

Title:
  Warnings in the activity_process_queue cron task

Status in Mahara ePortfolio:
  In Progress

Bug description:
  To replicate:

  1. Do a clean install of Mahara 1.8dev (from master)
  2. After installation is complete, run the cron job.

  You see a bunch of warning messages from the activity_process_queue
  task:

  [INF] ab (lib/cron.php:153) Running core cron activity_process_queue
  [DBG] ab (lib/activity.php:224) profile_url called with no user id
  [WAR] ab (lib/errors.php:749) Failed to get a recordset: postgres7 error: [-2: ERROR:  syntax error at or near "LIMIT"
  [WAR] ab (lib/errors.php:749) LINE 1: SELECT * FROM "group"  WHERE "id" = ?  LIMIT 2
  [WAR] ab (lib/errors.php:749)                                                ^] in adodb_throw(SELECT * FROM "group"  WHERE "id" = ?  LIMIT 2, )
  [WAR] ab (lib/errors.php:749) Command was: SELECT * FROM "group"  WHERE "id" = ? 
  Call stack (most recent first):
    * log_message("Failed to get a recordset: postgres7 error: [-2: E...", 8, true, true) at /home/aaronw/www/mahara/htdocs/lib/errors.php:109
    * log_warn("Failed to get a recordset: postgres7 error: [-2: E...") at /home/aaronw/www/mahara/htdocs/lib/errors.php:749
    * SQLException->__construct("Failed to get a recordset: postgres7 error: [-2: E...") at /home/aaronw/www/mahara/htdocs/lib/dml.php:492
    * get_recordset_sql("SELECT * FROM "group"  WHERE "id" = ? ", array(size 0), 0, 2) at /home/aaronw/www/mahara/htdocs/lib/dml.php:333
    * get_record_sql("SELECT * FROM "group"  WHERE "id" = ? ", array(size 0)) at /home/aaronw/www/mahara/htdocs/lib/dml.php:310
    * get_record("group", "id", null) at /home/aaronw/www/mahara/htdocs/lib/view.php:775
    * View->get_group_object() at /home/aaronw/www/mahara/htdocs/lib/view.php:4429
    * View->get_url(false) at /home/aaronw/www/mahara/htdocs/lib/activity.php:960
    * ActivityTypeViewaccess->__construct(object(stdClass), true) at /home/aaronw/www/mahara/htdocs/lib/activity.php:77
    * handle_activity("4", object(stdClass), true) at /home/aaronw/www/mahara/htdocs/lib/activity.php:219
    * activity_process_queue() at /home/aaronw/www/mahara/htdocs/lib/cron.php:158

  [DBG] ab (lib/activity.php:224) Failed to get a recordset: postgres7 error: [-2: ERROR:  syntax error at or near "LIMIT"
  [DBG] ab (lib/activity.php:224) LINE 1: SELECT * FROM "group"  WHERE "id" = ?  LIMIT 2
  [DBG] ab (lib/activity.php:224)                                                ^] in adodb_throw(SELECT * FROM "group"  WHERE "id" = ?  LIMIT 2, )
  [DBG] ab (lib/activity.php:224) Command was: SELECT * FROM "group"  WHERE "id" = ?

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