mahara-contributors team mailing list archive

[Andrea Gordon <547776@xxxxxxxxxxxxxxxxxx>]

Hi Penny - this seems to be happening in the latest version also. It is
specifically with the Portfolio Search.

When you enable this and try a search in the block it returns the below:

'A nonrecoverable error occurred. This probably means you have
encountered a bug in the system'

I checked server logs and found this too:

(lib/dml.php:484) Failed to get a recordset: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 OR, referer: http://web-address.co.uk/selfsearch.php
[WAR] 63 (lib/dml.php:484)                 (LOWER(at.tag) = 'test'), referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             ) LIMI' at line 5] in EXECUTE(", referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             SELECT, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 a.id, a.artefacttype, a.title, a.description, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             FROM, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 "artefact" a, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             LEFT JOIN "artefact_tag" at ON (at.artefact = a.id), referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             WHERE, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 a.owner = '10', referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             AND (, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 (), referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 OR, referer: http://web-address.co.uk/selfsearch.php
 63 (lib/dml.php:484)                 (LOWER(at.tag) = 'test'), referer: http://web-address.co.uk/selfsearch.php
 63 (lib/dml.php:484)             ) LIMIT 10"), referer: http://web-address.co.uk/selfsearch.php
 63 (lib/dml.php:484) Command was: , referer: http://web-address.co.uk/selfsearch.php
 63 (lib/dml.php:484)             SELECT, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 a.id, a.artefacttype, a.title, a.description, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             FROM, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             LEFT JOIN "artefact_tag" at ON (at.artefact = a.id), referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             WHERE, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 a.owner = ?, referer: http://web-address.co.uk/selfsearch.php
[] [WAR] 63 (lib/dml.php:484)             AND (, referer: http://web-address.co.uk/selfsearch.php
] [WAR] 63 (lib/dml.php:484)                 (), referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 OR, referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)                 (LOWER(at.tag) = ?), referer: http://web-address.co.uk/selfsearch.php
 [WAR] 63 (lib/dml.php:484)             ) and values was (10,test), referer: http://web-address.co.uk/selfsearch.php
 Call stack (most recent first):, referer: http://web-address.co.uk/selfsearch.php
   * get_recordset_sql(", referer: http://web-address.co.uk/selfsearch.php
            SELECT, referer: http://web-address.co.uk/selfsearch.php
                a.id, a.artefa...", array(size 2), 0, 10) at /u0/webroot/virtual/web-address.co.uk/www/lib/dml.php:667, referer: http://web-address.co.uk/selfsearch.php
   * get_records_sql_array(", referer: http://web-address.co.uk/selfsearch.php
             SELECT, referer: http://web-address.co.uk/selfsearch.php
                a.id, a.artefa...", array(size 2), 0, 10) at /u0/webroot/virtual/web-address.co.uk/www/search/internal/lib.php:819, referer: http://web-address.co.uk/selfsearch.php
   * PluginSearchInternal::self_search("test", 10, 0, "all") at Unknown:0, referer: http://web-address.co.uk/selfsearch.php
   * call_user_func_array(array(size 2), array(size 4)) at /u0/webroot/virtual/web-address.co.uk/www/lib/mahara.php:1359, referer: http://web-address.co.uk/selfsearch.php
   * call_static_method("PluginSearchInternal", "self_search", "test", 10, 0, "all") at /u0/webroot/virtual/web-address.co.uk/www/lib/searchlib.php:509, referer: http://web-address.co.uk/selfsearch.php
   * search_selfsearch("test", 10, 0, "all") at /u0/webroot/virtual/web-address.co.uk/www/json/selfsearch.php:45, referer: http://web-address.co.uk/selfsearch.php
 , referer: http://web-address.co.uk/selfsearch.php

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

Title:
  Search - Non recoverable error

Status in Mahara ePortfolio:
  Fix Released

Bug description:
  When I go into the site search, search my portfolio or admin user
  search I get the following message in the information bar:

  A nonrecoverable error occured. This probably means you have
  encountered a bug in the system

  I can't run any searches at all

  This bug was imported from eduforge.org, see:
  https://eduforge.org/tracker/index.php?func=detail&aid=654&group_id=176&atid=739

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