release_notes.txt

Bug管理系统

I plan to handle incoming file attachments in the next release, too.

Also:

* Comments on existing bugs coming in via btnet_console/service now
include the subject as part of the comment text.

* Fixed handling of nvarchar custom fields.

-----------------------------------------------------------------------
Version 1.9.7  03/06/2005
-----------------------------------------------------------------------

I've changed the VARCHAR types in setup.sql to NVARCHAR types, in order
to handle Unicode.    I've also changed all the logic that builds SQL
statements to build SQL using Unicode literals.   For examle, where it
used to say:  Update foo set bar = '$1', it now says set bar = N'$1'.

I might have may missed a couple places, so if you encounter a bug,
post it at sourceforge and I'll try to post an updated release as soon
as possible, within days.

Unicode strings use two bytes per char, so in setup.sql I've doubled
the length of strings.   In a few places I've more than doubled, where
I thought the lengths were too short anyway.

I've also changed the columns bc_comment and a couple others from
varchar to ntext, so that there isn't a size limitation.

The ALTER TABLE script below worked for me and I hope it works for you.

Also in this release: Changed dbutil to use database connections with 
very brief lifespans, rather than keeping them open for the entire 
sever-side page generation (Thanks Jason C.).

- - - - - - - - - - - - - - - - - 


alter table users alter column us_username nvarchar(40) 
alter table users alter column us_password nvarchar(64) 
alter table users alter column us_firstname nvarchar(60) 
alter table users alter column us_lastname nvarchar(60) 
alter table users alter column us_email nvarchar(120) 

alter table categories alter column ct_name nvarchar(80) 

alter table projects alter column pj_name varchar(30) 

alter table projects alter column pj_name nvarchar(80) 
alter table projects alter column pj_pop3_password nvarchar(20) 
alter table projects alter column pj_pop3_email_from nvarchar(120) 

alter table projects alter column pj_custom_dropdown_label1 nvarchar(80) 
alter table projects alter column pj_custom_dropdown_label2 nvarchar(80) 
alter table projects alter column pj_custom_dropdown_label3 nvarchar(80) 
alter table projects alter column pj_custom_dropdown_values1 nvarchar(2000) 
alter table projects alter column pj_custom_dropdown_values2 nvarchar(2000) 
alter table projects alter column pj_custom_dropdown_values3 nvarchar(2000) 

alter table bugs alter column bg_short_desc nvarchar(200) 

alter table bugs alter column bg_project_custom_dropdown_value1 nvarchar(120) 
alter table bugs alter column bg_project_custom_dropdown_value2 nvarchar(120) 
alter table bugs alter column bg_project_custom_dropdown_value3 nvarchar(120) 

alter table bug_comments alter column bc_comment ntext 
alter table bug_comments alter column bc_email_from nvarchar(800) 
alter table bug_comments alter column bc_email_to nvarchar(100) 

alter table bug_attachments alter column ba_file nvarchar(1000) 
alter table bug_attachments alter column ba_desc nvarchar(200) 
alter table bug_attachments alter column ba_content_type nvarchar(200) 

alter table user_defined_attribute alter column udf_name nvarchar(60) 

alter table statuses alter column st_name nvarchar(60) 
alter table statuses alter column st_sort_seq int
alter table statuses alter column st_style nvarchar(30) 

alter table priorities alter column pr_name nvarchar(60) 
alter table priorities alter column pr_sort_seq int
alter table priorities alter column pr_background_color nvarchar(14) 
alter table priorities alter column pr_style nvarchar(30) 

alter table queries alter column qu_desc nvarchar(200)
alter table queries alter column qu_sql ntext

alter table reports alter column rp_desc nvarchar(200) 
alter table reports alter column rp_sql ntext 


-----------------------------------------------------------------------
Version 1.9.6  02/06/2005
-----------------------------------------------------------------------

* Fixed problems with dates on search.aspx.  I hope.

* Added "UseFullNames" setting in Web.config.  Controls how user names
show up in dropdowns.

* Added pseudo variable $ME for use in reports.

* Bolding of selected menu items now controlled via style sheet.

* AllowCommentDeletionForNonAdmins now also allows editing of comments.

* You probably want to run this to allow for longer attachment
filenames:
alter table bug_attachments alter column ba_file varchar(256)

-----------------------------------------------------------------------
Version 1.9.5  10/09/2004
-----------------------------------------------------------------------

* Fixed crash in edit_status.aspx and edit_priority.aspx

