09 November 2011, 6:34

Hello,

After having worked fine for several months my Admin Dashboard has now been unavailable: "Site unavailable.  A nonrecoverable error occurred. This probably means you have encountered a bug in the system".

Only the dashboard seems to be taken aback. I can't even edit the dashboard. Profile and other functions are working well (I have not detected any bugs yet).

What may have caused this. Before this happened the system sent some error messages:

Until now sending and receiving Mails was no problem. 

Please give me support.  - Two courses are working with this Mahara installation.

My Installation: Mahara 1.4.0

Thanks in advance
Regards,
Conrad

09 November 2011, 7:39

Perhaps this error log excerpt gives a hint for tracking that bug:

[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745) Failed to get a recordset: mysql error: [1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay] in EXECUTE("SELECT COUNT (DISTINCT v.id) , referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             FROM "mh_view" v, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN "mh_group" gd ON v.group = gd.id, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 SELECT, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     gtr.edit_views, gm.group AS groupid, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 FROM "mh_group" g, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 INNER JOIN "mh_group_member" gm ON (g.id = gm.group AND gm.member = '2'), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 INNER JOIN "mh_grouptype_roles" gtr ON (g.grouptype = gtr.grouptype AND gtr.role = gm.role), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             ) AS vg ON (vg.groupid = v.group), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN "mh_view_access" va ON (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 va.view = v.id, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND va.accesstype IS NOT NULL, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (va.startdate IS NULL OR va.startdate < current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (va.stopdate IS NULL OR va.stopdate > current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN "mh_usr_friend" f ON (usr1 = v.owner AND usr2 = '2'), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN "mh_view_access" vau ON (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 vau.view = v.id, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (vau.startdate IS NULL OR vau.startdate < current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (vau.stopdate IS NULL OR vau.stopdate > current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND vau.usr = '2', referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 SELECT, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     vag.view, vagm.member, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 FROM "mh_view_access" vag, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 INNER JOIN "mh_group_member" vagm ON (vag.group = vagm.group AND (vag.role = vagm.role OR vag.role IS NULL)), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 WHERE, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     (vag.startdate IS NULL OR vag.startdate < current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     AND (vag.stopdate IS NULL OR vag.stopdate > current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     AND vagm.member = '2', referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             ) AS ag ON (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 ag.view = v.id, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             )WHERE (v.owner IS NULL OR v.owner > 0) AND v.type IN ('portfolio'), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     v.owner = '2', referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     OR vg.edit_views = 1, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     OR ((v.startdate IS NULL OR v.startdate < current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                         AND (v.stopdate IS NULL OR v.stopdate > current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                         AND (va.accesstype = 'public', referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                             OR va.accesstype = 'loggedin', referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                             OR (va.accesstype = 'friends' AND f.usr2 = '2'), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                             OR (vau.usr = '2'), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                             OR (ag.member = '2'), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                         ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     v.group IS NULL OR gd.deleted = 0, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 )"), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745) Command was: SELECT COUNT (DISTINCT v.id) , referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             FROM "mh_view" v, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN "mh_group" gd ON v.group = gd.id, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 SELECT, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     gtr.edit_views, gm.group AS groupid, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 FROM "mh_group" g, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 INNER JOIN "mh_group_member" gm ON (g.id = gm.group AND gm.member = ?), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 INNER JOIN "mh_grouptype_roles" gtr ON (g.grouptype = gtr.grouptype AND gtr.role = gm.role), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             ) AS vg ON (vg.groupid = v.group), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN "mh_view_access" va ON (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 va.view = v.id, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND va.accesstype IS NOT NULL, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (va.startdate IS NULL OR va.startdate < current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (va.stopdate IS NULL OR va.stopdate > current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN "mh_usr_friend" f ON (usr1 = v.owner AND usr2 = ?), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN "mh_view_access" vau ON (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 vau.view = v.id, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (vau.startdate IS NULL OR vau.startdate < current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (vau.stopdate IS NULL OR vau.stopdate > current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND vau.usr = ?, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             LEFT OUTER JOIN (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 SELECT, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     vag.view, vagm.member, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 FROM "mh_view_access" vag, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 INNER JOIN "mh_group_member" vagm ON (vag.group = vagm.group AND (vag.role = vagm.role OR vag.role IS NULL)), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 WHERE, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     (vag.startdate IS NULL OR vag.startdate < current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     AND (vag.stopdate IS NULL OR vag.stopdate > current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     AND vagm.member = ?, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             ) AS ag ON (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 ag.view = v.id, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)             )WHERE (v.owner IS NULL OR v.owner > 0) AND v.type IN ('portfolio'), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     v.owner = ?, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     OR vg.edit_views = 1, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     OR ((v.startdate IS NULL OR v.startdate < current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                         AND (v.stopdate IS NULL OR v.stopdate > current_timestamp), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                         AND (va.accesstype = 'public', referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                             OR va.accesstype = 'loggedin', referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                             OR (va.accesstype = 'friends' AND f.usr2 = ?), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                             OR (vau.usr = ?), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                             OR (ag.member = ?), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                         ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 ), referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 AND (, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                     v.group IS NULL OR gd.deleted = 0, referer: http://www.*****/portfolio/view/blocks.php?profile=1
[Wed Nov 09 13:10:08 2011] [error] [client **.**.**.**] [WAR] f4 (lib/errors.php:745)                 ) and values was (2,2,2,2,2,2,2,2), referer: http://www.*****/portfolio/view/blocks.php?profile=1

09 November 2011, 14:50

Hi Conrad,

That's interesting, I haven't seen that error before.  It seems we'll need to rewrite the query or else enable one of the settings it's recommending in the error message.

In the short term, just delete the "Latest Pages" block from the admin's dashboard, and hopefully that will fix the problem.  You can't edit the dashboard on the site, so you'll have to do it in the database, with something like this:

DELETE FROM block_instance WHERE blocktype = 'newviews' AND view = (SELECT id FROM view WHERE owner = 2 AND type = 'dashboard');

That'll delete Latest Pages for the user with id = 2.

If it starts happening for other users, you might want to try editing the code to enable one of the settings it recommends.  In the configure_dbconnection() function in htdocs/lib/dml.php, there's a line like this:

$db->Execute("SET SQL_MODE='POSTGRESQL'");

You could try adding a similar line next to it with either "SET SQL_BIG_SELECTS=1" or "SET SQL_MAX_JOIN_SIZE=<some number>", as recommended in the error message.

09 November 2011, 18:09

Hi Richard,

thanks a lot. That worked pretty fine!  Because I tried hazardously edit the dashboard profile and put the Latest Pages Block again to my dashboard profil  I got the following error message and the dashboard was unavailable again. So I repeated the mysql intervention. (The entry in mysql block_instance was:3342  newviws  a:0:{} 

Here is the error message shown in the edit dashboard window, that seems to be the same than that from the error log, I posted before:

Failed to get a recordset: mysql error: [1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay] in EXECUTE("SELECT COUNT (DISTINCT v.id) FROM "mh_view" v LEFT OUTER JOIN "mh_group" gd ON v.group = gd.id LEFT OUTER JOIN ( SELECT gtr.edit_views, gm.group AS groupid FROM "mh_group" g INNER JOIN "mh_group_member" gm ON (g.id = gm.group AND gm.member = '2') INNER JOIN "mh_grouptype_roles" gtr ON (g.grouptype = gtr.grouptype AND gtr.role = gm.role) ) AS vg ON (vg.groupid = v.group) LEFT OUTER JOIN "mh_view_access" va ON ( va.view = v.id AND va.accesstype IS NOT NULL AND (va.startdate IS NULL OR va.startdate < current_timestamp) AND (va.stopdate IS NULL OR va.stopdate > current_timestamp) ) LEFT OUTER JOIN "mh_usr_friend" f ON (usr1 = v.owner AND usr2 = '2') LEFT OUTER JOIN "mh_view_access" vau ON ( vau.view = v.id AND (vau.startdate IS NULL OR vau.startdate < current_timestamp) AND (vau.stopdate IS NULL OR vau.stopdate > current_timestamp) AND vau.usr = '2' ) LEFT OUTER JOIN ( SELECT vag.view, vagm.member FROM "mh_view_access" vag INNER JOIN "mh_group_member" vagm ON (vag.group = vagm.group AND (vag.role = vagm.role OR vag.role IS NULL)) WHERE (vag.startdate IS NULL OR vag.startdate < current_timestamp) AND (vag.stopdate IS NULL OR vag.stopdate > current_timestamp) AND vagm.member = '2' ) AS ag ON ( ag.view = v.id )WHERE (v.owner IS NULL OR v.owner > 0) AND v.type IN ('portfolio') AND ( v.owner = '2' OR vg.edit_views = 1 OR ((v.startdate IS NULL OR v.startdate < current_timestamp) AND (v.stopdate IS NULL OR v.stopdate > current_timestamp) AND (va.accesstype = 'public' OR va.accesstype = 'loggedin' OR (va.accesstype = 'friends' AND f.usr2 = '2') OR (vau.usr = '2') OR (ag.member = '2') ) ) ) AND ( v.group IS NULL OR gd.deleted = 0 )") Command was: SELECT COUNT (DISTINCT v.id) FROM "mh_view" v LEFT OUTER JOIN "mh_group" gd ON v.group = gd.id LEFT OUTER JOIN ( SELECT gtr.edit_views, gm.group AS groupid FROM "mh_group" g INNER JOIN "mh_group_member" gm ON (g.id = gm.group AND gm.member = ?) INNER JOIN "mh_grouptype_roles" gtr ON (g.grouptype = gtr.grouptype AND gtr.role = gm.role) ) AS vg ON (vg.groupid = v.group) LEFT OUTER JOIN "mh_view_access" va ON ( va.view = v.id AND va.accesstype IS NOT NULL AND (va.startdate IS NULL OR va.startdate < current_timestamp) AND (va.stopdate IS NULL OR va.stopdate > current_timestamp) ) LEFT OUTER JOIN "mh_usr_friend" f ON (usr1 = v.owner AND usr2 = ?) LEFT OUTER JOIN "mh_view_access" vau ON ( vau.view = v.id AND (vau.startdate IS NULL OR vau.startdate < current_timestamp) AND (vau.stopdate IS NULL OR vau.stopdate > current_timestamp) AND vau.usr = ? ) LEFT OUTER JOIN ( SELECT vag.view, vagm.member FROM "mh_view_access" vag INNER JOIN "mh_group_member" vagm ON (vag.group = vagm.group AND (vag.role = vagm.role OR vag.role IS NULL)) WHERE (vag.startdate IS NULL OR vag.startdate < current_timestamp) AND (vag.stopdate IS NULL OR vag.stopdate > current_timestamp) AND vagm.member = ? ) AS ag ON ( ag.view = v.id )WHERE (v.owner IS NULL OR v.owner > 0) AND v.type IN ('portfolio') AND ( v.owner = ? OR vg.edit_views = 1 OR ((v.startdate IS NULL OR v.startdate < current_timestamp) AND (v.stopdate IS NULL OR v.stopdate > current_timestamp) AND (va.accesstype = 'public' OR va.accesstype = 'loggedin' OR (va.accesstype = 'friends' AND f.usr2 = ?) OR (vau.usr = ?) OR (ag.member = ?) ) ) ) AND ( v.group IS NULL OR gd.deleted = 0 ) and values was (2,2,2,2,2,2,2,2)

So I think that there is another bug underway. I'm worried about, that that bug may cause other failures and at least may corrupt the system in a way we couldn't use is furthermore.

Because until now I am the only user who is affected I am hesitäting to add "SET SQL_BIG_SELECTS=1" or "SET SQL_MAX_JOIN_SIZE=<some number>".  I have no sandbox to test it.

I appreciate your support and hope we will manage this challange. Until then I will live with a dashboard without Latest Pages ;-)

Thanks and Regards,
Conrad

11 November 2011, 12:15

Hi Richard,

could this bug have anything to do with this error message out of the log:

[WAR] f0 (lib/mahara.php:464) Unable to read language directory lang/

I don't understand this message, because German is pretty played. No problems with langue.
CHMOD of lang/ is 755

Thanks, Conrad

13 November 2011, 15:13

It sounds like something unrelated to the dashboard problem.

I haven't seen that before and I'm not sure what's causing it.

I'd just suggest you check whether you have any extra folders under <dataroot>/langpacks that shouldn't be there (you should really only have de.utf8 I think).  Also make sure every folder under <dataroot>/langpacks is owned by the webserver user.

13 November 2011, 17:08

Think, that this will not only happen with my dashboard (the students dashboards work fine, also with included Latest Pages Block), but will happen with every Page in that moment I drag Latest Pages Block to it.

Think the bug depends on Latest Pages and relates to messages generated.

The language folder is ok, also the ownership.  But the language files aren't only at a folder lang (I have no folder "langpacks".

This bug is really miraculous

13 November 2011, 20:02

Hi Conrad,

You're right that the bug in the query you found is to do with the Latest Pages block and will happen on any page which includes that block, not just the dashboard.

But I'd be surprised if that bug has anything to do with messages being sent twice, or anything to do with the warning about the lang folder.

01 December 2011, 14:58

Conrad just asked me what 1.4 sites should do to fix the "The SELECT would examine more than MAX_JOIN_SIZE rows" error, and I thought I'd reply on the forum in case anyone else has the same problem.

The problem should be fixed in 1.5 (https://bugs.launchpad.net/mahara/+bug/889547), but we won't be fixing it on the stable 1.4 branch.

So 1.4.x sites have a few options in the meantime:

- Change the MySQL settings (my standard install of MySQL from Ubuntu comes with SQL_BIG_SELECTS=1 and SQL_MAX_JOIN_SIZE=18446744073709551615 as the default, and I doubt those settings are crazy).  I think this would be the best option.

- Just keep running as is, and delete the latest pages blocks for any user that encounters the error.

- Delete all the latest pages blocks on the site ("DELETE FROM block_instance WHERE blocktype = 'newviews'").  This should also stop new users from getting this block on their dashboards.

- Try to rewrite the patch (https://gitorious.org/mahara/mahara/commit/5362403f242a386830df33b8f95e36a386035dc4) so that it applies against 1.4.