Answers.Body: <p>Found it! This bug is fixed in <a href="https://issues.civicrm.org/jira/browse/CRM-16333" rel="nofollow" title="CRM-16333">CRM-16333</a>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T16:56:15.380Z
Answers.LastActivityDate: 2015-05-15T16:56:15.380Z
Answers.UserDisplayName: universalhandle
Answers.Body: <p>When you updated from (what version to what version?) were there database changes/updates included, and are you sure those ran successfully?
    From the stack trace and error message it sounds like a query isn't picking up the rows for the report (field 'id' may be event.id, most all civicrm tables have this field as internal identifier). The error seems like it is thrown in Civicrm/api/api.php, method civicrm_api3 and you're trying to run the report Event Participants List. Hopefully you backed up your database before doing the upgrade as is suggested.  Have you tried clearing cache?  The reports are compiled and cached, so you might try that first, it is not harmful and may help.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-28T08:46:22.890Z
Answers.Text: I tried to repeat the upgrade process and now the error is: " check db, the db is partialy upgraded.
Answers.UserDisplayName: Andrea Beducci
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-29T16:49:40.450Z
Answers.Text: Maybe you should read this page:http://wiki.civicrm.org/confluence/display/CRMDOC/Database+Troubleshooting+Tools
Answers.UserDisplayName: Lesley Evensen
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-29T16:50:44.407Z
Answers.Text: Did you restore your database (from before the upgrade) before running upgrade the 2nd time?
Answers.UserDisplayName: Lesley Evensen
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-26T03:18:03.657Z
Answers.LastActivityDate: 2015-04-26T03:18:03.657Z
Answers.UserDisplayName: Lesley Evensen
Answers.Body: <p>This appears to be the bug described in <a href="https://issues.civicrm.org/jira/browse/CRM-16477" rel="nofollow">CRM-16477</a>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T13:59:19.537Z
Answers.Text: Actually, Jon, I've already applied the patch for CRM-16477, and these appear to be different, because the problem I reported in CRM-16477 is fixed, but I can also reproduce this bug. The bugs appear to both be rooted in a problem with the value that the event selector widget provides/expect and the value that CiviCRM itself provides/expects.
Answers.UserDisplayName: universalhandle
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T14:02:02.653Z
Answers.Text: Furthermore, the problem Andrea is describing only occurs if no event is selected. If you choose an event, the search or report behaves as expected.
Answers.UserDisplayName: universalhandle
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-09T05:33:35.360Z
Answers.LastActivityDate: 2015-05-09T05:33:35.360Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>I use wordpress+civicrm and all worked well since the last upgrade. Now the event report always gives the same error: '' is not a valid option for field id. On the bottom the bugs report.</p>
  
  <p>Thanks</p>
  
  <pre><code>CiviCRM_API3_Exception: "'' is not a valid option for field id"
  
  #0 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form/Renderer.php(219): civicrm_api3("event", "getlist", (Array:1))
  #1 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form/Renderer.php(184): CRM_Core_Form_Renderer::preProcessEntityRef(Object(HTML_QuickForm_text))
  #2 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form/Renderer.php(103): CRM_Core_Form_Renderer::updateAttributes(Object(HTML_QuickForm_text), FALSE, NULL)
  #3 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Renderer/Array.php(221): CRM_Core_Form_Renderer-&gt;_elementToArray(Object(HTML_QuickForm_text), FALSE, NULL)
  #4 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/element.php(415): HTML_QuickForm_Renderer_Array-&gt;renderElement(Object(HTML_QuickForm_text), FALSE, NULL)
  #5 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm.php(1703): HTML_QuickForm_element-&gt;accept(Object(CRM_Core_Form_Renderer), FALSE, NULL)
  #6 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(685): HTML_QuickForm-&gt;accept(Object(CRM_Core_Form_Renderer))
  #7 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(116): CRM_Core_Form-&gt;toSmarty()
  #8 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(101): CRM_Core_QuickForm_Action_Display-&gt;renderForm(Object(CRM_Report_Form_Event_ParticipantListing))
  #9 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display-&gt;perform(Object(CRM_Report_Form_Event_ParticipantListing), "display")
  #10 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller-&gt;handle(Object(CRM_Report_Form_Event_ParticipantListing), "display")
  #11 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(83): HTML_QuickForm_Page-&gt;handle("display")
  #12 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit-&gt;perform(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
  #13 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller-&gt;handle(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
  #14 /wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page-&gt;handle("submit")
  #15 /wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(115): CRM_Core_Controller-&gt;run()
  #16 /wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Report.php(76): CRM_Utils_Wrapper-&gt;run("CRM_Report_Form_Event_ParticipantListing", NULL, NULL)
  #17 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Report_Page_Report-&gt;run((Array:4), NULL)
  #18 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:14))
  #19 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
  #20 /wp-content/plugins/civicrm/civicrm.php(1133): CRM_Core_Invoke::invoke((Array:4))
  #21 [internal function](): CiviCRM_For_WordPress-&gt;invoke("")
  #22 /wp-includes/plugin.php(496): call_user_func_array((Array:2), (Array:1))
  #23 /wp-admin/admin.php(226): do_action("toplevel_page_CiviCRM")
  #24 {main}
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-04-26T19:35:14.487Z
Comments.Text: Hi, Could you try on the demo site with the same report and check if it works or not?
Comments.UserDisplayName: Xavier
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-04-28T08:42:08.387Z
Comments.Text: Hi, i tried your solution but the wordpress civicrm demo doesn't use the last upgraded version 4.6.2. On the demo all is ok.
Comments.UserDisplayName: Andrea Beducci
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-05T07:53:29.313Z
Comments.Text: I had reinstalled civicrm with a new db. Now the reports appears correctly, but when I try to change something this error appears-'' is not a valid option for field id again.- I'm using worpdress 4.2.1 and civicrm 4.6.2. This is very annoying.
Comments.UserDisplayName: Andrea Beducci
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-05-15T14:12:29.637Z
Comments.Text: This problem appears to be fixed in master. The demo sites are now running the unreleased 4.6.3, and the problem cannot be reproduced there.
Comments.UserDisplayName: universalhandle
Tags: <civievent>
Title: When running event reports, receive Error: '' is not a valid option for field id
ThreadText: # When running event reports, receive Error: '' is not a valid option for field id
  
  (Asked by: username_0 on 2015-04-24)
  
  I use wordpress+civicrm and all worked well since the last upgrade. Now the event report always gives the same error: '' is not a valid option for field id. On the bottom the bugs report.
  Thanks
  CiviCRM_API3_Exception: "'' is not a valid option for field id"
  
  #0 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form/Renderer.php(219): civicrm_api3("event", "getlist", (Array:1))
  #1 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form/Renderer.php(184): CRM_Core_Form_Renderer::preProcessEntityRef(Object(HTML_QuickForm_text))
  #2 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form/Renderer.php(103): CRM_Core_Form_Renderer::updateAttributes(Object(HTML_QuickForm_text), FALSE, NULL)
  #3 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Renderer/Array.php(221): CRM_Core_Form_Renderer->_elementToArray(Object(HTML_QuickForm_text), FALSE, NULL)
  #4 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/element.php(415): HTML_QuickForm_Renderer_Array->renderElement(Object(HTML_QuickForm_text), FALSE, NULL)
  #5 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm.php(1703): HTML_QuickForm_element->accept(Object(CRM_Core_Form_Renderer), FALSE, NULL)
  #6 /wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(685): HTML_QuickForm->accept(Object(CRM_Core_Form_Renderer))
  #7 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(116): CRM_Core_Form->toSmarty()
  #8 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(101): CRM_Core_QuickForm_Action_Display->renderForm(Object(CRM_Report_Form_Event_ParticipantListing))
  #9 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Report_Form_Event_ParticipantListing), "display")
  #10 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Event_ParticipantListing), "display")
  #11 /wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(83): HTML_QuickForm_Page->handle("display")
  #12 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
  #13 /wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Event_ParticipantListing), "submit")
  #14 /wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(353): HTML_QuickForm_Page->handle("submit")
  #15 /wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(115): CRM_Core_Controller->run()
  #16 /wp-content/plugins/civicrm/civicrm/CRM/Report/Page/Report.php(76): CRM_Utils_Wrapper->run("CRM_Report_Form_Event_ParticipantListing", NULL, NULL)
  #17 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(312): CRM_Report_Page_Report->run((Array:4), NULL)
  #18 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:14))
  #19 /wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:4))
  #20 /wp-content/plugins/civicrm/civicrm.php(1133): CRM_Core_Invoke::invoke((Array:4))
  #21 [internal function](): CiviCRM_For_WordPress->invoke("")
  #22 /wp-includes/plugin.php(496): call_user_func_array((Array:2), (Array:1))
  #23 /wp-admin/admin.php(226): do_action("toplevel_page_CiviCRM")
  #24 {main}
  
  **Tags:** civievent
  
  > **Comments:**
  > **username_1**: Hi, Could you try on the demo site with the same report and check if it works or not?  
  > **username_0**: Hi, i tried your solution but the wordpress civicrm demo doesn't use the last upgraded version 4.6.2. On the demo all is ok.  
  > **username_0**: I had reinstalled civicrm with a new db. Now the reports appears correctly, but when I try to change something this error appears-'' is not a valid option for field id again.- I'm using worpdress 4.2.1 and civicrm 4.6.2. This is very annoying.  
  > **username_2**: This problem appears to be fixed in master. The demo sites are now running the unreleased 4.6.3, and the problem cannot be reproduced there.  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_2 on 2015-05-15. Score: 3
  
  Found it! This bug is fixed in [CRM-16333](https://issues.civicrm.org/jira/browse/CRM-16333 "CRM-16333").
  
  
  ---
  
  ### Answer by username_3 on 2015-04-26. Score: 2
  
  When you updated from (what version to what version?) were there database changes/updates included, and are you sure those ran successfully?
  From the stack trace and error message it sounds like a query isn't picking up the rows for the report (field 'id' may be event.id, most all civicrm tables have this field as internal identifier). The error seems like it is thrown in Civicrm/api/api.php, method civicrm\_api3 and you're trying to run the report Event Participants List. Hopefully you backed up your database before doing the upgrade as is suggested. Have you tried clearing cache? The reports are compiled and cached, so you might try that first, it is not harmful and may help.
  
  > **Comments:**
  > **username_0**: I tried to repeat the upgrade process and now the error is: " check db, the db is partialy upgraded.  
  > **username_3**: Maybe you should read this page:http://wiki.civicrm.org/confluence/display/CRMDOC/Database+Troubleshooting+Tools  
  > **username_3**: Did you restore your database (from before the upgrade) before running upgrade the 2nd time?  
  
  ---
  
  ### Answer by username_4 on 2015-05-09. Score: 0
  
  This appears to be the bug described in [CRM-16477](https://issues.civicrm.org/jira/browse/CRM-16477).
  
  > **Comments:**
  > **username_2**: Actually, Jon, I've already applied the patch for CRM-16477, and these appear to be different, because the problem I reported in CRM-16477 is fixed, but I can also reproduce this bug. The bugs appear to both be rooted in a problem with the value that the event selector widget provides/expect and the value that CiviCRM itself provides/expects.  
  > **username_2**: Furthermore, the problem Andrea is describing only occurs if no event is selected. If you choose an event, the search or report behaves as expected.  
  
  ---
  
  