Skip to content

[patch] wrong databases are shown when selecting a server.

Hi,

We have a multiserver setup, server X has id 6 and server Y has id 26.

When we go to the list of databases, and select server X from the list, we also get the databases of server Y. This is because you match with a LIKE in the the database query.

This resolves that:

--- interface/web/sites/list/database.list.php.orig	2023-03-17 13:42:56.533206297 +0100
+++ interface/web/sites/list/database.list.php	2023-03-17 13:43:25.781272409 +0100
@@ -103,9 +103,9 @@
 $liste["item"][] = array( 'field'  => "server_id",
 	'datatype' => "INTEGER",
 	'formtype' => "SELECT",
-	'op'  => "like",
-	'prefix' => "%",
-	'suffix' => "%",
+	'op'  => "=",
+	'prefix' => "",
+	'suffix' => "",
 	'datasource' => array (  'type' => 'SQL',
 		'querystring' => 'SELECT a.server_id, a.server_name FROM server a, web_database b WHERE (a.server_id = b.server_id) AND ({AUTHSQL-B}) ORDER BY a.server_name',
 		'keyfield'=> 'server_id',