mahara-contributors team mailing list archive

[François Marier <francois@xxxxxxxxxx>]

** Summary changed:

- dashboard/ page unavailable - Latest Pages
+ Excessive number of joins when looking up latest pages

-- 
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:
  Excessive number of joins when looking up 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