NotifySmtpCheck.php

[Pman.Core] / UpdateDatabase.php

diff --git a/UpdateDatabase.php b/UpdateDatabase.php
index 672c87d..74e89e0 100644 (file)
--- a/UpdateDatabase.php
+++ b/UpdateDatabase.php
@@ -131,6 +131,8 @@ class Pman_Core_UpdateDatabase extends Pman
     {
         PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError'));
    
+        $this->checkSystem();
+   
         $ff = HTML_FlexyFramework::get();
         
         $this->disabled = explode(',', $ff->disable);
@@ -390,11 +392,42 @@ class Pman_Core_UpdateDatabase extends Pman
                     continue;
                 }
                 
-                $cmd = "$mysql_cmd -f < " . escapeshellarg($fn) ;
+                $cmd = "$mysql_cmd -f < " . escapeshellarg($fn) ." 2>&1" ;
                 
                 echo basename($dir).'/'. basename($fn) .    '::' .  $cmd. ($this->cli ? "\n" : "<BR>\n");
                 
-                passthru($cmd);
+                
+                $fp = popen($cmd, "r"); 
+                while(!feof($fp)) 
+                { 
+                    // send the current file part to the browser 
+                    $line = trim(fgets($fp, 1024));
+                    $matches = array();
+                    if (!preg_match('/^ERROR\s+([0-9]+)/', $line, $matches)) {
+                        echo "OK - {$line}\n"; flush();
+                        continue;
+                    }
+                    $continue =0;
+                    switch($matches[1]) {
+                        case 1050: // create tables triggers this..
+                        case 1060: //    Duplicate column name 
+
+                            $continue = 1;
+                            break;
+                        
+                    }
+                    if ($continue) {
+                        echo "IGNORE - {$line}\n"; flush();
+                        continue;
+                    }
+                    // real errors...
+                    // 1051: // Unknown table -- normally drop = add iff exists..
+                    
+                    print_r(array($line,$matches));exit;
+                    
+                    
+                } 
+                
             
                 
         }
@@ -961,16 +994,16 @@ class Pman_Core_UpdateDatabase extends Pman
     
     function checkSystem()
     {
+        // most of these are from File_Convert...
+        
         // these are required - and have simple dependancies.
         require_once 'System.php';
         $req = array( 
             'convert',
             'grep',
-            'html2text',
             'pdfinfo',
-            'pdftocairo',
-            'pdftoppma',
-            'rsvg-convert',
+            'pdftoppm',
+            'rsvg-convert',  //librsvg2-bin
             'strings',
         );
          
@@ -981,6 +1014,9 @@ class Pman_Core_UpdateDatabase extends Pman
             'abiword',
             'faad',
             'ffmpeg',
+            'html2text', // not availabe in debian squeeze
+            'pdftocairo',  //poppler-utils - not available in debian squeeze.
+
             'lame',
             'ssconvert',
             'unoconv',