Hm, ultimately this is happening because one of the changes in the code was to use the proper API functions for creating a view and changing its access (View::create() and $view->set_access()) rather than inserting directly into the database, when creating the Group Homepage template page. This causes a "viewaccess" notification to get sent to the root user.
And something in the handling of that viewaccess notification, is what causes this warning. Specifically, it looks like the problem is that the Group Homepage is a group of type "grouphomepage", but with NULL for its group column. That causes problems in the code that tries to fetch its group. Additionally (and separately), there's that earlier notice, "[DBG] ab (lib/activity.php:224) profile_url called with no user id". THAT happens while it's trying to process the "Profile Page" template which belongs to the root user, and THAT has been present since 1.7 stable, so it is not a 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 _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp