CiviCRM Community Forums (archive)

Hi,

The upgrade procedure crashed on an sql nearly at the end of the procedure, restarted from the backup and did it again.

Checked in the CRM/Upgrade/Incremental, there are a handful of lines to finish the upgrade, plus 4 templates messages to add.

I would like to generate the sql (but not run it), ie. render the templates, so I can then manually run the lines I missed. Is there a way of doing that ?

I was thinking about extending drush for do it, but have no idea where to start. Would it be complicated? Do you have an easier hack to get the sql out of the template ?

X+

Right now, quick and dirty, modified

Index: CRM/Utils/File.php
===================================================================
--- CRM/Utils/File.php (revision 29232)
+++ CRM/Utils/File.php (working copy)
@@ -235,7 +235,10 @@
 
         $string = preg_replace("/^#[^\n]*$/m", "\n", $string );
         $string = preg_replace("/^(--[^-]).*/m", "\n", $string );
-       
+       
+//XAV
+echo "\n$string\n";
+return;

Index: CRM/Upgrade/Form.php
===================================================================
--- CRM/Upgrade/Form.php (revision 29232)
+++ CRM/Upgrade/Form.php (working copy)
@@ -204,6 +204,8 @@
     }
 
     function runQuery( $query ) {
+echo "\n$query;\n";
+return;
         return CRM_Core_DAO::executeQuery( $query,
                                            CRM_Core_DAO::$_nullArray );
     }


So it echos statements online, and can see what's going on.

Thanks for the missing php updates, keeping an eye on that too.

X+