Answers.Body: <p>I may have found a solution elsewhere - which is ugly and requires editing the upgrade scripts. <a href="https://civicrm.stackexchange.com/questions/10644/database-error-when-upgrading-4-6-to-4-7-on-drupal-7">Database Error When Upgrading 4.6 to 4.7 on Drupal 7</a></p>
  <p>So it's not really a solution for me - but maybe it will be  a  solution for others, as once I got past that issue the 4.6.20 to 4.7.0alpha3 portion failed with the following. Have not found that many google matches for this error - but hopefully I can get past this next hurdle. Hopefully others won't also run into this issue.</p>
  <blockquote>
  <p>[Error: undefined]</p>
  <p>Exception: &quot;A fatal error was triggered: Could not find valid value
  for qrid&quot;</p>
  <h1>0 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Utils/Request.php(92):</h1>
  <p>CRM_Core_Error::fatal(&quot;Could not find valid value for qrid&quot;)</p>
  <h1>1 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(47):</h1>
  <p>CRM_Utils_Request::retrieve(&quot;qrid&quot;, &quot;String&quot;, NULL, TRUE, NULL,
  &quot;POST&quot;)</p>
  <h1>2 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(106):</h1>
  <p>CRM_Queue_Page_AJAX::{closure}()</p>
  <h1>3 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(54):</h1>
  <p>CRM_Queue_ErrorPolicy-&gt;call(Object(Closure))</p>
  <h1>4 internal function: CRM_Queue_Page_AJAX::runNext()</h1>
  <h1>5 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(278):</h1>
  <p>call_user_func((Array:2))</p>
  <h1>6 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(86):</h1>
  <p>CRM_Core_Invoke::runItem((Array:13))</p>
  <h1>7 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(54):</h1>
  <p>CRM_Core_Invoke::_invoke((Array:5))</p>
  <h1>8 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/drupal/civicrm.module(454):</h1>
  <p>CRM_Core_Invoke::invoke((Array:5))</p>
  <h1>9 internal function: civicrm_invoke(&quot;upgrade&quot;, &quot;queue&quot;, &quot;ajax&quot;, &quot;runNext&quot;)</h1>
  <h1>10 /home/kialis/zootownarts.org/drupal7/includes/menu.inc(527): call_user_func_array(&quot;civicrm_invoke&quot;, (Array:4))</h1>
  <h1>11 /home/kialis/zootownarts.org/drupal7/index.php(21): menu_execute_active_handler()</h1>
  <h1>12 {main}</h1>
  </blockquote>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-06T04:15:42.290Z
