From 92fae7a27db8ecbfbd5d6c8235f2554efc8bde34 Mon Sep 17 00:00:00 2001 From: CiviCRM Date: Tue, 3 Jun 2014 15:37:43 +0530 Subject: [PATCH] 4.5 Upgrade fix --- CRM/Upgrade/Incremental/php/FourFour.php | 5 +---- 1 file changed, 1 insertion(+), 4 deletions(-) diff --git a/CRM/Upgrade/Incremental/php/FourFour.php b/CRM/Upgrade/Incremental/php/FourFour.php index 876f67b428..bcad6fcf03 100644 --- a/CRM/Upgrade/Incremental/php/FourFour.php +++ b/CRM/Upgrade/Incremental/php/FourFour.php @@ -336,7 +336,7 @@ ALTER TABLE civicrm_dashboard */ function upgrade_4_4_6($rev){ $sql = "SELECT count(*) AS count FROM INFORMATION_SCHEMA.STATISTICS where ". - "INDEX_NAME = 'index_image_url' AND TABLE_NAME = 'civicrm_contact';"; + "TABLE_SCHEMA = database() AND INDEX_NAME = 'index_image_url' AND TABLE_NAME = 'civicrm_contact';"; $dao = CRM_Core_DAO::executeQuery($sql); $dao->fetch(); if ($dao->count < 1) { @@ -360,9 +360,6 @@ ALTER TABLE civicrm_dashboard * @return bool */ static function upgradeImageUrls(CRM_Queue_TaskContext $ctx, $startId, $endId){ - $sql = "CREATE INDEX index_image_url ON civicrm_contact (image_url);"; - $dao = CRM_Core_DAO::executeQuery($sql); - $sql = " SELECT id, image_url FROM civicrm_contact -- 2.25.1