Patch for "master" branch: https://reviews.mahara.org/7625
-- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1681629 Title: Search on "Pages and collections" doesn't work for collections Status in Mahara: In Progress Status in Mahara 17.04 series: In Progress Status in Mahara 17.10 series: Confirmed Bug description: Mahara master / 17.04RC1 When you try to search for a collection, the following error message is returned: [WAR] cf (lib/errors.php:859) Failed to get a recordset: postgres8 error: [-2: ERROR: syntax error at or near ")" LINE 1: SELECT * FROM "view_tag" WHERE view IN () ^] in EXECUTE("SELECT * FROM "view_tag" WHERE view IN () ")Command was: SELECT * FROM "view_tag" WHERE view IN () Call stack (most recent first): log_message("Failed to get a recordset: postgres8 error: [-2: E...", 8, true, true) at /home/kristina/code/mahara/htdocs/lib/errors.php:95 log_warn("Failed to get a recordset: postgres8 error: [-2: E...") at /home/kristina/code/mahara/htdocs/lib/errors.php:859 SQLException->__construct("Failed to get a recordset: postgres8 error: [-2: E...") at /home/kristina/code/mahara/htdocs/lib/dml.php:517 get_recordset_sql("SELECT * FROM "view_tag" WHERE view IN () ", false) at /home/kristina/code/mahara/htdocs/lib/dml.php:466 get_recordset_select("view_tag", " WHERE view IN ()", null, "", "*", "", "") at /home/kristina/code/mahara/htdocs/lib/dml.php:666 get_records_select_array("view_tag", "view IN ()") at /home/kristina/code/mahara/htdocs/lib/view.php:5377 View::get_extra_view_info(array(size 1), false) at /home/kristina/code/mahara/htdocs/lib/view.php:3801 View::get_myviews_data(12, 0, "asdfasdf", null, null, "titleanddescriptionandtags", "latestviewed") at /home/kristina/code/mahara/htdocs/lib/view.php:4025 View::views_by_owner() at /home/kristina/code/mahara/htdocs/view/index.php:25 [WAR] cf (lib/dml.php:517) Failed to get a recordset: postgres8 error: [-2: ERROR: syntax error at or near ")" LINE 1: SELECT * FROM "view_tag" WHERE view IN () ^] in EXECUTE("SELECT * FROM "view_tag" WHERE view IN () ")Command was: SELECT * FROM "view_tag" WHERE view IN () Call stack (most recent first): get_recordset_sql("SELECT * FROM "view_tag" WHERE view IN () ", false) at /home/kristina/code/mahara/htdocs/lib/dml.php:466 get_recordset_select("view_tag", " WHERE view IN ()", null, "", "*", "", "") at /home/kristina/code/mahara/htdocs/lib/dml.php:666 get_records_select_array("view_tag", "view IN ()") at /home/kristina/code/mahara/htdocs/lib/view.php:5377 View::get_extra_view_info(array(size 1), false) at /home/kristina/code/mahara/htdocs/lib/view.php:3801 View::get_myviews_data(12, 0, "asdfasdf", null, null, "titleanddescriptionandtags", "latestviewed") at /home/kristina/code/mahara/htdocs/lib/view.php:4025 View::views_by_owner() at /home/kristina/code/mahara/htdocs/view/index.php:25 To replicate: 1. Set up a collection "Collection" with the tags "collectiontag" and "tag". 2. Set up a page "Page" with the tag "pagetag" and "tag". 3. Search within "Title, description" / "Title, description, tags" for "collection", "collectiontag" and "tag" You get an error message. Expected result: It finds your page and / or collection. Additionally, if you select to search within "Tags" but don't provide a search term, all results should be displayed. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1681629/+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