* Revised logic for internationalizing dates.   See Web.config.  Thanks
to Martin Ricther.   I used your code verbatim.

* Fixed bug where adding a comment caused prior update history to not
be displayed.

* Added this line in send_email.aspx per discussion in Help forum 
"Mail trouble/question":
body_text = body_text.Replace("\n","\r\n");

* Added some validation for custom fields, for datetime, int, and 
decimal formats.

* You can now make a custom field required.  (Logic just looks at
whether the field is NULL or NOT NULL).


-----------------------------------------------------------------------
Version 1.9.4  9/20/2004
-----------------------------------------------------------------------

* Only one change since 1.9.3 - fixed an important bug.   Adding just a
comment to an existing bug didn't work.   To fix, I added the following
line to edit_bug.aspx after line 772:

|| comment.Value.Length > 0


-----------------------------------------------------------------------
Version 1.9.3  9/19/2004
-----------------------------------------------------------------------

* Fixed null/not null problems in setup.sql

* Fixed some places where "bug" should have been replaced by Web.config
setting SingularBugLabel.  Also, appropriately capitalizing the
lable.  Thanks Tom Sella - I used your code verbatim.

* No longer using hard-coded scheme for bug attachments content
type.   Instead, storing PostedFile.ContentType. Thanks "nickbeen".

* Now checking for changes before updating bg_last_updated_user,
bg_last_updated_date.

* search.aspx now allows search on bugs with no specified category,
status, priority, project, assigned-to.

* Added "LogoHtml" setting in Web.config.   That allows you to set
the logo and its link to whatever you want.

-----------------------------------------------------------------------
Migrating to 1.9.3
-----------------------------------------------------------------------

alter table bug_attachments add ba_content_type varchar(100) null

-----------------------------------------------------------------------
Version 1.9.2  9/03/2004
-----------------------------------------------------------------------

* Search "to" dates now go through then end of the "to" day, 
to the time 23:59:59

* Corrected instructions for migrating to 1.9.1 below.  Added update
statements.

* Fixed crash when merging bugs that also have subscriptions.

* The first column of bug queries used to be unconditionally
interpreted as a bgcolor for the "<td>" element.    That's still true as
long as the text start with an "#", as in "#ffaaaa".   However, if the
first column does not start with an "#", the first column is 
interpreted as a css style class.   For example, "<td class=yourclass".

You can also now enter a css style class for a status and/or a priorty.

I've changed the explanatory text on the edit_query.aspx to relect
this change.


* Added sort sequence to categories and user_defined_attributes. 
They now behave like statuses and priorities.   Also, sorts now look
at name too as a secondary sort field.


-----------------------------------------------------------------------
Migrating to 1.9.2
-----------------------------------------------------------------------

alter table user_defined_attribute add udf_sort_seq int not null default(0)
alter table categories add ct_sort_seq int not null default(0)
alter table priorities add pr_style varchar(10) not null default('')
alter table statuses add st_style varchar(10) not null default('')


-----------------------------------------------------------------------
Version 1.9.1  8/27/2004
-----------------------------------------------------------------------

* AppTitle setting in Web.config also affects the web page titles
(i.e, the <title> element).

* Adding an attachment creates an entry in bug change history

* Adding an attachment or sending an email triggers notifications

* Fixed bug whereby same user could subscribe twice to same bug.

* Fixed bug whereby bugs entered by email that triggered notifications
resulted in "Object reference not set to an instance of an object"
in util.cs.

* Used contributor jhetler's idea and code for imbedding a print of 
the bug in send_email.aspx when "include bug description" is checked.

* Used contributor ekalinin's idea about an option allowing users to 
send notifications to themselves.   See edit_user.aspx,
edit_self.aspx.

* Used contributor ekalinin's idea about an option allowing users to 
receive notifications only when status changes.   See edit_user.aspx,
edit_self.aspx.

* Added ability to edit SQL for reports with help from 
contributor regent10.

-----------------------------------------------------------------------
Migrating to 1.9.1
-----------------------------------------------------------------------

Corrected this file so that the alter table statement for 1.8.6 reads:
    alter table users add us_only_status_change_notifications int null default(0)

Use this SQL to drop the bogus field:
    alter table projects drop column add us_only_status_change_notifications

Also run this:
alter table users add us_send_notifications_to_self int null default(0)
update users set us_only_status_change_notifications = 0
update users set us_send_notifications_to_self = 0

