There is no date field, and it must not be empty

diff --git a/src/Infodrom/zeitungen/update.wml b/src/Infodrom/zeitungen/update.wml
index 920410c..1e47f6c 100644 (file)
--- a/src/Infodrom/zeitungen/update.wml
+++ b/src/Infodrom/zeitungen/update.wml
@@ -22,25 +22,23 @@
        . " WHERE oid = $_POST[oid]";
     } else {
       $query = "UPDATE zeitungen SET "
-        . sprintf ("name='%s',url='%s',description='%s',city='%s',type='%s',changed='%s'",
+        . sprintf ("name='%s',url='%s',description='%s',city='%s',type='%s'",
                  addslashes ($name),
                  addslashes ($url),
                  addslashes ($description),
                  addslashes ($city),
-                 addslashes ($_POST[type]),
-                 addslashes ($_POST[date]))
+                 addslashes ($_POST[type]))
        . " WHERE oid = $_POST[oid]";
     }
   } else {
     $query = "INSERT INTO zeitungen "
       . "(name,url,description,city,type,changed) VALUES ("
-        . sprintf ("'%s','%s','%s','%s','%s','%s'",
+        . sprintf ("'%s','%s','%s','%s','%s','now()'",
                  addslashes ($name),
                  addslashes ($url),
                  addslashes ($description),
                  addslashes ($city),
-                 addslashes ($_POST[type]),
-                 addslashes ($_POST[date]))
+                 addslashes ($_POST[type]))
       . ")";
 
   }