summaryrefslogtreecommitdiffstats
path: root/admin/WebConsole/gestores
diff options
context:
space:
mode:
authorRoberto Hueso Gómez <rhueso@soleta.eu>2019-10-25 11:28:07 +0200
committerOpenGnSys Support Team <soporte-og@soleta.eu>2019-10-25 14:09:39 +0200
commitdba299f6944b64961f5ee66551757293354206a1 (patch)
treea0c463043fbce7b89a6b90f844231529d6fd548f /admin/WebConsole/gestores
parent90da353673e50372fb29e1d134db4a25be7d97a9 (diff)
#915 Fix end date for gestor_colasacciones.php
This patch fixes an SQL query bug when trying to upate the end date in the 'acciones' table. The value of 'fechahorafin' cannot be NULL according to the table definition. This bug was introduced in 3ec149cb1 so it has been broken for 9 years.
Diffstat (limited to 'admin/WebConsole/gestores')
-rw-r--r--admin/WebConsole/gestores/gestor_colasacciones.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/admin/WebConsole/gestores/gestor_colasacciones.php b/admin/WebConsole/gestores/gestor_colasacciones.php
index a8212f33..68034bd8 100644
--- a/admin/WebConsole/gestores/gestor_colasacciones.php
+++ b/admin/WebConsole/gestores/gestor_colasacciones.php
@@ -85,7 +85,7 @@ function gestiona($cmd,$opcion,$acciones){
/* Update de la tabla */
$cmd->texto="UPDATE acciones
- SET estado=".$ACCION_INICIADA.",resultado=".$ACCION_SINRESULTADO.",descrinotificacion='',fechahorafin=''";
+ SET estado=".$ACCION_INICIADA.",resultado=".$ACCION_SINRESULTADO.",descrinotificacion='',fechahorafin=DEFAULT";
if(!empty($idaccion))
$cmd->texto.=" WHERE idaccion=".$idaccion;
else