https://bugzilla.novell.com/show_bug.cgi?id=691108 https://bugzilla.novell.com/show_bug.cgi?id=691108#c0 Summary: Testopia "My Plans" causes SQL error Classification: openSUSE Product: openSUSE.org Version: unspecified Platform: Other OS/Version: Other Status: NEW Severity: Major Priority: P5 - None Component: Bugzilla AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: suse-beta@cboltz.de QAContact: novbugzilla-bugs@forge.provo.novell.com Found By: --- Blocker: --- When I select "My Plans" in the Testopia dropdown, the resulting page https://bugzilla.novell.com/tr_list_plans.cgi?current_tab=plan&report_type=myplans only gives me an SQL error message: 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 (0) AND test_plan_permissions.permissions > 0 AND test_plan_permissions.userid = 9717 AND test_plans.isactive = 1 AND 1 = 1"] at extensions/testopia/lib/Testopia/Table.pm line 118 Testopia::Table::init('Testopia::Table=HASH(0x2e29320)', 'plan', 'tr_list_plans.cgi', 'Bugzilla::CGI=HASH(0x2a9df00)', 'undef', 'SELECT DISTINCT test_plans.plan_id FROM test_plans INNER JOI...') called at extensions/testopia/lib/Testopia/Table.pm line 88 Testopia::Table::new('Testopia::Table', 'plan', 'tr_list_plans.cgi', 'Bugzilla::CGI=HASH(0x2a9df00)', 'undef', 'SELECT DISTINCT test_plans.plan_id FROM test_plans INNER JOI...') called at /shared/bugzilla/docroot/tr_list_plans.cgi line 86 For help, please send mail to the webmaster (webmaster@novell.com), giving this error message and the time and date of the error. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.