Fix #5814 - do not create tirggers

[Pman.Core] / UpdateDatabase / MysqlLinks.php

diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php
index 62a6687..07cf02f 100644 (file)
--- a/UpdateDatabase/MysqlLinks.php
+++ b/UpdateDatabase/MysqlLinks.php
@@ -49,15 +49,20 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
         $this->updateTableComments();
        
         $ff = HTML_FlexyFramework::get();
-        if (!empty($ff->Pman['enable_trigger_tests'])) {
+        if (empty($ff->Pman['enable_trigger_tests'])) {
+            return;
+        }
+        if (!empty($ff->page->opts['disable-create-triggers'])) {
+            return;
+        }
             
             // note we may want to override some of these... - to do special triggers..
             // as you can only have one trigger per table for each action.
             
-            $this->createDeleteTriggers();
-            $this->createInsertTriggers();
-            $this->createUpdateTriggers();
-        }
+        $this->createDeleteTriggers();
+        $this->createInsertTriggers();
+        $this->createUpdateTriggers();
+        
         
         
     }
@@ -73,13 +78,13 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
         $dbini = 'ini_'. basename($this->dburl['path']);
         
         
-        $iniCache = $ff->DB_DataObject[$dbini];
-        
+        $iniCache = isset( $ff->PDO_DataObject) ?  $ff->PDO_DataObject['schema_location'] : $ff->DB_DataObject[$dbini];
+               
         $this->schema = parse_ini_file($iniCache, true);
         $this->links = parse_ini_file(preg_replace('/\.ini$/', '.links.ini', $iniCache), true);
         
         $lcfg = &$this->links;
-        $cfg = HTML_FlexyFramework::get()->DB_DataObject;
+        $cfg = empty($ff->DB_DataObject) ? array() : $ff->DB_DataObject;
         
         if (!empty($cfg['table_alias'])) {
             $ta = $cfg['table_alias'];
@@ -134,7 +139,7 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
                     FROM
                         information_schema.TABLES
                     WHERE
-                        TABLE_SCHEMA = '{$q->escape($q->database())}'
+                        TABLE_SCHEMA = DATABASE()
                         AND
                         TABLE_NAME = '{$q->escape($tbl)}'
         ");
@@ -437,14 +442,6 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
             $q = DB_DataObject::factory('core_enum');
             $q->query($trigger);
             echo "CREATED TRIGGER {$tbl}_before_update\n";
-            if ($tbl == 'core_email') {
-                echo $trigger;
-                exit;
-            }
-            
-            
-            
-            
             
             
         }