Search - Non recoverable error

[Meredith Henson]

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

[Penny Leach (mjollnir)]

Hey Meredith - what instance are you seeing this error in?

[Meredith Henson (m-j-henson)]

Sorry! It's happening on the live site.

[Penny Leach (mjollnir)]

Fixed now, it was a problem with solr. I'll talk to Meredith about this in person.

[Andrea Gordon (andrea-synergy-learning)]

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, ...

[Aaron Wells (u-aaronw)]

Hi Andrea,

I've open a separate bug report for your issue, because I suspect it has a different cause than the original one for this bug. The new bug URL is https://bugs.launchpad.net/mahara/+bug/1130942

Cheers,
Aaron