Paginable::TemplatesController#organisational crashes when parameter `search` is given.

[nicolasfranck]

See https://github.com/DMPRoadmap/roadmap/issues/3156

[nicolasfranck]

In lay terms: if the page of organisational templates in the org admin is long enough, and you can type in a search query in the search bar, then the page crashes.

Reproduce:

• Go to https://dmponline.be/org_admin/templates/organisational
• Hope that the list of templates there is longer than 10. Otherwise you won't see a search bar
• Type in a search query: "nothing" happens. The javascript console shows that status 500 from the server was returned

[StCyr]

I haven't investigated much but changing search method in file app/models/templates.rb as follow (so removing the joins'(org) clause) seems to return a better result:

  # Retrieves unarchived templates whose title or org.name includes the term
  # passed
  scope :search, lambda { |term|
    #unarchived.joins(:org)
    unarchived.where('lower(templates.title) LIKE lower(:term) OR ' \
                     'lower(orgs.name) LIKE lower(:term)',
                     term: "%#{term}%")
  }