mahara-contributors team mailing list archive

[Gregor Anželj <gregor.anzelj@xxxxxxxxx>]

The problem is when Mahara database uses prefix for the tables. If there
is no prefix, there is no problem...

The SQL that causes the problems can be found in {mahararoot}/artefact/file/profileicons.json.php.
The problems are in lines 35 and 36 which are:

LEFT OUTER JOIN view_artefact va ON va.artefact = a.id
LEFT OUTER JOIN artefact_attachment aa ON aa.attachment = a.id

but should be (notice the curly brackets around table names!):

LEFT OUTER JOIN {view_artefact} va ON va.artefact = a.id
LEFT OUTER JOIN {artefact_attachment} aa ON aa.attachment = a.id

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

Title:
  Accessing profile pictures report a nonrecoverable eror

Status in Mahara ePortfolio:
  Incomplete

Bug description:
  When accessing Mahara 1.6.1 Content >> Profile pictures it states 'A
  nonrecoverable error occured. This probably means you have encoutered
  a bug in the system'.

  It also states'No images found' and when I try yo upload an image,
  page refreshed with no image uploaded and stating the nonrecoverable
  error and 'No images found'.

  Found this within Apache error logs:

  Call stack (most recent first):, referer:
  http://mahara.barony.ac.uk/artefact/file/profileicons.php

  * get_recordset_sql("SELECT a.id, a.title, a.note, (u.profileicon =
  a.i...", array(size 1), "", "") at
  /data/httpdata/v-hosts/mahara.barony.ac.uk/htdocs/lib/dml.php:667,
  referer: http://mahara.barony.ac.uk/artefact/file/profileicons.php

  * get_records_sql_array("SELECT a.id, a.title, a.note, (u.profileicon
  = a.i...", array(size 1)) at
  /data/httpdata/v-hosts/mahara.barony.ac.uk/htdocs/artefact/file/profileicons.json.php:41,
  referer: http://mahara.barony.ac.uk/artefact/file/profileicons.php

   , referer: http://mahara.barony.ac.uk/artefact/file/profileicons.php

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