mahara-contributors team mailing list archive

[Aaron Wells <1220028@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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" = ?

** Affects: mahara
     Importance: Medium
     Assignee: Aaron Wells (u-aaronw)
         Status: In Progress


** Tags: cron regression

** Tags added: regression

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