3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.6 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2014 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2014
35 class CRM_Upgrade_Form
extends CRM_Core_Form
{
36 const QUEUE_NAME
= 'CRM_Upgrade';
39 * Minimum size of MySQL's thread_stack option
41 * @see install/index.php MINIMUM_THREAD_STACK
43 const MINIMUM_THREAD_STACK
= 192;
48 * Upgrade for multilingual
53 public $multilingual = FALSE;
56 * Locales available for multilingual upgrade
64 * Number to string mapper
69 static $_numberMap = array(
83 * Constructor for the basic form page
85 * We should not use QuickForm directly. This class provides a lot
86 * of default convenient functions, rules and buttons
88 * @param object $state State associated with this form
89 * @param \const|\enum $action The mode the form is operating in (None/Create/View/Update/Delete)
90 * @param string $method The type of http method used (GET/POST)
91 * @param string $name The name of the form if different from class name
93 * @return \CRM_Core_Form
97 * @param null|object $state
98 * @param const|enum|int $action
99 * @param string $method
100 * @param null|string $name
102 function __construct($state = NULL,
103 $action = CRM_Core_Action
::NONE
,
107 $this->_config
= CRM_Core_Config
::singleton();
109 $domain = new CRM_Core_DAO_Domain();
112 $this->multilingual
= (bool) $domain->locales
;
113 $this->locales
= explode(CRM_Core_DAO
::VALUE_SEPARATOR
, $domain->locales
);
115 $smarty = CRM_Core_Smarty
::singleton();
116 $smarty->compile_dir
= $this->_config
->templateCompileDir
;
117 $smarty->assign('multilingual', $this->multilingual
);
118 $smarty->assign('locales', $this->locales
);
120 // we didn't call CRM_Core_BAO_ConfigSetting::retrieve(), so we need to set $dbLocale by hand
121 if ($this->multilingual
) {
123 $dbLocale = "_{$this->_config->lcMessages}";
126 parent
::__construct($state, $action, $method, $name);
134 public static function &incrementalPhpObject($version) {
135 static $incrementalPhpObject = array();
137 $versionParts = explode('.', $version);
138 $versionName = self
::$_numberMap[$versionParts[0]] . self
::$_numberMap[$versionParts[1]];
140 if (!array_key_exists($versionName, $incrementalPhpObject)) {
141 $className = "CRM_Upgrade_Incremental_php_{$versionName}";
142 $incrementalPhpObject[$versionName] = new $className();
144 return $incrementalPhpObject[$versionName];
153 public function checkVersionRelease($version, $release) {
154 $versionParts = explode('.', $version);
155 if ($versionParts[2] == $release) {
162 * @param $constraints
166 public function checkSQLConstraints(&$constraints) {
168 foreach ($constraints as $constraint) {
169 if ($this->checkSQLConstraint($constraint)) {
175 return array($pass, $fail);
184 public function checkSQLConstraint($constraint) {
185 // check constraint here
190 * @param string $fileName
191 * @param bool $isQueryString
193 public function source($fileName, $isQueryString = FALSE) {
195 CRM_Utils_File
::sourceSQLFile($this->_config
->dsn
,
196 $fileName, NULL, $isQueryString
200 public function preProcess() {
201 CRM_Utils_System
::setTitle($this->getTitle());
202 if (!$this->verifyPreDBState($errorMessage)) {
203 if (!isset($errorMessage)) {
204 $errorMessage = 'pre-condition failed for current upgrade step';
206 CRM_Core_Error
::fatal($errorMessage);
208 $this->assign('recentlyViewed', FALSE);
211 public function buildQuickForm() {
212 $this->addDefaultButtons($this->getButtonTitle(),
220 * Getter function for title. Should be over-ridden by derived class
228 public function getTitle() {
229 return ts('Title not Set');
235 public function getFieldsetTitle() {
242 public function getButtonTitle() {
243 return ts('Continue');
247 * Use the form name to create the tpl file name
255 public function getTemplateFileName() {
256 $this->assign('title',
257 $this->getFieldsetTitle()
259 $this->assign('message',
260 $this->getTemplateMessage()
262 return 'CRM/Upgrade/Base.tpl';
265 public function postProcess() {
268 if (!$this->verifyPostDBState($errorMessage)) {
269 if (!isset($errorMessage)) {
270 $errorMessage = 'post-condition failed for current upgrade step';
272 CRM_Core_Error
::fatal($errorMessage);
281 public function runQuery($query) {
282 return CRM_Core_DAO
::executeQuery($query,
283 CRM_Core_DAO
::$_nullArray
292 public function setVersion($version) {
293 $this->logVersion($version);
296 UPDATE civicrm_domain
297 SET version = '$version'
299 return $this->runQuery($query);
307 public function logVersion($newVersion) {
309 $oldVersion = CRM_Core_BAO_Domain
::version();
311 $session = CRM_Core_Session
::singleton();
313 'entity_table' => 'civicrm_domain',
315 'data' => "upgrade:{$oldVersion}->{$newVersion}",
316 // lets skip 'modified_id' for now, as it causes FK issues And
317 // is not very important for now.
318 'modified_date' => date('YmdHis'),
320 CRM_Core_BAO_Log
::add($logParams);
332 public function checkVersion($version) {
333 $domainID = CRM_Core_DAO
::getFieldValue('CRM_Core_DAO_Domain',
337 return $domainID ?
TRUE : FALSE;
344 public function getRevisionSequence() {
346 $sqlDir = implode(DIRECTORY_SEPARATOR
,
347 array(dirname(__FILE__
), 'Incremental', 'sql')
349 $sqlFiles = scandir($sqlDir);
351 $sqlFilePattern = '/^((\d{1,2}\.\d{1,2})\.(\d{1,2}\.)?(\d{1,2}|\w{4,7}))\.(my)?sql(\.tpl)?$/i';
352 foreach ($sqlFiles as $file) {
353 if (preg_match($sqlFilePattern, $file, $matches)) {
354 if ($matches[2] == '4.0') {
355 CRM_Core_Error
::fatal(ts("4.0.x upgrade files shouldn't exist. Contact Lobo to discuss this. This is related to the issue CRM-7731."));
357 if (!in_array($matches[1], $revList)) {
358 $revList[] = $matches[1];
365 '2.1.0', '2.2.beta2', '2.2.beta1', '2.2.alpha1', */
367 /* '2.2.alpha3', '2.2.0', '2.2.2', '2.1.alpha1', '2.1.3'); */
370 usort($revList, 'version_compare');
380 public static function getRevisionPart($rev, $index = 1) {
381 $revPattern = '/^((\d{1,2})\.\d{1,2})\.(\d{1,2}|\w{4,7})?$/i';
382 preg_match($revPattern, $rev, $matches);
384 return array_key_exists($index, $matches) ?
$matches[$index] : NULL;
393 public function processLocales($tplFile, $rev) {
394 $smarty = CRM_Core_Smarty
::singleton();
395 $smarty->assign('domainID', CRM_Core_Config
::domainID());
397 $this->source($smarty->fetch($tplFile), TRUE);
399 if ($this->multilingual
) {
400 CRM_Core_I18n_Schema
::rebuildMultilingualSchema($this->locales
, $rev);
402 return $this->multilingual
;
408 public function setSchemaStructureTables($rev) {
409 if ($this->multilingual
) {
410 CRM_Core_I18n_Schema
::schemaStructureTables($rev, TRUE);
419 public function processSQL($rev) {
420 $sqlFile = implode(DIRECTORY_SEPARATOR
,
422 dirname(__FILE__
), 'Incremental',
423 'sql', $rev . '.mysql',
426 $tplFile = "$sqlFile.tpl";
428 if (file_exists($tplFile)) {
429 $this->processLocales($tplFile, $rev);
432 if (!file_exists($sqlFile)) {
433 CRM_Core_Error
::fatal("sqlfile - $rev.mysql not found.");
435 $this->source($sqlFile);
440 * Determine the start and end version of the upgrade process
442 * @return array(0=>$currentVer, 1=>$latestVer)
444 public function getUpgradeVersions() {
445 $latestVer = CRM_Utils_System
::version();
446 $currentVer = CRM_Core_BAO_Domain
::version(true);
448 CRM_Core_Error
::fatal(ts('Version information missing in civicrm database.'));
450 elseif (stripos($currentVer, 'upgrade')) {
451 CRM_Core_Error
::fatal(ts('Database check failed - the database looks to have been partially upgraded. You may want to reload the database with the backup and try the upgrade process again.'));
454 CRM_Core_Error
::fatal(ts('Version information missing in civicrm codebase.'));
457 // hack to make past ver compatible /w new incremental upgrade process
460 '2.2' => '2.2.alpha1',
461 '2.2.alph' => '2.2.alpha3',
462 // since 3.1.1 had domain.version set as 3.1.0
465 if (isset($convertVer[$currentVer])) {
466 $currentVer = $convertVer[$currentVer];
469 return array($currentVer, $latestVer);
473 * Determine if $currentVer can be upgraded to $latestVer
478 * @return mixed, a string error message or boolean 'false' if OK
480 public function checkUpgradeableVersion($currentVer, $latestVer) {
482 // since version is suppose to be in valid format at this point, especially after conversion ($convertVer),
483 // lets do a pattern check -
484 if (!CRM_Utils_System
::isVersionFormatValid($currentVer)) {
485 $error = ts('Database is marked with invalid version format. You may want to investigate this before you proceed further.');
487 elseif (version_compare($currentVer, $latestVer) > 0) {
488 // DB version number is higher than codebase being upgraded to. This is unexpected condition-fatal error.
489 $error = ts('Your database is marked with an unexpected version number: %1. The automated upgrade to version %2 can not be run - and the %2 codebase may not be compatible with your database state. You will need to determine the correct version corresponding to your current database state. You may want to revert to the codebase you were using prior to beginning this upgrade until you resolve this problem.',
490 array(1 => $currentVer, 2 => $latestVer, 3 => $dbToolsLink)
493 elseif (version_compare($currentVer, $latestVer) == 0) {
494 $error = ts('Your database has already been upgraded to CiviCRM %1',
495 array(1 => $latestVer)
499 $phpVersion = phpversion();
500 $minPhpVersion = '5.3.3';
501 if (version_compare($phpVersion, $minPhpVersion) < 0) {
502 $error = ts('CiviCRM %3 requires PHP version %1 (or newer), but the current system uses %2 ',
510 // check for mysql trigger privileges
511 if (!CRM_Core_DAO
::checkTriggerViewPermission(FALSE, TRUE)) {
512 $error = ts('CiviCRM %1 requires MySQL trigger privileges.',
513 array(1 => $latestVer));
516 if (CRM_Core_DAO
::getGlobalSetting('thread_stack', 0) < (1024*self
::MINIMUM_THREAD_STACK
)) {
517 $error = ts('CiviCRM %1 requires MySQL thread stack >= %2k', array(
519 2 => self
::MINIMUM_THREAD_STACK
527 * Determine if $currentver already matches $latestVer
532 * @return mixed, a string error message or boolean 'false' if OK
534 public function checkCurrentVersion($currentVer, $latestVer) {
537 // since version is suppose to be in valid format at this point, especially after conversion ($convertVer),
538 // lets do a pattern check -
539 if (!CRM_Utils_System
::isVersionFormatValid($currentVer)) {
540 $error = ts('Database is marked with invalid version format. You may want to investigate this before you proceed further.');
542 elseif (version_compare($currentVer, $latestVer) != 0) {
543 $error = ts('Your database is not configured for version %1',
544 array(1 => $latestVer)
551 * Fill the queue with upgrade tasks
553 * @param $currentVer string, the original revision
554 * @param $latestVer string, the target (final) revision
555 * @param $postUpgradeMessageFile string, path of a modifiable file which lists the post-upgrade messages
559 public static function buildQueue($currentVer, $latestVer, $postUpgradeMessageFile) {
560 $upgrade = new CRM_Upgrade_Form();
562 // hack to make 4.0.x (D7,J1.6) codebase go through 3.4.x (d6, J1.5) upgrade files,
563 // since schema wise they are same
564 if (CRM_Upgrade_Form
::getRevisionPart($currentVer) == '4.0') {
565 $currentVer = str_replace('4.0.', '3.4.', $currentVer);
568 // Ensure that queue can be created
569 if (!CRM_Queue_BAO_QueueItem
::findCreateTable()) {
570 CRM_Core_Error
::fatal(ts('Failed to find or create queueing table'));
572 $queue = CRM_Queue_Service
::singleton()->create(array(
573 'name' => self
::QUEUE_NAME
,
578 $revisions = $upgrade->getRevisionSequence();
579 foreach ($revisions as $rev) {
580 // proceed only if $currentVer < $rev
581 if (version_compare($currentVer, $rev) < 0) {
582 $beginTask = new CRM_Queue_Task(
584 array('CRM_Upgrade_Form', 'doIncrementalUpgradeStart'),
587 "Begin Upgrade to $rev"
589 $queue->createItem($beginTask);
591 $task = new CRM_Queue_Task(
593 array('CRM_Upgrade_Form', 'doIncrementalUpgradeStep'),
595 array($rev, $currentVer, $latestVer, $postUpgradeMessageFile),
598 $queue->createItem($task);
600 $task = new CRM_Queue_Task(
602 array('CRM_Upgrade_Form', 'doIncrementalUpgradeFinish'),
604 array($rev, $currentVer, $latestVer, $postUpgradeMessageFile),
605 "Finish Upgrade DB to $rev"
607 $queue->createItem($task);
615 * Perform an incremental version update
617 * @param CRM_Queue_TaskContext $ctx
618 * @param $rev string, the target (intermediate) revision e.g '3.2.alpha1'
622 public static function doIncrementalUpgradeStart(CRM_Queue_TaskContext
$ctx, $rev) {
623 $upgrade = new CRM_Upgrade_Form();
625 // as soon as we start doing anything we append ".upgrade" to version.
626 // this also helps detect any partial upgrade issues
627 $upgrade->setVersion($rev . '.upgrade');
633 * Perform an incremental version update
635 * @param CRM_Queue_TaskContext $ctx
636 * @param $rev string, the target (intermediate) revision e.g '3.2.alpha1'
637 * @param $originalVer string, the original revision
638 * @param $latestVer string, the target (final) revision
639 * @param $postUpgradeMessageFile string, path of a modifiable file which lists the post-upgrade messages
643 public static function doIncrementalUpgradeStep(CRM_Queue_TaskContext
$ctx, $rev, $originalVer, $latestVer, $postUpgradeMessageFile) {
644 $upgrade = new CRM_Upgrade_Form();
646 $phpFunctionName = 'upgrade_' . str_replace('.', '_', $rev);
648 $versionObject = $upgrade->incrementalPhpObject($rev);
650 // pre-db check for major release.
651 if ($upgrade->checkVersionRelease($rev, 'alpha1')) {
652 if (!(is_callable(array(
653 $versionObject, 'verifyPreDBstate')))) {
654 CRM_Core_Error
::fatal("verifyPreDBstate method was not found for $rev");
658 if (!($versionObject->verifyPreDBstate($error))) {
659 if (!isset($error)) {
660 $error = "post-condition failed for current upgrade for $rev";
662 CRM_Core_Error
::fatal($error);
667 $upgrade->setSchemaStructureTables($rev);
669 if (is_callable(array(
670 $versionObject, $phpFunctionName))) {
671 $versionObject->$phpFunctionName($rev, $originalVer, $latestVer);
674 $upgrade->processSQL($rev);
677 // set post-upgrade-message if any
678 if (is_callable(array(
679 $versionObject, 'setPostUpgradeMessage'))) {
680 $postUpgradeMessage = file_get_contents($postUpgradeMessageFile);
681 $versionObject->setPostUpgradeMessage($postUpgradeMessage, $rev);
682 file_put_contents($postUpgradeMessageFile, $postUpgradeMessage);
684 $postUpgradeMessage = file_get_contents($postUpgradeMessageFile);
685 CRM_Upgrade_Incremental_Legacy
::setPostUpgradeMessage($postUpgradeMessage, $rev);
686 file_put_contents($postUpgradeMessageFile, $postUpgradeMessage);
693 * Perform an incremental version update
695 * @param CRM_Queue_TaskContext $ctx
696 * @param $rev string, the target (intermediate) revision e.g '3.2.alpha1'
697 * @param $currentVer string, the original revision
698 * @param $latestVer string, the target (final) revision
699 * @param $postUpgradeMessageFile string, path of a modifiable file which lists the post-upgrade messages
703 public static function doIncrementalUpgradeFinish(CRM_Queue_TaskContext
$ctx, $rev, $currentVer, $latestVer, $postUpgradeMessageFile) {
704 $upgrade = new CRM_Upgrade_Form();
705 $upgrade->setVersion($rev);
706 CRM_Utils_System
::flushCache();
708 $config = CRM_Core_Config
::singleton();
709 $config->userSystem
->flush();
713 public static function doFinish() {
714 $upgrade = new CRM_Upgrade_Form();
715 list($ignore, $latestVer) = $upgrade->getUpgradeVersions();
716 // Seems extraneous in context, but we'll preserve old behavior
717 $upgrade->setVersion($latestVer);
719 // lets rebuild the config array in case we've made a few changes in the
721 // this also helps us always store the latest version of civi in the DB
723 CRM_Core_BAO_ConfigSetting
::add($params);
725 // CRM-12804 comment-51411 : add any missing settings
726 // at the end of upgrade
727 CRM_Core_BAO_Setting
::updateSettingsFromMetaData();
729 // cleanup caches CRM-8739
730 $config = CRM_Core_Config
::singleton();
731 $config->cleanupCaches(1);
733 // Rebuild all triggers and re-enable logging if needed
734 $logging = new CRM_Logging_Schema();
735 $logging->fixSchemaDifferences();
739 * Compute any messages which should be displayed before upgrade
740 * by calling the 'setPreUpgradeMessage' on each incremental upgrade
743 * @param $preUpgradeMessage string, alterable
747 public function setPreUpgradeMessage(&$preUpgradeMessage, $currentVer, $latestVer) {
748 CRM_Upgrade_Incremental_Legacy
::setPreUpgradeMessage($preUpgradeMessage, $currentVer, $latestVer);
750 // Scan through all php files and see if any file is interested in setting pre-upgrade-message
751 // based on $currentVer, $latestVer.
752 // Please note, at this point upgrade hasn't started executing queries.
753 $revisions = $this->getRevisionSequence();
754 foreach ($revisions as $rev) {
755 if (version_compare($currentVer, $rev) < 0 &&
756 version_compare($rev, '3.2.alpha1') > 0
758 $versionObject = $this->incrementalPhpObject($rev);
759 if (is_callable(array(
760 $versionObject, 'setPreUpgradeMessage'))) {
761 $versionObject->setPreUpgradeMessage($preUpgradeMessage, $rev, $currentVer);