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
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
