mahara-contributors team mailing list archive

[Mahara Bot <889547@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/877
Committed: http://gitorious.org/mahara/mahara/commit/5362403f242a386830df33b8f95e36a386035dc4
Submitter: Francois Marier (francois@xxxxxxxxxxxxxxx)
Branch:    master

commit 5362403f242a386830df33b8f95e36a386035dc4
Author: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>
Date:   Tue Nov 22 15:33:29 2011 +1300

    Remove excess joins from latest pages query (bug #889547)
    
    When a user has many views shared with them, the view_search query
    may exceed mysql's max_join_size and cause an unrecoverable error on
    a user's dashboard, among other places.  Replacing a bunch of these
    outer joins with subselects fixes the issue, and in a few tests on a
    large postgres db, also improved performance.
    
    Change-Id: Ic3b82518e4571807ceae4747ab086eb4a9baa5db
    Signed-off-by: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/889547

Title:
  dashboard/ page unavailable - Latest Pages

Status in Mahara ePortfolio:
  Fix Committed

Bug description:
  This is the error log

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

  The error only affects one dashboard

  I´d to delete the Latest Pages Block in my Dashboard Page via  MySQL
  to be able to load the page. But the bug persists. Draggin that blog
  again to my Dashboard Page the page view is killed.

  I don't know, whether this bug is caused by/ or causes a bug in sending emails. 
  This is the error message sent by the mahara system:
  Exception 'EmailException' with message 'Couldn't send email to ****** with subject e-Portfolio *****: Neuer Ansichtenzugriff. Error from phpmailer was: SMTP Error: Data not accepted.
  SMTP server error: ' in /home/.sites/383/site150/web/portfolio/lib/user.php:457 
  But: Sending Emails were never a problem.

  Since then every mail has been sent twice. In settings I can't disable
  Email sending. It doesn't work. Disabled, the emails are sent like in
  enabling mode. No difference.

  See also:
  http://mahara.org/interaction/forum/topic.php?id=4156

  Mahara Version: 1.4.0 - 
  Linux
  PHP  5.2.16 
  MySQL 	5.1.52 
  Friefox 7.1 (but also with Chrome 15.0.874.106 m)

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