get all results after a database update and simply free them

diff --git a/src/mysqlConn.c b/src/mysqlConn.c
index 272bb21f64451f72066ef1ca9ec0c292181ca41b..4bf15f2c4417779d299256e03f0d7a2a50759ee0 100644 (file)
--- a/src/mysqlConn.c
+++ b/src/mysqlConn.c
@@ -132,6 +132,10 @@ void init_mysql(char *host, int port, char *user, char *pass, char *base) {
             }
             fclose(f);
         }
+        do { 
+            MYSQL_RES *res = mysql_store_result(mysql_conn); 
+            mysql_free_result(res); 
+        } while(!mysql_next_result(mysql_conn));
         mysql_set_server_option(mysql_conn, MYSQL_OPTION_MULTI_STATEMENTS_OFF);
         mysql_query(mysql_conn, "INSERT INTO `version` (`database_version`) VALUES ('" DATABASE_VERSION "')");
     }
@@ -162,6 +166,10 @@ void init_mysql(char *host, int port, char *user, char *pass, char *base) {
             fclose(f);
         } else
             perror("database.sql missing!");
+        do { 
+            MYSQL_RES *res = mysql_store_result(mysql_conn); 
+            mysql_free_result(res); 
+        } while(!mysql_next_result(mysql_conn));
         mysql_set_server_option(mysql_conn, MYSQL_OPTION_MULTI_STATEMENTS_OFF);
         mysql_query(mysql_conn, "UPDATE `version` SET `database_version` = '" DATABASE_VERSION "'");
     }