Skip to content
Snippets Groups Projects

fix table name in SQL query, fixes #1727

Merged Elmar Ludwig requested to merge biest-1727 into main
1 file
+ 1
1
Compare changes
  • Side-by-side
  • Inline
@@ -56,7 +56,7 @@ class InstituteSearch extends SearchType
@@ -56,7 +56,7 @@ class InstituteSearch extends SearchType
ORDER BY `Name` ASC";
ORDER BY `Name` ASC";
} else {
} else {
$query = "SELECT `Institut_id`, `Name`
$query = "SELECT `Institut_id`, `Name`
FROM `Institute_id`
FROM `Institute`
JOIN `user_inst` USING (`Institut_id`)
JOIN `user_inst` USING (`Institut_id`)
WHERE `user_id` = :user_id
WHERE `user_id` = :user_id
AND `Name` LIKE CONCAT('%', :input, '%')
AND `Name` LIKE CONCAT('%', :input, '%')
Loading