FYI: The portfolio search functionality has been defunct for quite some time (at least since Mahara 1.3). It probably needs quite a bit of overhaul.
-- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contrib members https://bugs.launchpad.net/bugs/1130942 Title: SQL syntax error causing search failure Status in Mahara ePortfolio: New Bug description: Opening a new bug for this issue, because (given how much time has passed) it's probably unrelated to the original problem on bug 547776: https://bugs.launchpad.net/mahara/+bug/547776/comments/4 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 To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1130942/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
