feature 3009: "!= NULL" is invalid, use "IS NOT NULL" instead

git-svn-id: http://piwigo.org/svn/trunk@25816 68402e56-0260-453c-a942-63ccdbb3a9ee
Piwigo · Dec 7, 2013 · 94e948b · 94e948b
1 parent 4dc1d52
commit 94e948b
Showing 1 changed file with 2 additions and 2 deletions.
diff --git a/install/db/139-database.php b/install/db/139-database.php
@@ -53,8 +53,8 @@
 UPDATE '. IMAGES_TABLE .'
   SET latitude = lat,
     longitude = lon
-  WHERE lat != NULL
-    AND lon != NULL
+  WHERE lat IS NOT NULL
+    AND lon IS NOT NULL
 ;';
   pwg_query($query);
 }