Bug 10001 - bugzilla crashes when selecting "my plans"
Summary: bugzilla crashes when selecting "my plans"
Status: RESOLVED FIXED
Alias: None
Product: Bugzilla
Classification: Infrastructure
Component: bugzilla (show other bugs)
Version: unspecified
Hardware: x86 Multiple
: Medium+ normal
Target Milestone: Future
Assignee: Michael Halstead
QA Contact:
URL:
Whiteboard:
Depends on:
Blocks:
 
Reported: 2016-07-22 11:46 UTC by Maxin B. John
Modified: 2016-12-05 20:13 UTC (History)
3 users (show)

See Also:
OS type for building Yocto: ---
Type of Regression: ---
Verified:
Documentation change: Don't know


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Maxin B. John 2016-07-22 11:46:30 UTC
Getting this error while selecting "my plans" report option:

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



Software error:

DBD::mysql::db selectcol_arrayref failed: Column 'plan_id' in where clause is ambiguous [for Statement "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 > 0 AND test_plan_permissions.userid = 1427 AND test_plans.isactive = 1 AND 1 = 1"] at /loader/0x2e9f180/Bugzilla/Extension/Testopia/Table.pm line 118
	Bugzilla::Extension::Testopia::Table::init('Bugzilla::Extension::Testopia::Table=HASH(0x3c704e0)', 'plan', 'tr_list_plans.cgi', 'Bugzilla::CGI=HASH(0xc5bfc8)', undef, 'SELECT DISTINCT test_plans.plan_id FROM test_plans  INNER JOI...') called at /loader/0x2e9f180/Bugzilla/Extension/Testopia/Table.pm line 88
	Bugzilla::Extension::Testopia::Table::new('Bugzilla::Extension::Testopia::Table', 'plan', 'tr_list_plans.cgi', 'Bugzilla::CGI=HASH(0xc5bfc8)', undef, 'SELECT DISTINCT test_plans.plan_id FROM test_plans  INNER JOI...') 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.
Comment 1 Michael Halstead 2016-12-05 20:13:24 UTC
Database upgrades appear to have resolved this error. Please re-open if you still encounter it.