From 94e948b2ac24dcf749b47ec841ef6b17eb9d2006 Mon Sep 17 00:00:00 2001
From: mistic100 <mistic@piwigo.org>
Date: Sat, 7 Dec 2013 16:52:04 +0000
Subject: feature 3009: "!= NULL" is invalid, use "IS NOT NULL" instead

git-svn-id: http://piwigo.org/svn/trunk@25816 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 install/db/139-database.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'install')

diff --git a/install/db/139-database.php b/install/db/139-database.php
index a1d6e8bb5..4d266b6ef 100644
--- a/install/db/139-database.php
+++ b/install/db/139-database.php
@@ -53,8 +53,8 @@ if (pwg_db_num_rows(pwg_query($query)))
 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);
 }
-- 
cgit v1.2.3