-----------------------------------------------------------------------
Version 1.9.0  8/20/2004
-----------------------------------------------------------------------

Small changes:

* The pages no longer let you delete a project, user, category, 
priority, status or user_defined_attribute value if it is still being
referenced by a bug.

* Delete confirmation pages echo the name of the item being deleted
when they are prompting the user for confirmation.

* Replaced my edit_user_permissions2.aspx with one from Eugene Kalinin
per bug 1010967, List all users on "per user permissons".

* Fix to how links to interior pages are handled when user isn't logged
in.   Query string vars were getting truncated.

* Fix to how white space is handled when printing custom text fields.

-----------------------------------------------------------------------
Version 1.8.9  8/18/2004
-----------------------------------------------------------------------

Important bug fix again:

* The printed and emailed bugs were broken so that they were printing 
the id's rather than the descriptions of fields like status, category, 
etc.   Fixed that.

And less serious

* Custom textarea fields are now HTML encoded for display on
edit_bugs.aspx page and on for printing/emails.

I'd like to think that this version is pretty stable.

-----------------------------------------------------------------------
Version 1.8.8  8/16/2004
-----------------------------------------------------------------------

Bug fixes only, but important ones.

* In version 1.8.7, the alter script in this README.TXT was STILL wrong.
I corrected it again from bg_custom_project...  to bg_project_custom...

* Starting with version 1.8.5, the user dropdowns are filtered so that
a given user doesn't see other users with whom that user doesn't have
any projects in common.    In this release I have changed the queries
that implement the feature to fix a bug.   Also, the admin user is now
treated just like any other user.

-----------------------------------------------------------------------
Version 1.8.7  8/16/2004
-----------------------------------------------------------------------

The only change is a correct to the SQL "alter" statements below,
for migrating to 1.8.6.

I originally wrote bg_custom_project_dropdown1_value, etc.   
That's wrong.
It should be bg_custom_project_dropdown_value1

I corrected it below.


-----------------------------------------------------------------------
Version 1.8.6  8/14/2004
-----------------------------------------------------------------------

* Now supports custom dropdowns specific to a project.  For 
example you could set up project #1 to have a custom dropdown of
"Version" with values of "1.0", "2.0", but for project #2 it would have
the values of "3.1", "3.2".   Go to an existing project and edit it to
try out this feature.

This is a complicated feature to implement.  I probably made a mistake
or two.  Please help me by reporting any bugs you find and I'll try to
fix them ASAP and post a new version.   

I apologize in advance if this new feature causes you any inconvience.

-----------------------------------------------------------------------
Migrating to 1.8.6
-----------------------------------------------------------------------

alter table projects add pj_enable_custom_dropdown1 int null default(0)
alter table projects add pj_enable_custom_dropdown2 int null default(0)
alter table projects add pj_enable_custom_dropdown3 int null default(0)
alter table projects add pj_custom_dropdown_label1 varchar(30) null
alter table projects add pj_custom_dropdown_label2 varchar(30) null
alter table projects add pj_custom_dropdown_label3 varchar(30) null
alter table projects add pj_custom_dropdown_values1 varchar(1000) null
alter table projects add pj_custom_dropdown_values2 varchar(1000) null
alter table projects add pj_custom_dropdown_values3 varchar(1000) null

alter table bugs add bg_project_custom_dropdown_value1 varchar(40) null
alter table bugs add bg_project_custom_dropdown_value2 varchar(40) null
alter table bugs add bg_project_custom_dropdown_value3 varchar(40) null

alter table users add us_only_status_change_notifications int null default(0)

-----------------------------------------------------------------------
Version 1.8.5  8/12/2004
-----------------------------------------------------------------------

Bug fixes only.

* Fixed bug related to selecting item in "re-assign" dropdown on 
edit_bug.aspx.   This bug was introduced in version 1.8.4.

* Now preserving white space and line breaks in custom fields

* Now Handling double quotes in custom fields properly


-----------------------------------------------------------------------
Version 1.8.4  8/09/2004
-----------------------------------------------------------------------

* Added ability to delete file attachments.   Also added setting in
Web.config to turn the feature on and off:
<add key="AllowAttachmentDeletionForNonAdmins" value="0"/>

* added "id" column to the admin pages that list things, 
like categories.aspx.

* In search, show inactive users and projects in dropdowns too.

* In search, if admin user, show all uesrs and projects regardless of
permission.

* In dropdowns in edit_bug.aspx and search.aspx, only show users 
related to projects that user has permissions for.   To really see the