CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
Pages: [1]

Author Topic: Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7  (Read 1464 times)

RSethT

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.2.8
  • CMS version: Drupal
  • MySQL version: 5.5.29-0ubuntu0.12.04.2-log
  • PHP version: 5.3.14
Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
November 08, 2013, 12:27:53 pm
Trying to upgrade a QA site to CiviCRM 4.4.1.  When I navigate to /civicrm/upgrade?reset=1, I get a blank screen.  My HTTP logs show a 200 HTTP response.  There are no messages in /tmp/phperrors.log or in my HTTP error log.

I can navigate around CiviCRM without issue, but when looking at civicrm/admin?reset=1, I get a warning about the new codebase (4.4.1) advising me to visit the upgrade screen (the above problem).

Thoughts?

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
November 08, 2013, 12:44:51 pm
Make sure you have cleared your caches in both Drupal and CiviCRM, and deleted the contents of your templates_c directory, and see if that fixes things.
Graham Mitchell
http://mc3.coop

RSethT

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.2.8
  • CMS version: Drupal
  • MySQL version: 5.5.29-0ubuntu0.12.04.2-log
  • PHP version: 5.3.14
Re: Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
November 08, 2013, 01:02:16 pm
When clearing Drupal caches, I get the error: "Sorry but we are not able to provide this at the moment.  DB Error: no such field"

CiviCRM Reports "Success.  Cache has been cleared..."

/civicrm/upgrade?reset=1 is still giving a blank page.

RSethT

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.2.8
  • CMS version: Drupal
  • MySQL version: 5.5.29-0ubuntu0.12.04.2-log
  • PHP version: 5.3.14
Re: Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
November 08, 2013, 01:48:25 pm
When "snooping" on the TCP connection, the headers look like this:

GET /civicrm/upgrade?reset=1 HTTP/1.1
Host: www.example.com
Connection: keep-alive
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.101 Safari/537.36
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8
Cookie: SESS8af4b6d53a060a5ad87f006016415d2a=qpKFOCjRqhbZ6BWzvtnKzfAgrcmKUAtOl990myJ8W08; has_js=1

HTTP/1.1 200 OK
Date: Fri, 08 Nov 2013 21:43:19 GMT
Server: Apache/2.2.22 (Ubuntu)
X-Powered-By: PHP/5.3.10-1ubuntu3.7
Expires: Sun, 19 Nov 1978 05:00:00 GMT
Last-Modified: Fri, 08 Nov 2013 21:43:19 +0000
Cache-Control: no-cache, must-revalidate, post-check=0, pre-check=0
ETag: "1383946999"
Vary: Accept-Encoding
Content-Encoding: gzip
Content-Length: 20
Keep-Alive: timeout=5, max=100
Connection: Keep-Alive
Content-Type: text/html

connection closed by foreign host

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
November 08, 2013, 04:08:10 pm

can you look at the log message in your files/civicrm/ConfigAndLog directory? A late code change introduced a bug which suppresses all fatal error messages (but its recorded in the log) and hence u see the blank page

lobo




A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

RedneckBob

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: CiviCRM 4.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.61
  • PHP version: PHP 5.3.3
Re: Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
November 09, 2013, 03:02:48 pm
Just upgraded to 4.4.1 mysql and also had a blank "upgrade" page.  As Donald suggested I checked out the files/civicrm/ConfigAndLog file and found that I need to add additional permission in MySQL.  I'm giving that a try right now...

Nov 09 16:52:21  [info] Ignoring exception thrown by nullHandler: -26, DB Error: insufficient permissions

Nov 09 16:52:21  [info] $backTrace = #0 /var/www/html/drupal/sites/all/modules/civicrm/CRM/Core/Error.php(776): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::nullHandler(Object(DB_Error))
#2 /var/www/html/drupal/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/html/drupal/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: insufficient permissions", -26, 16, (Array:2), "CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EAC...")
#4 /var/www/html/drupal/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-26, 16, (Array:2), "CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EAC...")
#5 /var/www/html/drupal/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -26, NULL, NULL, "CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EAC...", "DB_Error", TRUE)
#6 /var/www/html/drupal/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-26, NULL, NULL, NULL, "1142 ** TRIGGER command denied to user 'civicrm'@'localhost' for table 'civic...")
#7 /var/www/html/drupal/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /var/www/html/drupal/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EAC...")
#9 /var/www/html/drupal/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EAC...")
#10 /var/www/html/drupal/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EAC...")
#11 /var/www/html/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(158): DB_DataObject->query("CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EAC...")
#12 /var/www/html/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(1478): CRM_Core_DAO->query("CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EAC...")
#13 /var/www/html/drupal/sites/all/modules/civicrm/CRM/Upgrade/Form.php(403): CRM_Core_DAO::checkTriggerViewPermission(FALSE, TRUE)
#14 /var/www/html/drupal/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(88): CRM_Upgrade_Form->checkUpgradeableVersion("4.2.2", "4.4.1")
#15 /var/www/html/drupal/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(64): CRM_Upgrade_Page_Upgrade->runIntro()
#16 /var/www/html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(323): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
#17 /var/www/html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#18 /var/www/html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#19 /var/www/html/drupal/sites/all/modules/civicrm/drupal/civicrm.module(437): CRM_Core_Invoke::invoke((Array:2))
#20 [internal function](): civicrm_invoke("upgrade")
#21 /var/www/html/drupal/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:1))
#22 /var/www/html/drupal/index.php(21): menu_execute_active_handler()
#23 {main}
   
       
Nov 09 16:52:21  [info] $Fatal Error Details = Array
(           
    [message] => CiviCRM 4.4.1 requires MySQL trigger privileges.
   
Code: [Select]
=>
)   
   

RedneckBob

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: CiviCRM 4.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.61
  • PHP version: PHP 5.3.3
Re: Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
November 09, 2013, 04:10:01 pm
Adding the TRIGGER privilege to the civicrm database worked.  I used phpMyAdmin by selecting Privileges then Edit Privileges on the civicrm user then checking the TRIGGER box. 

RedneckBob

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: CiviCRM 4.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.61
  • PHP version: PHP 5.3.3
Re: Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
November 09, 2013, 08:08:08 pm
Still had issues, so I applied this patch by hand:

-  https://github.com/civicrm/civicrm-core/commit/2141efbfd240ce7daa6a4bd68f61f585b5ec34cf#diff-0

More info here:

- http://issues.civicrm.org/jira/browse/CRM-13388?page=com.atlassian.jira.plugins.jira-bitbucket-connector-plugin:dvcs-commits-tabpanel

Eventually limped my way through the upgrade.

RSethT

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.2.8
  • CMS version: Drupal
  • MySQL version: 5.5.29-0ubuntu0.12.04.2-log
  • PHP version: 5.3.14
Re: Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7
November 11, 2013, 08:15:45 am
Thank you so much!  Adding the TRIGGER permission worked like a charm.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrading to 4.4.1 - broken /civicrm/upgrade on Drupal 7

This forum was archived on 2017-11-26.