Changeset 13167

Timestamp:

01/06/12 14:07:59 (1 year ago)

Author:

p_lindheimer

Message:

make sure we successfully connected to the CDR DB before trying to add the fields

Files:

• freepbx/branches/2.10/upgrades/2.10.0beta3/migration.php (modified) (1 diff)

freepbx/branches/2.10/upgrades/2.10.0beta3/migration.php

@@ -45 +45 @@
-    . $db_creds['dbname'];
-  $db_cdr = DB::connect($datasource); // attempt connection
+  if (DB::IsError($db_cdr)) { 
+    out(_("ERROR connectng to CDR DB to migrate, not done!"));
+    freepbx_log(FPBX_LOG_ERROR,"failed to open CDR DB to add recordingfile and did fields");
+  } else {
+    $sql = "SELECT recordingfile FROM cdr";
+    $confs = $db_cdr->getRow($sql, DB_FETCHMODE_ASSOC);
+    outn(_("checking if recordingfile file field needed in cdr.."));
+    if (DB::IsError($confs)) { // no error... Already done
+      $sql = "ALTER TABLE cdr ADD recordingfile VARCHAR ( 255 ) NOT NULL default ''";
+      $results = $db_cdr->query($sql);
+      if(DB::IsError($results)) {
+        out(_("failed"));
+        freepbx_log(FPBX_LOG_ERROR,"failed to add recordingfile fieled to cdr table during migration");
+      }
+      out(_("added"));
+    } else {
+      out(_("already there"));
+    }
-
-$sql = "SELECT recordingfile
-
-outn(_("checking if recordingfile
-
-$sql = "ALTER TABLE cdr ADD recordingfile VARCHAR ( 255
-
-
-
-freepbx_log(FPBX_LOG_ERROR,"failed to add recordingfile
+ $sql = "SELECT did
+ 
+ outn(_("checking if did
+ 
+ $sql = "ALTER TABLE cdr ADD did VARCHAR ( 50
+ 
+ 
+ 
+ freepbx_log(FPBX_LOG_ERROR,"failed to add did
-    }
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
-    }
-    out(_("added"));
-  } else {
-    out(_("already there"));
-  }
-}