bugSavane - Bugs: bug #2857, Reassigned item: support-tracker...

 
 
Show feedback again

You are not allowed to post comments on this tracker with your current authentification level.

bug #2857: Reassigned item: support-tracker has got wrong ids

Submitted by:  Sebastian Wieseler <kickino>
Submitted on:  Fri 09 Sep 2005 10:00:07 AM UTC  
 
Category: DatabaseStatus: Fixed
Severity: 3 - NormalPriority: C - Normal
Assigned to: Mathieu Roy <yeupou>Open/Closed: Closed
Release: 1.0.6Planned Release: 1.1
Reproducibility: NonePrivacy: Public

(Jump to the original submission Jump to the original submission)

Sat 10 Sep 2005 02:23:16 PM UTC, comment #6:

The fix is included in the latest public release, it will be also in the next public release, just in case someone was in the middle of the two.

Thanks for reporting the issue.

Mathieu Roy <yeupou>
Project AdministratorIn charge of this item.
Fri 09 Sep 2005 10:07:27 AM UTC, comment #5:

We're clearly not finished repackaging stuff:

I'll add the following in a fix script for the 1.1

UPDATE support_field_value SET value_id='9' WHERE group_id='100' AND value='In Progress';

Should we repackage 1.0.6 or consider it's just a non-blocker bug fixed in new version? I would say tend to go that way. It's not like if we were really maintaining older release and the bug is not so dramatic to justify a repackaging.

I added in fix in update script for 1.1 but also 1.0.7 and 1.0.8 that we'll have to repackage anyway due to bug #2850.

Mathieu Roy <yeupou>
Project AdministratorIn charge of this item.
Fri 09 Sep 2005 10:00:07 AM UTC, comment #4:

This item has been reassigned from the project Savane support tracker to your tracker.

The original report is still available at support #703

Following are the information included in the original report:

