Author: mattm
Date: 2017-08-07 11:38:26 +0200 (Mon, 07 Aug 2017)
New Revision: 29323
Modified:
trunk/gvm/ChangeLog
trunk/gvm/src/manage_sql.c
Log:
* src/manage_sql.c (setting_auto_cache_rebuild_int): Provide a default
in
SQL, else sql_int aborts when there is no setting.
Modified: trunk/gvm/ChangeLog
===================================================================
--- trunk/gvm/ChangeLog 2017-08-04 11:37:04 UTC (rev 29322)
+++ trunk/gvm/ChangeLog 2017-08-07 09:38:26 UTC (rev 29323)
@@ -1,3 +1,8 @@
+2017-08-04 Matthew Mundell <matthew.mund...@greenbone.net>
+
+ * src/manage_sql.c (setting_auto_cache_rebuild_int): Provide a default
in
+ SQL, else sql_int aborts when there is no setting.
+
2017-08-04 Christian Fischer <christian.fisc...@greenbone.net>
* src/manage_config_discovery.c
(make_config_discovery_service_detection):
Modified: trunk/gvm/src/manage_sql.c
===================================================================
--- trunk/gvm/src/manage_sql.c 2017-08-04 11:37:04 UTC (rev 29322)
+++ trunk/gvm/src/manage_sql.c 2017-08-07 09:38:26 UTC (rev 29323)
@@ -59881,10 +59881,12 @@
int
setting_auto_cache_rebuild_int ()
{
- return sql_int ("SELECT value FROM settings"
- " WHERE uuid = 'a09285b0-2d47-49b6-a4ef-946ee71f1d5c'"
- " AND " ACL_USER_OWNS () ""
- " ORDER BY coalesce (owner, 0) DESC;",
+ return sql_int ("SELECT coalesce"
+ " ((SELECT value FROM settings"
+ " WHERE uuid =
'a09285b0-2d47-49b6-a4ef-946ee71f1d5c'"
+ " AND " ACL_USER_OWNS () ""
+ " ORDER BY coalesce (owner, 0) DESC),"
+ " '1');",
current_credentials.uuid);
}
_______________________________________________
Openvas-commits mailing list
Openvas-commits@wald.intevation.org
https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-commits
