Create New Test Run - fails on TestCaseRunStatus matching query does not exist.

[Niv Gal Waizer]

In Home >> ... >> 2: Test Design >> New Test Run
I click save and get this error.
Below is the mysql status.

Request Method: POST
Request URL: http://nivw-centos6-2/run/new/

Django Version: 1.5.5
Python Version: 2.6.6
Installed Applications:
('django.contrib.auth',
  'django.contrib.contenttypes',
  'django.contrib.sessions',
  'django.contrib.sites',
  'django.contrib.messages',
  'django.contrib.staticfiles',
  'django.contrib.admin',
  'django.contrib.admindocs',
  'django.contrib.comments',
  'kobo.django.xmlrpc',
  'tcms.apps.profiles',
  'tcms.core',
  'tcms.core.contrib.auth',
  'tcms.core.contrib.comments',
  'tcms.core.logs',
  'tcms.apps.management',
  'tcms.apps.testcases',
  'tcms.apps.testplans',
  'tcms.apps.testruns',
  'tcms.apps.testreviews',
  'tcms.core.lib.django-pagination.pagination',
  'tcms.integration.djqpid',
  'tcms.integration.apps.errata',
  'tcms.core.contrib.linkreference',
  'tcms.integration.apps.bugzilla')
Installed Middleware:
('django.middleware.common.CommonMiddleware',
  'django.contrib.sessions.middleware.SessionMiddleware',
  'tcms.core.middleware.CsrfDisableMiddleware',
  'django.middleware.csrf.CsrfViewMiddleware',
  'django.contrib.auth.middleware.AuthenticationMiddleware',
  'django.contrib.messages.middleware.MessageMiddleware',
 
'tcms.core.lib.django-pagination.pagination.middleware.PaginationMiddleware')


Traceback:
File "/usr/lib/python2.6/site-packages/django/core/handlers/base.py" in 
get_response
   115.                         response = callback(request, 
*callback_args, **callback_kwargs)
File 
"/usr/lib/python2.6/site-packages/django/contrib/auth/decorators.py" in 
_wrapped_view
   25.                 return view_func(request, *args, **kwargs)
File 
"/usr/lib/python2.6/site-packages/nitrate-3.8.6-py2.6.egg/tcms/apps/testruns/views.py"

in new
   141.                                     assignee=assignee_tester)
File 
"/usr/lib/python2.6/site-packages/nitrate-3.8.6-py2.6.egg/tcms/apps/testruns/models.py"

in add_case_run
   258.                 and TestCaseRunStatus.objects.get(id = 
case_run_status) \
File "/usr/lib/python2.6/site-packages/django/db/models/manager.py" in get
   143.         return self.get_query_set().get(*args, **kwargs)
File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in get
   404.                 self.model._meta.object_name)

Exception Type: DoesNotExist at /run/new/
Exception Value: TestCaseRunStatus matching query does not exist.

In mysql, I use nitrate database:
mysql> select * from test_case_run_status;
Empty set (0.00 sec)

[Niv Gal Waizer]

Issue solved by adding missing mysql data manually with django shell 
using the file Chenxiong Qi provided.

Fwd: Re: Create New Test Run - fails on TestCaseRunStatus matching query does not exist.

[Niv Gal Waizer]

Hi Chenxiong Qi,
The file you provided sets the test_case_status table:
mysql> select * from test_case_status;
+----------------+-------------+-------------+
| case_status_id | name        | description |
+----------------+-------------+-------------+
|              1 | PROPOSED    | NULL        |
|              2 | CONFIRMED   | NULL        |
|              3 | DISABLED    | NULL        |
|              4 | NEED_UPDATE | NULL        |
+----------------+-------------+-------------+
4 rows in set (0.00 sec)

Yet test_case_run_status is empty:
mysql> select * from test_case_run_status;
Empty set (0.00 sec)

kindly provide this json to load.
Regards,
Niv

[Chenxiong Qi]

----- Original Message -----
>  From: "Niv Gal Waizer" <nivw(a)infinidat.com&gt;
>  To: nitrate-devel(a)lists.fedorahosted.org
>  Sent: Monday, February 24, 2014 8:05:16 PM
>  Subject: Fwd: Re: Create New Test Run - fails on TestCaseRunStatus matching	query does
> not exist.
>  
>  Hi Chenxiong Qi,
>  The file you provided sets the test_case_status table:
>  mysql> select * from test_case_status;
>  +----------------+-------------+-------------+
>  | case_status_id | name        | description |
>  +----------------+-------------+-------------+
>  |              1 | PROPOSED    | NULL        |
>  |              2 | CONFIRMED   | NULL        |
>  |              3 | DISABLED    | NULL        |
>  |              4 | NEED_UPDATE | NULL        |
>  +----------------+-------------+-------------+
>  4 rows in set (0.00 sec)
>  
>  Yet test_case_run_status is empty:
>  mysql> select * from test_case_run_status;
>  Empty set (0.00 sec)
>  
>  kindly provide this json to load. 
Hi Niv,

Sorry for I didn't explain the purpose of the fixture data I sent to u. That four
status of TestCaseStatus belongs to core logic of test case management, but
TestCaseRunStatus not, that leave to user to define their own items to fit their specific
requirement.

Log in Nitrate with your superuser account, and go to Admin page to find "Test case
run statuss" to add your status.

Regards,
Chenxiong Qi

>  Regards,
>  Niv
>  _______________________________________________
>  nitrate-devel mailing list
>  nitrate-devel(a)lists.fedorahosted.org
>  https://lists.fedorahosted.org/mailman/listinfo/nitrate-devel
>