[field #0] Item ID: 703
[field #1] Group ID: 116
[field #2] Open/Closed: Open
[field #3] Severity: 3 - Normal
[field #4] Privacy: Public
[field #6] Category: Installation/Configuration
[field #7] Submitted by: kickino
[field #8] Assigned to: None
[field #9] Submitted on: ven 09.09.2005 à 09:29
[field #10] Summary: support-tracker has got wrong ids
[field #11] Original Submission: Hello guys.

Maybe you can tell me why Savane produces on the support tracker of the Savannah Administration (don t know where else, too) wrong ids in the Status field. :-/

[select name="resolution_id"]
[option value="100" selected="selected"]None[/option]
[option value="1"]Done[/option]
[option value="3"]Wont Do[/option]
[option value="6"]Works For Me[/option]
[option value="10"]Ready For Test[/option]
[option value="8"]In Progress[/option]
[option value="4"]Postponed[/option]
[option value="11"]Confirmed[/option]
[option value="8"]Need Info[/option]
[option value="7"]Duplicate[/option]
[option value="2"]Invalid[/option]
[/select]

You see? While selecting "In Progress" you ll get "Need Info" because its the last item which is defined with the SAME value-id (==8).

Is that a problem in the Savane project or in our configuration?
(if that is a known bug, then sorry :/)

Thanks for helping me out.
Sebastian Wieseler

[field #13] Item Group: None
[field #14] Status: None
[field #15] Component Version: None
[field #16] Platform Version: None
[field #17] Reproducibility: None
[field #18] Size (loc): None
[field #19] Fixed Release: None
[field #20] Planned Release: None
[field #21] Effort: 0.00
[field #25] Priority: 5 - Normal
[field #28] Percent Complete: 0%
[field #30] Release: None
[field #55] Custom Select Box #1: None
[field #56] Custom Select Box #2: None
[field #57] Custom Select Box #3: None
[field #58] Custom Select Box #4: None
[field #59] Custom Select Box #5: None
[field #60] Custom Select Box #6: None
[field #61] Custom Select Box #7: None
[field #62] Custom Select Box #8: None
[field #63] Custom Select Box #9: None
[field #64] Custom Select Box #10: None

Mathieu Roy <yeupou>
Project AdministratorIn charge of this item.
Fri 09 Sep 2005 09:59:58 AM UTC, comment #3:

[pcphsft15] /home/mroy/svdev/update > cat 1.0.6/new_status_default_values.sql | grep "In Progress"
INSERT INTO bugs_field_value (bug_fv_id,bug_field_id,group_id,value_id,value,description,order_id,status) VALUES (179,108,100,9,'In Progress','This item is currently being worked on',70,'A');
INSERT INTO patch_field_value (bug_fv_id,bug_field_id,group_id,value_id,value,description,order_id,status) VALUES (179,108,100,9,'In Progress','This item is currently being worked on',70,'A');
INSERT INTO support_field_value (bug_fv_id,bug_field_id,group_id,value_id,value,description,order_id,status) VALUES (179,108,100,8,'In Progress','This item is currently being worked on',70,'A');
INSERT INTO task_field_value (bug_fv_id,bug_field_id,group_id,value_id,value,description,order_id,status) VALUES (179,108,100,9,'In Progress','This item is currently being worked on',70,'A');

Hum, that's correct, I missed this third line. We'll we really need to repackage that.

In the meantime, run

UPDATE support_field_value SET value_id='9' WHERE group_id='100' AND value='In Progress';

Mathieu Roy <yeupou>
Project AdministratorIn charge of this item.
Fri 09 Sep 2005 09:14:11 AM UTC, comment #2:

Nope:
~/savane/update$ grep -r "In Progress" .
[...]
./1.0.6/new_status_default_values.sql:INSERT INTO support_field_value (bug_fv_id,bug_field_id,group_id,value_id,value,description,order_id,status) VALUES (179,108,100,8,'In Progress','This item is currently being worked on',70,'A');

It's 8.

Sylvain Beucler <beuc>
Project Administrator
Fri 09 Sep 2005 07:41:11 AM UTC, comment #1:

Since when do you have this problem?

At Gna!, on fresh projects which have defaults values, I get a 9 as value for In Progress.

I can see in upgrade script that you should get a 9.

Maybe you should try to reset values for this field to the default (but then you may have senseless info in bug reports).

Mathieu Roy <yeupou>
Project AdministratorIn charge of this item.
Fri 09 Sep 2005 10:00:07 AM UTC, original submission:

Hello guys.

Maybe you can tell me why Savane produces on the support tracker of the Savannah Administration (don't know where else, too) wrong ids in the 'Status' field. :-/

[select name="resolution_id"]
[option value="100" selected="selected"]None[/option]
[option value="1"]Done[/option]
[option value="3"]Wont Do[/option]
[option value="6"]Works For Me[/option]
[option value="10"]Ready For Test[/option]
[option value="8"]In Progress[/option]
[option value="4"]Postponed[/option]
[option value="11"]Confirmed[/option]
[option value="8"]Need Info[/option]
[option value="7"]Duplicate[/option]
[option value="2"]Invalid[/option]
[/select]

You see? While selecting "In Progress" you'll get "Need Info" because its the last item which is defined with the SAME value-id (==8).

Is that a problem in the Savane project or in our configuration?
(if that is a known bug, then sorry :/)

Thanks for helping me out.
Sebastian Wieseler

Sebastian Wieseler <kickino>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by kickino (Submitted the item)
  • -unavailable- added by yeupou (Updated the item)
  • -unavailable- added by beuc (Posted a comment)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 9 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Sat 10 Sep 2005 02:23:16 PM UTCyeupouStatusConfirmed=>Fixed
      Assigned toNone=>yeupou
      Open/ClosedOpen=>Closed
      Planned Release1.0.6+1? / 1.1=>1.1
    Fri 09 Sep 2005 10:07:27 AM UTCyeupouCategoryNone=>Database
      StatusNone=>Confirmed
      Release=>1.0.6
      Planned Release=>1.0.6+1? / 1.1
    Fri 09 Sep 2005 10:00:07 AM UTCyeupouReassign itemFrom group Savane, support tracker=>To group Savane, bugs tracker
    Show feedback again

    Back to the top


    Powered by Savane 3.1-cleanup