Changeset 7676 for extensions/GMaps/gmaps_root.class.inc.php

Timestamp:

Nov 7, 2010, 4:48:04 PM (14 years ago)

Author:

grum

Message:

fix bug:2009 - MySQL error on search tab
fix bug:2012 - MySQL 5.1 incompatibility

File:

• extensions/GMaps/gmaps_root.class.inc.php (modified) (1 diff)

extensions/GMaps/gmaps_root.class.inc.php

@@ -358 +358 @@
       $date=date('Y-m-d H:i:s', time()-$time);
 
-      $sql="DELETE FROM ".$this->tables['cache']." pgc
-              USING ".$this->tables['cache']." pgc
+      $sql="DELETE FROM ".$this->tables['cache']."
+              USING ".$this->tables['cache']."
                 JOIN ".$this->tables['cache_id']." pgci
-                ON pgc.requestId = pgci.requestId
+                ON ".$this->tables['cache'].".requestId = pgci.requestId
             WHERE pgci.`date` < '$date';";
       pwg_query($sql);