Hello,<\/p>\n
When installing a package, during the install database step, I got this error:<\/p>\n
INSTALL ERROR!\nDATABASE CREATION FAILURE!\nUnable to remove table from database "mydb.create_synonym_db".\nPlease remove all tables from this database and try the installation again. If no tables show in the database, then Drop the database and re-create it.\nERROR MESSAGE:<\/code><\/pre>\n(the error message is empty)<\/p>\n
The database was freshly created, has no table, no view, no stored procedure. I’ve recreated it a couple of times to be sure, it doesn’t help.<\/p>\n
There are a few people complaining on this but I could not find any helpful things, for example: https:\/\/wordpress.org\/support\/topic\/not-able-to-install-backup-after-step-2\/<\/p>\n
So I’ve looked at the installer php files, and found this function in “dup-installer\/ctrls\/ctrl.s2.dbinstall.php”:<\/p>\n
\nprivate function dropProcs()\n{\n $sql = "SHOW PROCEDURE STATUS";\n $found = array();\n if ($result = mysqli_query($this->dbh, $sql)) {\n while ($row = mysqli_fetch_row($result)) {\n $found[] = $row[1];\n }\n if (count($found) > 0) {\n foreach ($found as $proc_name) {\n $sql = "DROP PROCEDURE IF EXISTS <code>".mysqli_real_escape_string($this->dbh, $this->post['dbname'])."<\/code>.<code>".mysqli_real_escape_string($this->dbh, $proc_name)."<\/code>";\n if (!$result = mysqli_query($this->dbh, $sql)) {\n DUPX_Log::error(sprintf(ERR_DBTRYCLEAN, "{$this->post['dbname']}.{$proc_name}")."<br\/>ERROR MESSAGE:{$err}");\n }\n }\n }\n }\n}\n<\/code><\/pre>\nIt seems that it tries to drop ALL the procedures from ALL the databases (“SHOW PROCEDURE STATUS” lists all the procedures for ALL databases).<\/p>\n
The “create_synonym_db” procedure is there by default on my MySQL installation, and is present in the “sys” database, so this seems to incorrectly try to drop it.<\/p>\n
If I edit the file and change the SQL with “”SHOW PROCEDURE STATUS WHERE db = ‘mydb’<\/strong>” then it works.<\/p>\nThe error message is very confusing, as it says it is unable to drop a table (where in fact this is a procedure, and from a different database).<\/p>\n
Can this please be fixed?<\/p>\n","protected":false},"template":"","class_list":["post-13461094","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/13461094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":3,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/13461094\/revisions"}],"predecessor-version":[{"id":13461124,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/13461094\/revisions\/13461124"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=13461094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}