mahara-contributors team mailing list archive

[Kristina Hoeppner <1681629@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara/17.10
       Status: Confirmed => In Progress

** Changed in: mahara/17.04
       Status: In Progress => Confirmed

-- 
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:
  Confirmed
Status in Mahara 17.04 series:
  Confirmed
Status in Mahara 17.10 series:
  In Progress

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