helpSavane - Support: sr #703, support-tracker has got wrong ids

 
 
Show feedback again

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

sr #703: support-tracker has got wrong ids

Submitted by:  Sebastian Wieseler <kickino>
Submitted on:  Fri 09 Sep 2005 07:29:30 AM UTC  
 
Category: Installation/ConfigurationPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: NoneOpen/Closed: Closed
Release: 

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 Administrator
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 Administrator
Fri 09 Sep 2005 07:29:30 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 beuc (Posted a comment)
  • -unavailable- added by yeupou (Posted a comment)
  • -unavailable- added by kickino (Submitted the item)
  •  

    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):

     

     

    Follows 1 latest change.

    Date Changed By Updated Field Previous Value => Replaced By
    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