Answers.Body: <p>Can you check apache error and CiviCRM log? If you have database access can you paste the result of below query</p>
  
  <pre><code>SELECT id, version FROM civicrm_domain;
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-29T12:33:20.117Z
Answers.Text: Here's the result of the query: 4.7.17.upgrade
Answers.UserDisplayName: Tee Strong
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-29T12:40:42.580Z
Answers.Text: I also added a picture of the error message I received after running the upgrade script overnight.
Answers.UserDisplayName: Tee Strong
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-29T12:42:34.353Z
Answers.Text: Anything in CiviCRM logs?
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-29T12:49:02.040Z
Answers.Text: Does civicrm_financial_trxn table have millions of records?
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-29T13:11:59.623Z
Answers.Text: I'm godaddy, where do I find the logs?  The databases are small.
Answers.UserDisplayName: Tee Strong
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-29T13:15:02.477Z
Answers.Text: Should be under media/civicrm/ConfigLogs/ with CiviCRM.xxxxxxxx.log.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-29T13:22:36.720Z
Answers.Text: Let us [continue this discussion in chat](http://chat.stackexchange.com/rooms/70935/discussion-between-tee-strong-and-pradeep-nayak).
Answers.UserDisplayName: Tee Strong
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-29T19:32:04.707Z
Answers.Text: Its seems like there is problem while trying to upgrade from 4.7.16 to 4.7.28, when localization is turned on. Since the new code base i.e 4.7.28 on upgrade screen tries to load profile links through JS call which causes DB: Error with no field found for 'cancel_button_text' which is added in 4.7.25. I would recommend to do incremental upgrade from 4.7.16 to 4.7.24 and then from 4.7.24 to 4.7.28. Let me know how it goes?
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-29T04:24:44.367Z
Answers.LastActivityDate: 2017-12-29T04:24:44.367Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I am trying to upgrade my Joomla civiCRM database from 4.7.16 to 4.7.28. The component upgraded fine but when I try to upgrade the database after following all of the preparation steps, it hangs and makes not progress. I've looked at all of the similar problems, but nothing helps me with my error. I have two questions, how do I know what's going on? And my second question is what is going on and how to I get it to complete the upgrade?</p>
  
  <p><a href="https://i.sstatic.net/QeNLW.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/QeNLW.png" alt="enter image description here"></a></p>
  
Tags: <joomla><upgrade><database>
Title: CiviCRM Database Upgrade from 4.7.16 to 4.7.28 is hanging
ThreadText: # CiviCRM Database Upgrade from 4.7.16 to 4.7.28 is hanging
  
  (Asked by: username_0 on 2017-12-29)
  
  I am trying to upgrade my Joomla civiCRM database from 4.7.16 to 4.7.28. The component upgraded fine but when I try to upgrade the database after following all of the preparation steps, it hangs and makes not progress. I've looked at all of the similar problems, but nothing helps me with my error. I have two questions, how do I know what's going on? And my second question is what is going on and how to I get it to complete the upgrade?
  
  [![enter image description here](https://i.sstatic.net/QeNLW.png)](https://i.sstatic.net/QeNLW.png)
  
  **Tags:** joomla, upgrade, database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-12-29. Score: 0
  
  Can you check apache error and CiviCRM log? If you have database access can you paste the result of below query
  SELECT id, version FROM civicrm_domain;
  
  > **Comments:**
  > **username_0**: Here's the result of the query: 4.7.17.upgrade  
  > **username_0**: I also added a picture of the error message I received after running the upgrade script overnight.  
  > **username_1**: Anything in CiviCRM logs?  
  > **username_1**: Does civicrm_financial_trxn table have millions of records?  
  > **username_0**: I'm godaddy, where do I find the logs?  The databases are small.  
  > **username_1**: Should be under media/civicrm/ConfigLogs/ with CiviCRM.xxxxxxxx.log.  
  > **username_0**: Let us [continue this discussion in chat](http://chat.stackexchange.com/rooms/70935/discussion-between-tee-strong-and-pradeep-nayak).  
  > **username_1**: Its seems like there is problem while trying to upgrade from 4.7.16 to 4.7.28, when localization is turned on. Since the new code base i.e 4.7.28 on upgrade screen tries to load profile links through JS call which causes DB: Error with no field found for 'cancel_button_text' which is added in 4.7.25. I would recommend to do incremental upgrade from 4.7.16 to 4.7.24 and then from 4.7.24 to 4.7.28. Let me know how it goes?  
  
  ---
  
  