aboutsummaryrefslogtreecommitdiffstats
path: root/install/db
diff options
context:
space:
mode:
authormistic100 <mistic@piwigo.org>2013-12-07 16:52:04 +0000
committermistic100 <mistic@piwigo.org>2013-12-07 16:52:04 +0000
commit94e948b2ac24dcf749b47ec841ef6b17eb9d2006 (patch)
treeef55a3b17f19f6987e575456886b46c240d7baf3 /install/db
parent4dc1d52afbc123c0723ecee211ca8ba15f0affec (diff)
feature 3009: "!= NULL" is invalid, use "IS NOT NULL" instead
git-svn-id: http://piwigo.org/svn/trunk@25816 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--install/db/139-database.php4
1 files changed, 2 insertions, 2 deletions
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);
}