Error when trying to create databases for user. All server_ids where put to "0" in the database.
I created databases for some websites. When i tried to connect using the link to the phpmyadmin, it showed the message "No DB-Server found!".
- Looking at it in the source code, i found that it was related to thie code in the file "database_phpmyadmin.php": ################################################################################################################## /*
- Get the data to connect to the database
*/
$dbData = $app->db->queryOneRecord("SELECT server_id FROM web_database WHERE database_id = " . $databaseId);
serverId = intval(
dbData['server_id']); if ($serverId == 0){ die ("No DB-Server found!"); } ##################################################################################################################
-
Looking at the database named "dbispconfig" i found that all the tuples in the table "web_database" had the field "server_id" with the value "0".
-
I changed to code to the corresponding value that was passed to the page "database_phpmyadmin.php" ad the variable "id" in the field "server_id" and everything worked perfectly.
-
Do you know if i made some mistake? O tried to understand the onLoad method on the file "database_edit.php" but i could not guess what could have went wrong.
The instalation is a fresh one and is in a "Ubuntu Server 64 bits".