Answers.Text: Ok - I got past the qrid error message by reloading the install URL present when the error happens. The qrid is related to the Queue Runner, and not sure why it's getting interrupted, but just by going here again http://<yoursite>/civicrm/upgrade/queue/runner?reset=1&qrid=CRM_Upgrade it seems to get the job done. I had to do it a couple times to get to CiviCRM 4.7.10.
Answers.UserDisplayName: Harold Shinsato
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-21T22:10:57.810Z
Answers.Text: I attempted to load the URL you suggested here, hoping my upgrade would pick back up but I got the following: Queue runner must be configured before execution.
Answers.UserDisplayName: Christia
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-06T00:21:28.930Z
Answers.LastActivityDate: 2016-09-06T00:21:28.930Z
Answers.LastEditDate: 2020-06-17T09:00:50.810Z
Answers.UserDisplayName: Harold Shinsato
Body: <p>I'm upgrading a CiviCRM 4.6.20 install to 4.7.10. I'm on Drupal 7.50. I've tried the updgrade several times. My Drupal database updates are all executed. Before running the upgrade, the civicrm_action_schedule table has an INDEX with the name, FK_civicrm_action_schedule_mapping_id. But when I execute SQL to list all foreign key constraints, there are none. I don't know if this makes a difference, but the table is empty. I don't have any rows in civicrm_action_schedule.</p>
  
  <p>What could I be missing here? Thanks!</p>
  
  <p>[Error: Upgrade DB to 4.7.alpha1: SQL]
  Error Field Error Value
  Type    DB_Error
  Code    -4
  Message DB Error: not found
  Mode    16
  UserInfo    ALTER TABLE <code>civicrm_action_schedule</code> DROP FOREIGN KEY <code>FK_civicrm_action_schedule_mapping_id</code> [nativecode=1091 ** Can't DROP 'FK_civicrm_action_schedule_mapping_id'; check that column/key exists]
  DebugInfo   ALTER TABLE <code>civicrm_action_schedule</code> DROP FOREIGN KEY <code>FK_civicrm_action_schedule_mapping_id</code> [nativecode=1091 ** Can't DROP 'FK_civicrm_action_schedule_mapping_id'; check that column/key exists]</p>
  
  <p><a href="https://i.sstatic.net/nwh6t.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/nwh6t.jpg" alt="enter image description here"></a></p>
  
Tags: <drupal><4.7.10>
Title: Upgrade CiviCRM 4.6.20 to 4.7.10 on Drupal - db error
ThreadText: # Upgrade CiviCRM 4.6.20 to 4.7.10 on Drupal - db error
  
  (Asked by: username_0 on 2016-09-05)
  
  I'm upgrading a CiviCRM 4.6.20 install to 4.7.10. I'm on Drupal 7.50. I've tried the updgrade several times. My Drupal database updates are all executed. Before running the upgrade, the civicrm\_action\_schedule table has an INDEX with the name, FK\_civicrm\_action\_schedule\_mapping\_id. But when I execute SQL to list all foreign key constraints, there are none. I don't know if this makes a difference, but the table is empty. I don't have any rows in civicrm\_action\_schedule.
  
  What could I be missing here? Thanks!
  
  [Error: Upgrade DB to 4.7.alpha1: SQL]
  Error Field Error Value
  Type DB\_Error
  Code -4
  Message DB Error: not found
  Mode 16
  UserInfo ALTER TABLE `civicrm_action_schedule` DROP FOREIGN KEY `FK_civicrm_action_schedule_mapping_id` [nativecode=1091 \*\* Can't DROP 'FK\_civicrm\_action\_schedule\_mapping\_id'; check that column/key exists]
  DebugInfo ALTER TABLE `civicrm_action_schedule` DROP FOREIGN KEY `FK_civicrm_action_schedule_mapping_id` [nativecode=1091 \*\* Can't DROP 'FK\_civicrm\_action\_schedule\_mapping\_id'; check that column/key exists]
  
  [![enter image description here](https://i.sstatic.net/nwh6t.jpg)](https://i.sstatic.net/nwh6t.jpg)
  
  **Tags:** drupal, 4.7.10
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2016-09-06. Score: 1
  
  I may have found a solution elsewhere - which is ugly and requires editing the upgrade scripts. [Database Error When Upgrading 4.6 to 4.7 on Drupal 7](https://civicrm.stackexchange.com/questions/10644/database-error-when-upgrading-4-6-to-4-7-on-drupal-7)
  
  So it's not really a solution for me - but maybe it will be a solution for others, as once I got past that issue the 4.6.20 to 4.7.0alpha3 portion failed with the following. Have not found that many google matches for this error - but hopefully I can get past this next hurdle. Hopefully others won't also run into this issue.
  
  > [Error: undefined]
  >
  > Exception: "A fatal error was triggered: Could not find valid value
  > for qrid"
  >
  > # 0 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Utils/Request.php(92):
  >
  > CRM\_Core\_Error::fatal("Could not find valid value for qrid")
  >
  > # 1 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(47):
  >
  > CRM\_Utils\_Request::retrieve("qrid", "String", NULL, TRUE, NULL,
  > "POST")
  >
  > # 2 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(106):
  >
  > CRM\_Queue\_Page\_AJAX::{closure}()
  >
  > # 3 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(54):
  >
  > CRM\_Queue\_ErrorPolicy->call(Object(Closure))
  >
  > # 4 internal function: CRM\_Queue\_Page\_AJAX::runNext()
  >
  > # 5 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(278):
  >
  > call\_user\_func((Array:2))
  >
  > # 6 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(86):
  >
  > CRM\_Core\_Invoke::runItem((Array:13))
  >
  > # 7 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(54):
  >
  > CRM\_Core\_Invoke::\_invoke((Array:5))
  >
  > # 8 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/drupal/civicrm.module(454):
  >
  > CRM\_Core\_Invoke::invoke((Array:5))
  >
  > # 9 internal function: civicrm\_invoke("upgrade", "queue", "ajax", "runNext")
  >
  > # 10 /home/kialis/zootownarts.org/drupal7/includes/menu.inc(527): call\_user\_func\_array("civicrm\_invoke", (Array:4))
  >
  > # 11 /home/kialis/zootownarts.org/drupal7/index.php(21): menu\_execute\_active\_handler()
  >
  > # 12 {main}
  
  > **Comments:**
  > **username_0**: Ok - I got past the qrid error message by reloading the install URL present when the error happens. The qrid is related to the Queue Runner, and not sure why it's getting interrupted, but just by going here again http://<yoursite>/civicrm/upgrade/queue/runner?reset=1&qrid=CRM_Upgrade it seems to get the job done. I had to do it a couple times to get to CiviCRM 4.7.10.  
  > **username_1**: I attempted to load the URL you suggested here, hoping my upgrade would pick back up but I got the following: Queue runner must be configured before execution.  
  
  ---
  
  