Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error for any project v.1.3.0 #4

Open
aceccarelli opened this issue Oct 10, 2013 · 3 comments
Open

Error for any project v.1.3.0 #4

aceccarelli opened this issue Oct 10, 2013 · 3 comments

Comments

@aceccarelli
Copy link

Hi.

After install the version 1.3.0 my plugin shows this error for any project.

Started GET "/redhomolog/projects/sisloc/impasse/test_case" for 192.168.16.161 at 2013-10-10 07:44:58 -0300
Processing by ImpasseTestCaseController#index as HTML
Parameters: {"project_id"=>"projeto"}
Rendered plugins/redmine_impasse/app/views/impasse_test_case/index.html.erb within layouts/base (28.8ms)
Completed 500 Internal Server Error in 40ms

ActionView::Template::Error (Mysql2::Error: Subquery returns more than 1 row: SELECT count(status) FROM impasse_executions WHERE test_plan_case_id IN (SELECT id FROM impasse_test_plan_cases WHERE test_plan_id IN(SELECT id FROM impasse_test_plans WHERE name = 'Plano de Qualidade Padrão' AND version_id = ((SELECT id FROM versions WHERE name = 'projeto'))))):
145: TotalOKFailedIn processNo run
146: <% plans[version].each do |test_plan| %>
147:
148: <% total, ok, fail, proc, undone = Impasse::TestPlan.get_statistics_for_plan(version.name,test_plan.name) %>
149: <%= link_to test_plan.name, :controller=>:impasse_test_plans, :action=>:show, :project_id=>@project, :id=>test_plan%><%= total%><%= ok%><%= fail%><%= proc%><%= undone%>
150:
151: <% end %>
app/helpers/application_helper.rb:1117:in `content_for'

@cforce
Copy link
Owner

cforce commented Oct 10, 2013

Did you use my develop branch?
Which redmine, rails, ruby version?
Please post results as file attachment from

SELECT * FROM impasse_executions WHERE test_plan_case_id IN (SELECT id FROM impasse_test_plan_cases WHERE test_plan_id IN(SELECT id FROM impasse_test_plans WHERE name = 'Plano de Qualidade Padrão' AND version_id = ((SELECT id FROM versions WHERE name = 'projeto')))))

@aceccarelli
Copy link
Author

Yes. Installed your version 1.3.0

Environment:
Redmine version 2.0.3.stable
Ruby version 1.9.3 (x86_64-linux)
Rails version 3.2.6
Environment production
Database adapter Mysql2

erro

@cforce
Copy link
Owner

cforce commented Oct 14, 2013

Please post results as csv file attachment from the sql query result on your database

SELECT * FROM impasse_executions WHERE test_plan_case_id IN (SELECT id FROM impasse_test_plan_cases WHERE test_plan_id IN(SELECT id FROM impasse_test_plans WHERE name = 'Plano de Qualidade Padrão' AND version_id = ((SELECT id FROM versions WHERE name = 'projeto')))))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants