[pLog-svn] r3384 - plog/trunk

[Jon Daley]

 	A guy on the forums had a 4.0.x install, so I think we are okay 
for that.  I have not tested a 3.x install at all.

On Fri, 12 May 2006, BalearWeb wrote:

> Hello, I can give you access to a 4.0.X, if you are still interested
> in it.
>
> I have been rather busy these days without testing the latests
> snapshots but I hope to be able to do some testing soon
> again.
>
> Kind regards,
>
> Elena
>
> jondaley at devel.lifetype.net wrote:
>
>> Author: jondaley
>> Date: 2006-05-11 14:45:23 +0000 (Thu, 11 May 2006)
>> New Revision: 3384
>> 
>> Modified:
>>   plog/trunk/wizard.php
>> Log:
>> another attempt. This should work for both 4.1 and 4.0 mysql versions.  Do 
>> people still run mysql3?  Can I get access to a database to try this out?
>> 
>> Modified: plog/trunk/wizard.php
>> ===================================================================
>> --- plog/trunk/wizard.php	2006-05-11 12:32:19 UTC (rev 3383)
>> +++ plog/trunk/wizard.php	2006-05-11 14:45:23 UTC (rev 3384)
>> @@ -1368,7 +1368,6 @@
>>                     $result->Close();
>>                 }
>>             }
>> -
>>                 // check to see if we need to remove duplicates and the id 
>> index
>>             $query = "SELECT id FROM ".$this->_dbPrefix."config LIMIT 1";
>>             $result = $this->_db->Execute($query);
>> @@ -1382,10 +1381,19 @@
>>
>>                 $result = $this->_db->Execute($query);
>>                 if(!$result){
>> -                    $message .= "Error removing duplicates in config 
>> table: ".$this->_db->ErrorMsg()."<br/>";
>> -                    $errors = true;
>> +                        // On 4.0, the above query won't work, so let's 
>> try it in 4.0 syntax
>> +                        // remove all duplicates in plog_config table
>> +                    $query = "DELETE ".$this->_dbPrefix."config 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 (tried 4.0 
>> and 4.1 syntax) in config table: ".
>> +                            $this->_db->ErrorMsg()."<br/>";
>> +                        $errors = true;
>> +                    }
>>                 }
>> -                else{
>> +                if($result){
>>                     $result->Close();
>>
>>                     // remove index id field, we don't need it any more!
>> 
>> _______________________________________________
>> pLog-svn mailing list
>> pLog-svn at devel.lifetype.net
>> http://devel.lifetype.net/mailman/listinfo/plog-svn
>>
>> 
>
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn
>

**************************************
Jon Daley
http://jon.limedaley.com/

Aim low; reach your goals, avoid disappointment