Answers.Body: <p>That's odd that your <code>civicrm_report_instance</code> table is missing, and it suggests that maybe the upgrade got interrupted?  I'd personally rollback and re-upgrade to be safe.  If that's not an option, go into your <code>civicrm</code> directory, then into the <code>sql</code> directory.  The <code>civicrm.mysql</code> file contains all the SQL needed to generate a blank Civi database - you can find the <code>civicrm_report_instance</code> SQL specific to your version of Civi.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-04T22:47:55.307Z
Answers.LastActivityDate: 2016-02-04T22:47:55.307Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I get the following error when trying to create new reports or edit existing ones.</p>
  <blockquote>
  <p>DB Error: no such field</p>
  </blockquote>
  <blockquote>
  <p>Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in ***/wp-content/plugins/civicrm/civicrm/Civi/Core/Transaction/Manager.php on line 107</p>
  </blockquote>
  <p>I have double checked that we DID run the upgrade script.</p>
  <p>&quot;Your database has already been upgraded to CiviCRM 4.7.1&quot;
  I have run SELECT version FROM civicrm_domain on the database to verify this is the case.</p>
  <p>We are the most up to date Wordpress 4.4.2</p>
  <p>I had this error previously and realized it was an extension causing the problem. Disabled the extension and all was right again. Now ALL extensions have been disabled and we are getting the error again.</p>
  <p>ETA - Debugging Log</p>
  <pre><code># 0 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
  # 1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
  # 2 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
  # 3 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(976): PEAR_Error-&gt;PEAR_Error(&quot;DB Error: no such field&quot;, -19, 16, (Array:2), &quot;INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...&quot;)
  # 4 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error-&gt;DB_Error(-19, 16, (Array:2), &quot;INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...&quot;)
  # 5 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR-&gt;raiseError(NULL, -19, NULL, NULL, &quot;INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...&quot;, &quot;DB_Error&quot;, TRUE)
  # 6 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(895): DB_common-&gt;raiseError(-19, NULL, NULL, NULL, &quot;1054 ** Unknown column 'created_id' in 'field list'&quot;)
  # 7 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql-&gt;mysqlRaiseError()
  # 8 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql-&gt;simpleQuery(&quot;INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...&quot;)
  # 9 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2435): DB_common-&gt;query(&quot;INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...&quot;)
  # 10 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1060): DB_DataObject-&gt;_query(&quot;INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...&quot;)
  # 11 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(467): DB_DataObject-&gt;insert()
  # 12 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/BAO/ReportInstance.php(109): CRM_Core_DAO-&gt;save()
  # 13 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/BAO/ReportInstance.php(184): CRM_Report_BAO_ReportInstance::add((Array:93))
  # 14 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Instance.php(361): CRM_Report_BAO_ReportInstance::create((Array:93))
  # 15 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form.php(2608): CRM_Report_Form_Instance::postProcess(Object(CRM_Report_Form_Member_Detail))
  # 16 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Member/Detail.php(339): CRM_Report_Form-&gt;beginPostProcess()
  # 17 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(423): CRM_Report_Form_Member_Detail-&gt;postProcess()
  # 18 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(74): CRM_Core_Form-&gt;mainProcess()
  # 19 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit-&gt;perform(Object(CRM_Report_Form_Member_Detail), &quot;submit&quot;)
  # 20 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller-&gt;handle(Object(CRM_Report_Form_Member_Detail), &quot;submit&quot;)
  # 21 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page-&gt;handle(&quot;submit&quot;)
  # 22 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller-&gt;run()
  # 23 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Report.php(72): CRM_Utils_Wrapper-&gt;run(&quot;CRM_Report_Form_Member_Detail&quot;, NULL, NULL)
  # 24 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Report_Page_Report-&gt;run((Array:4), NULL)
  # 25 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:14))
  # 26 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
  # 27 /***/public_html/wp-content/plugins/civicrm/civicrm.php(1214): CRM_Core_Invoke::invoke((Array:4))
  # 28 [internal function](): CiviCRM_For_WordPress-&gt;invoke(&quot;&quot;)
  # 29 /***/public_html/wp-includes/plugin.php(525): call_user_func_array((Array:2), (Array:1))
  # 30 /***/public_html/wp-admin/admin.php(236): do_action(&quot;toplevel_page_CiviCRM&quot;)
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-04T06:27:00.347Z
Comments.Text: To solve your problem, we'll need to see the expanded debugging information.  In CiviCRM, please go to **Administer menu > System Settings > Debugging and Error Handling**, select "Yes" to both "Enable Debugging" and "Display Backtrace", and press "Save".  Repeat the problem that caused your error, and you'll see much a much more detailed error.  Please update this question with the expanded error and backtrace - and don't forget to disable debugging/backtrace when you're done!
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-04T16:30:58.127Z
Comments.Text: I don't know what happened to my last comment, but I did update with the error log.
Comments.UserDisplayName: Tiffany Carra
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-02-04T16:47:15.920Z
Comments.Text: So it appears that civicrm_report_instance is not a table in my database. JOY. Anybody have the SQL to create that table?
Comments.UserDisplayName: Tiffany Carra
Tags: <wordpress><civireport><error>
Title: DB Error: no such field Fatal error: Uncaught CRM_Core_Exception: When Creating Reports
ThreadText: # DB Error: no such field Fatal error: Uncaught CRM_Core_Exception: When Creating Reports
  
  (Asked by: username_0 on 2016-02-04)
  
  I get the following error when trying to create new reports or edit existing ones.
  
  DB Error: no such field
  
  
  Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in ***/wp-content/plugins/civicrm/civicrm/Civi/Core/Transaction/Manager.php on line 107
  
  I have double checked that we DID run the upgrade script.
  "Your database has already been upgraded to CiviCRM 4.7.1"
  I have run SELECT version FROM civicrm_domain on the database to verify this is the case.
  We are the most up to date Wordpress 4.4.2
  I had this error previously and realized it was an extension causing the problem. Disabled the extension and all was right again. Now ALL extensions have been disabled and we are getting the error again.
  ETA - Debugging Log
  # 0 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(182): CRM_Core_Error::backtrace()
  # 1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
  # 2 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
  # 3 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(976): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
  # 4 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
  # 5 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...", "DB_Error", TRUE)
  # 6 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'created_id' in 'field list'")
  # 7 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
  # 8 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
  # 9 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2435): DB_common->query("INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
  # 10 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1060): DB_DataObject->_query("INSERT INTO civicrm_report_instance (domain_id , title , report_id , descript...")
  # 11 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(467): DB_DataObject->insert()
  # 12 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/BAO/ReportInstance.php(109): CRM_Core_DAO->save()
  # 13 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/BAO/ReportInstance.php(184): CRM_Report_BAO_ReportInstance::add((Array:93))
  # 14 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Instance.php(361): CRM_Report_BAO_ReportInstance::create((Array:93))
  # 15 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form.php(2608): CRM_Report_Form_Instance::postProcess(Object(CRM_Report_Form_Member_Detail))
  # 16 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Form/Member/Detail.php(339): CRM_Report_Form->beginPostProcess()
  # 17 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(423): CRM_Report_Form_Member_Detail->postProcess()
  # 18 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(74): CRM_Core_Form->mainProcess()
  # 19 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Report_Form_Member_Detail), "submit")
  # 20 /***/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Member_Detail), "submit")
  # 21 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("submit")
  # 22 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(113): CRM_Core_Controller->run()
  # 23 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Report.php(72): CRM_Utils_Wrapper->run("CRM_Report_Form_Member_Detail", NULL, NULL)
  # 24 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Report_Page_Report->run((Array:4), NULL)
  # 25 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:14))
  # 26 /***/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
  # 27 /***/public_html/wp-content/plugins/civicrm/civicrm.php(1214): CRM_Core_Invoke::invoke((Array:4))
  # 28 [internal function](): CiviCRM_For_WordPress->invoke("")
  # 29 /***/public_html/wp-includes/plugin.php(525): call_user_func_array((Array:2), (Array:1))
  # 30 /***/public_html/wp-admin/admin.php(236): do_action("toplevel_page_CiviCRM")
  
  **Tags:** wordpress, civireport, error
  
  > **Comments:**
  > **username_1**: To solve your problem, we'll need to see the expanded debugging information.  In CiviCRM, please go to **Administer menu > System Settings > Debugging and Error Handling**, select "Yes" to both "Enable Debugging" and "Display Backtrace", and press "Save".  Repeat the problem that caused your error, and you'll see much a much more detailed error.  Please update this question with the expanded error and backtrace - and don't forget to disable debugging/backtrace when you're done!  
  > **username_0**: I don't know what happened to my last comment, but I did update with the error log.  
  > **username_0**: So it appears that civicrm_report_instance is not a table in my database. JOY. Anybody have the SQL to create that table?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-02-04. Score: 1
  
  That's odd that your `civicrm_report_instance` table is missing, and it suggests that maybe the upgrade got interrupted? I'd personally rollback and re-upgrade to be safe. If that's not an option, go into your `civicrm` directory, then into the `sql` directory. The `civicrm.mysql` file contains all the SQL needed to generate a blank Civi database - you can find the `civicrm_report_instance` SQL specific to your version of Civi.
  
  
  ---
  
  