[pLog-svn] r3383 - plog/trunk

[jondaley at devel.lifetype.net]

Author: jondaley
Date: 2006-05-11 12:32:19 +0000 (Thu, 11 May 2006)
New Revision: 3383

Modified:
   plog/trunk/wizard.php
Log:
fixes a bug in mysql versions prior to 4.0.15 and 4.1.1

Modified: plog/trunk/wizard.php
===================================================================
--- plog/trunk/wizard.php	2006-05-10 14:56:03 UTC (rev 3382)
+++ plog/trunk/wizard.php	2006-05-11 12:32:19 UTC (rev 3383)
@@ -1377,8 +1377,9 @@
                 $result->Close();
             
                     // remove all duplicates in plog_config table
-                $query = "DELETE a FROM ".$this->_dbPrefix."config a, ".$this->_dbPrefix."config b WHERE a.id > b.id " .
-                    "AND a.config_key = b.config_key";
+                $query = "DELETE a FROM ".$this->_dbPrefix."config a LEFT JOIN ".$this->_dbPrefix."config b ".
+                    "ON a.config_key = b.config_key WHERE a.id > b.id ";
+
                 $result = $this->_db->Execute($query);
                 if(!$result){
                     $message .= "Error removing duplicates in config table: ".$this->_db->ErrorMsg()."<br/>";