Changeset 25816 for trunk/install/db

Timestamp:

Dec 7, 2013, 5:52:04 PM (11 years ago)

Author:

mistic100

Message:

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

File:

• trunk/install/db/139-database.php (modified) (1 diff)

trunk/install/db/139-database.php

@@ -54 +54 @@
   SET latitude = lat,
     longitude = lon
-  WHERE lat != NULL
-    AND lon != NULL
+  WHERE lat IS NOT NULL
+    AND lon IS NOT NULL
 ;';
   pwg_query($query);