modules/UpgradeWizard/end.php

   1 <?php
   2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
   3 /*********************************************************************************
   4  * SugarCRM Community Edition is a customer relationship management program developed by
   5  * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
   6  *
   7  * This program is free software; you can redistribute it and/or modify it under
   8  * the terms of the GNU Affero General Public License version 3 as published by the
   9  * Free Software Foundation with the addition of the following permission added
  10  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  11  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  12  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  13  *
  14  * This program is distributed in the hope that it will be useful, but WITHOUT
  15  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  16  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  17  * details.
  18  *
  19  * You should have received a copy of the GNU Affero General Public License along with
  20  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  21  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  22  * 02110-1301 USA.
  23  *
  24  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  25  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  26  *
  27  * The interactive user interfaces in modified source and object code versions
  28  * of this program must display Appropriate Legal Notices, as required under
  29  * Section 5 of the GNU Affero General Public License version 3.
  30  *
  31  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  32  * these Appropriate Legal Notices must retain the display of the "Powered by
  33  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  34  * technical reasons, the Appropriate Legal Notices must display the words
  35  * "Powered by SugarCRM".
  36  ********************************************************************************/
  37
  38 /*********************************************************************************
  39
  40  * Description:
  41  * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. All Rights
  42  * Reserved. Contributor(s): ______________________________________..
  43  * *******************************************************************************/
  44 logThis('[At end.php]');
  45 global $unzip_dir;
  46 global $path;
  47 global $sugar_config;
  48
  49 if($unzip_dir == null ) {
  50         $unzip_dir = $_SESSION['unzip_dir'];
  51 }
  52
  53 //First repair the databse to ensure it is up to date with the new vardefs/tabledefs
  54 logThis('About to repair the database.', $path);
  55 //Use Repair and rebuild to update the database.
  56 global $dictionary, $beanFiles;
  57
  58 require_once('modules/Trackers/TrackerManager.php');
  59 $trackerManager = TrackerManager::getInstance();
  60 $trackerManager->pause();
  61 $trackerManager->unsetMonitors();
  62
  63 require_once("modules/Administration/QuickRepairAndRebuild.php");
  64 $rac = new RepairAndClear();
  65 $rac->clearVardefs();
  66 $rac->rebuildExtensions();
  67 //bug: 44431 - defensive check to ensure the method exists since upgrades to 6.2.0 may not have this method define yet.
  68 if(method_exists($rac, 'clearExternalAPICache'))
  69 {
  70     $rac->clearExternalAPICache();
  71 }
  72
  73 $repairedTables = array();
  74
  75 foreach ($beanFiles as $bean => $file) {
  76         if(file_exists($file)){
  77                 require_once ($file);
  78                 unset($GLOBALS['dictionary'][$bean]);
  79                 $focus = new $bean ();
  80                 if (($focus instanceOf SugarBean))
  81                 {
  82                         if(!isset($repairedTables[$focus->table_name]))
  83                         {
  84                                 $sql = $GLOBALS['db']->repairTable($focus, true);
  85                                 logThis('Running sql:' . $sql, $path);
  86                                 $repairedTables[$focus->table_name] = true;
  87                         }
  88
  89                         //Check to see if we need to create the audit table
  90                     if($focus->is_AuditEnabled() && !$focus->db->tableExists($focus->get_audit_table_name())){
  91                        logThis('Creating audit table:' . $focus->get_audit_table_name(), $path);
  92                $focus->create_audit_table();
  93             }
  94                 }
  95         }
  96 }
  97
  98 $olddictionary = $dictionary;
  99
 100 unset ($dictionary);
 101 include ('modules/TableDictionary.php');
 102 foreach ($dictionary as $meta) {
 103         $tablename = $meta['table'];
 104         if (isset($repairedTables[$tablename])) continue;
 105         $fielddefs = $meta['fields'];
 106         $indices = $meta['indices'];
 107         $sql = $GLOBALS['db']->repairTableParams($tablename, $fielddefs, $indices, true);
 108         logThis('Running sql:' . $sql, $path);
 109         $repairedTables[$tablename] = true;
 110 }
 111
 112                 $dictionary = $olddictionary;
 113
 114 logThis('database repaired', $path);
 115
 116 $ce_to_pro_ent = isset($_SESSION['upgrade_from_flavor']) && ($_SESSION['upgrade_from_flavor'] == 'SugarCE to SugarPro' || $_SESSION['upgrade_from_flavor'] == 'SugarCE to SugarEnt' || $_SESSION['upgrade_from_flavor'] == 'SugarCE to SugarCorp' || $_SESSION['upgrade_from_flavor'] == 'SugarCE to SugarUlt');
 117
 118
 119 logThis(" Start Rebuilding the config file again", $path);
 120
 121 //check and set the logger before rebuilding config
 122 if(!isset($sugar_config['logger'])){
 123         $sugar_config['logger'] =array (
 124                 'level'=>'fatal',
 125             'file' =>
 126               array (
 127                       'ext' => '.log',
 128                       'name' => 'sugarcrm',
 129                       'dateFormat' => '%c',
 130                       'maxSize' => '10MB',
 131                       'maxLogs' => 10,
 132                       'suffix' => '%m_%Y',
 133                   ),
 134         );
 135 }
 136
 137 if(!rebuildConfigFile($sugar_config, $sugar_version)) {
 138         logThis('*** WARNING: could not write config.php!', $path);
 139 }
 140 logThis(" Finish Rebuilding the config file again", $path);
 141
 142 set_upgrade_progress('end','in_progress');
 143
 144
 145 if(isset($_SESSION['current_db_version']) && isset($_SESSION['target_db_version'])){
 146         if($_SESSION['current_db_version'] != $_SESSION['target_db_version']){
 147                 logThis("Upgrading multienum data", $path);
 148         require_once("$unzip_dir/scripts/upgrade_multienum_data.php");
 149         upgrade_multienum_data();
 150          }
 151
 152
 153          //keeping separate. making easily visible and readable
 154          if($_SESSION['current_db_version'] == $_SESSION['target_db_version']){
 155             $_REQUEST['upgradeWizard'] = true;
 156             ob_start();
 157                         include('modules/ACL/install_actions.php');
 158                         include_once('include/Smarty/internals/core.write_file.php');
 159                 ob_end_clean();
 160                 $db =& DBManagerFactory::getInstance();
 161                 if($ce_to_pro_ent){
 162                 //Also set license information
 163                         $admin = new Administration();
 164                         $category = 'license';
 165                         $value = '0';
 166                         $admin->saveSetting($category, 'users', $value);
 167                         $key = array('num_lic_oc','key','expire_date');
 168                         $value = '';
 169                         foreach($key as $k){
 170                                 $admin->saveSetting($category, $k, $value);
 171                         }
 172                 }
 173         }
 174 }
 175
 176 // Mark the instance as having gone thru the admin wizard
 177 $admin = new Administration();
 178 $admin->saveSetting('system','adminwizard',1);
 179
 180  /////////////////////////Old Logger settings///////////////////////////////////////
 181 ///////////////////////////////////////////////////////////////////////////////
 182 if(file_exists('modules/Configurator/Configurator.php')){
 183         require_once('include/utils/array_utils.php');
 184         require_once('modules/Configurator/Configurator.php');
 185         $Configurator = new Configurator();
 186         $Configurator->parseLoggerSettings();
 187 }
 188 //unset the logger previously instantiated
 189 if(file_exists('include/SugarLogger/LoggerManager.php')){
 190
 191         unset($GLOBALS['log']);
 192         $GLOBALS['log'] = LoggerManager::getLogger('SugarCRM');
 193 }
 194
 195
 196 //Upgrade connectors
 197 if($_SESSION['current_db_version'] < '610' && function_exists('upgrade_connectors'))
 198 {
 199    upgrade_connectors($path);
 200 }
 201
 202 // Enable the InsideView connector by default
 203 if($_SESSION['current_db_version'] < '621' && function_exists('upgradeEnableInsideViewConnector')) {
 204     upgradeEnableInsideViewConnector();
 205 }
 206
 207 if ($_SESSION['current_db_version'] < '620' && ($sugar_config['dbconfig']['db_type'] == 'mssql' || $sugar_config['dbconfig']['db_type'] == 'oci8'))
 208 {
 209     repair_long_relationship_names($path);
 210 }
 211
 212 //Global search support
 213 if($_SESSION['current_db_version'] < '620' && function_exists('add_unified_search_to_custom_modules_vardefs'))
 214 {
 215    logThis('Add global search for custom modules start .', $path);
 216    add_unified_search_to_custom_modules_vardefs();
 217    logThis('Add global search for custom modules finished .', $path);
 218 }
 219
 220 //Upgrade system displayed tabs and subpanels
 221 if(function_exists('upgradeDisplayedTabsAndSubpanels'))
 222 {
 223         upgradeDisplayedTabsAndSubpanels($_SESSION['current_db_version']);
 224 }
 225
 226
 227 //Unlink files that have been removed
 228 if(function_exists('unlinkUpgradeFiles'))
 229 {
 230         unlinkUpgradeFiles($_SESSION['current_db_version']);
 231 }
 232
 233 require_once('modules/Administration/upgrade_custom_relationships.php');
 234 upgrade_custom_relationships();
 235
 236 require_once('modules/UpgradeWizard/uw_utils.php');
 237 if($_SESSION['current_db_version'] < '620')
 238 {
 239         upgradeDateTimeFields($path);
 240         upgradeDocumentTypeFields($path);
 241 }
 242
 243 //Update the license
 244 logThis('Start Updating the license ', $path);
 245 ob_start();
 246
 247    check_now(get_sugarbeat());
 248 ob_end_clean();
 249 logThis('End Updating the license ', $path);
 250
 251 set_upgrade_progress('end','done');
 252
 253 logThis('Cleaning up the session.  Goodbye.');
 254 unlinkTempFiles();
 255 logThis('Cleaning up the session.  Goodbye.');
 256 resetUwSession();
 257 // flag to say upgrade has completed
 258 $_SESSION['upgrade_complete'] = true;
 259
 260 //add the clean vardefs here
 261 if(!class_exists('VardefManager')){
 262
 263 }
 264 VardefManager::clearVardef();
 265
 266 require_once('include/TemplateHandler/TemplateHandler.php');
 267 TemplateHandler::clearAll();
 268
 269 //also add the cache cleaning here.
 270 if(function_exists('deleteCache')){
 271         deleteCache();
 272 }
 273
 274 global $mod_strings;
 275 global $current_language;
 276
 277 if(!isset($current_language) || ($current_language == null)){
 278         $current_language = 'en_us';
 279 }
 280 if(isset($GLOBALS['current_language']) && ($GLOBALS['current_language'] != null)){
 281         $current_language = $GLOBALS['current_language'];
 282 }
 283 $mod_strings = return_module_language($current_language, 'UpgradeWizard');
 284 $stop = false;
 285
 286
 287 $httpHost               = $_SERVER['HTTP_HOST'];  // cn: 8472 - HTTP_HOST includes port in some cases
 288 if($colon = strpos($httpHost, ':')) {
 289         $httpHost       = substr($httpHost, 0, $colon);
 290 }
 291 $parsedSiteUrl  = parse_url($sugar_config['site_url']);
 292 $host                   = ($parsedSiteUrl['host'] != $httpHost) ? $httpHost : $parsedSiteUrl['host'];
 293
 294 // aw: 9747 - use SERVER_PORT for users who don't plug in the site_url at install correctly
 295 if ($_SERVER['SERVER_PORT'] != 80){
 296         $port = ":".$_SERVER['SERVER_PORT'];
 297 }
 298 else if (isset($parsedSiteUrl['port']) && $parsedSiteUrl['port'] != 80){
 299         $port = ":".$parsedSiteUrl['port'];
 300 }
 301 else{
 302         $port = '';
 303 }
 304 $path                   = $parsedSiteUrl['path'];
 305 $cleanUrl               = "{$parsedSiteUrl['scheme']}://{$host}{$port}{$path}/index.php";
 306
 307 $uwMain =<<<eoq
 308 <table cellpadding="3" cellspacing="0" border="0">
 309
 310         <tr>
 311                 <td align="left">
 312                         <p>
 313                         <br>
 314                         {$mod_strings['LBL_UW_END_LOGOUT_PRE2']}
 315                         <br>
 316                         <br>
 317             <b>{$mod_strings['LBL_UW_END_LOGOUT_PRE']}</b> {$mod_strings['LBL_UW_END_LOGOUT']}
 318                         </p>
 319                 </td>
 320         </tr>
 321 </table>
 322
 323 <script>
 324  function deleteCacheAjax(){
 325         //AJAX call for checking the file size and comparing with php.ini settings.
 326         var callback = {
 327                  success:function(r) {
 328                      //alert(r.responseText);
 329                  }
 330         }
 331         postData = '&module=UpgradeWizard&action=deleteCache&to_pdf=1';
 332         YAHOO.util.Connect.asyncRequest('POST', 'index.php', callback, postData);
 333 }
 334 </script>
 335 eoq;
 336
 337 $showBack               = false;
 338 $showCancel             = false;
 339 $showRecheck    = false;
 340 $showNext               = false;
 341 $showDone       = true;
 342
 343 $stepBack               = 0;
 344 $stepNext               = 0;
 345 $stepCancel     = 0;
 346 $stepRecheck    = 0;
 347
 348 $_SESSION['step'][$steps['files'][$_REQUEST['step']]] = ($stop) ? 'failed' : 'success';
 349 unset($_SESSION['current_db_version']);
 350 unset($_SESSION['target_db_version']);