<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://bugzilla.yoctoproject.org/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.6"
          urlbase="https://bugzilla.yoctoproject.org/"
          
          maintainer="it-coreprojects-helpdesk@linuxfoundation.org"
>

    <bug>
          <bug_id>10001</bug_id>
          
          <creation_ts>2016-07-22 11:46:30 +0000</creation_ts>
          <short_desc>bugzilla crashes when selecting &quot;my plans&quot;</short_desc>
          <delta_ts>2016-12-05 20:13:24 +0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>5</classification_id>
          <classification>Infrastructure</classification>
          <product>Bugzilla</product>
          <component>bugzilla</component>
          <version>unspecified</version>
          <rep_platform>x86</rep_platform>
          <op_sys>Multiple</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>Medium+</priority>
          <bug_severity>normal</bug_severity>
          <target_milestone>Future</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Maxin B. John">maxin.john</reporter>
          <assigned_to name="Michael Halstead">mhalstead</assigned_to>
          <cc>infras.bug.watcher</cc>
    
    <cc>Infras.watcher</cc>
    
    <cc>sgw</cc>
          
          
          <cf_os>---</cf_os>
          <cf_regression_type>---</cf_regression_type>
          
          <cf_docchange>Don&apos;t know</cf_docchange>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>64337</commentid>
    <comment_count>0</comment_count>
    <who name="Maxin B. John">maxin.john</who>
    <bug_when>2016-07-22 11:46:30 +0000</bug_when>
    <thetext>Getting this error while selecting &quot;my plans&quot; report option:

https://bugzilla.yoctoproject.org/tr_list_plans.cgi?current_tab=plan&amp;report_type=myplans



Software error:

DBD::mysql::db selectcol_arrayref failed: Column &apos;plan_id&apos; in where clause is ambiguous [for Statement &quot;SELECT DISTINCT test_plans.plan_id FROM test_plans  INNER JOIN test_plan_permissions ON (test_plans.plan_id = test_plan_permissions.plan_id) WHERE plan_id in (1,5,8,9,18,25,26,28,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,78,84,85,86,87,89,90,91,92,93,95,97,101,102,103,104,105,106,107,108,110,113,114,115,116,117,118,119,120,123,125,127,128,129,130,131,132,133,134,135,138,139,140,141,142,143,144,145,146,183) AND test_plan_permissions.permissions &gt; 0 AND test_plan_permissions.userid = 1427 AND test_plans.isactive = 1 AND 1 = 1&quot;] at /loader/0x2e9f180/Bugzilla/Extension/Testopia/Table.pm line 118
	Bugzilla::Extension::Testopia::Table::init(&apos;Bugzilla::Extension::Testopia::Table=HASH(0x3c704e0)&apos;, &apos;plan&apos;, &apos;tr_list_plans.cgi&apos;, &apos;Bugzilla::CGI=HASH(0xc5bfc8)&apos;, undef, &apos;SELECT DISTINCT test_plans.plan_id FROM test_plans  INNER JOI...&apos;) called at /loader/0x2e9f180/Bugzilla/Extension/Testopia/Table.pm line 88
	Bugzilla::Extension::Testopia::Table::new(&apos;Bugzilla::Extension::Testopia::Table&apos;, &apos;plan&apos;, &apos;tr_list_plans.cgi&apos;, &apos;Bugzilla::CGI=HASH(0xc5bfc8)&apos;, undef, &apos;SELECT DISTINCT test_plans.plan_id FROM test_plans  INNER JOI...&apos;) called at /var/www/bugzilla/tr_list_plans.cgi line 89

For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>68847</commentid>
    <comment_count>1</comment_count>
    <who name="Michael Halstead">mhalstead</who>
    <bug_when>2016-12-05 20:13:24 +0000</bug_when>
    <thetext>Database upgrades appear to have resolved this error. Please re-open if you still encounter it.</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>