release_notes.txt

Bug管理系统

effect of this, DefaultPermissionLevel in Web.Config should be set to
0.

* Version 1.8.2's base and custom css thing broke the the emails.  Now
the emails use both the base and custom style sheets too.

* Merging bugs now creates a comment belonging to the "into" bug, 
recording the act of merging itself. 

-----------------------------------------------------------------------
Version 1.8.3  7/31/2004
-----------------------------------------------------------------------

* Version 1.8.2 broke the hyperlinks feature.  This release fixes it.

* What broke the hyperlinks was the way I was handling trying to
preserve white space in the comments.   I changed it again.  
Line breaks are converted to "<br>".
Tabs are converted to "&nbsp;&nbsp;&nbsp;&nbsp;".
One space is left alone.
Two spaces are converted to " &nbsp;"

-----------------------------------------------------------------------
Version 1.8.2  7/29/2004
-----------------------------------------------------------------------

* Fixed problem with comment formatting that resulted in the text not
word-wrapping.

* Added the option to show the initially entered comment on top, like
Sourceforge does, when the general order of comments is most recent
first, i.e., "desc" in Web.config

* Made it easier to customize css.   Put your customizations in
btnet_custom.css instead of btnet.css and then as I change btnet.css, 
your overrides in btnet_custom.css will still work.    Thanks to
Michael Wilson for this idea.

* Maybe you like a more neutral word like "issue", "ticket", or "item"
rather than "bug"?  Added settings to web config that allow you to get 
rid of most occurrences of the word "bug" in the user interface for 
non-admin users:

	<add key="AppTitle" value="Customer Support"/>
	<add key="SingularBugLabel" value="Item"/>
	<add key="PluralBugLabel" value="Items"/>
	<!-- customize marker for creating hyperlinks in bug comments -->
	<add key="BugLinkMarkerx" value="itemid#"/>
	
* Made btnet_service.exe and btnet_console.exe a little more robust
when encoutering problems communicating with web server.   Also, they
don't choke now when encountering an unusual "multipart" type.

-----------------------------------------------------------------------
Version 1.8.1  6/26/2004
-----------------------------------------------------------------------

* Added feature allowing one bug to be merged into another.  

Added a new setting in Web.config, "AllowBugMergingForNonAdmins", that 
controls whether non-admins have access to this feature.

* Formatting of bug comment text is now preserved.

* When deleting a bug, attachments are now deleted too.   You might 
need to adjust permission on the file upload folder.

* Added new page "view subscribers" so you can see who is subscribed 
to a bug.

* Added Web.config option "EncryptStoredPasswords".   See note on 
migrating below.    Btnet now checks for both the encrypted and 
unencrypted versions of the password, so there's no need to convert 
existing data.   The unencrypted passwords will still work.

If you want to convert, the only way I have provided is
to go reset the passwords one by one using the web pages.    I didn't
provide a tool to conver them all at once.

-----------------------------------------------------------------------
Migrating to 1.8.1
-----------------------------------------------------------------------

You only need to run this if you set EncryptPasswords to "1"

alter table users alter column us_password varchar(32) not null
	
-----------------------------------------------------------------------
Version 1.8.0  6/18/2004
-----------------------------------------------------------------------

* Emails are now sent by default as just one email with many 
recipients.  Added new Web.config setting, "SendJustOneEMail".   If you
liked things better the old way, change this setting to "0".    Thanks 
for the code, Victor.

* Fixed bug where custom fields weren't saved on an add, just an 
update.

* On the login page, now filling in the username with previously used
username.

-----------------------------------------------------------------------
Version 1.7.9  6/12/2004
-----------------------------------------------------------------------

* Added "Reporter" permission.    Reporters can add bugs, update
comments, upload attachments, but can't change status, assignment
etc after adding bug.   Works best when you set user's "forced project".

* Added user's "forced project".   If set, user is limited to adding 
bugs to the specified project.

* Added "PrintHistory" setting to Web.config.  Controls whether 
change history is included in print of bugs.    Note however, the
same logic is used to print the email notifications.

* Added page for changing per user per project permissiong coming from
the project in addition to the one that already exists coming from the
user.

* Added links from search page to "print list" and "print detail"

* Added custom columns to search screen results

* Changed how the edit_bugs.aspx looks for users with View Only
permissions.  

* Lots of little bug fixes, including newly recompiled btnet_console.exe
and btnet_service.exe.   They no longer crash on multiplart/mixed emails.


-----------------------------------------------------------------------
Migrating to 1.7.9
-----------------------------------------------------------------------

alter table users add us_forced_project int null

-----------------------------------------------------------------------
Version 1.7.8 4/17/2004
-----------------------------------------------------------------------

* Made bugs per page a user setting rather than a global setting.
Web.config's "BugsPerPage" is obsolete
You have to run this sql:
alter table users add us_bugs_per_page int null

* Added ability to print the details of multiple bugs at once

* Added links for printing bugs on bugs.aspx page.   If you sort the 
list by clicking on the column headings, you can then print the list
in that sort order.

* Uses TextArea controls instead of Input controls for large custom
fields.  Thanks to "wulfman2u" for submitting the code for this change
in RFE #935798


-----------------------------------------------------------------------
Version 1.7.7 3/30/2004
-----------------------------------------------------------------------

* Now recording changes to custom columns in bug's audit trail

* Added "logged in as" feedback in upper right

* Added new link on admin page to new custom fields pages.   These 
pages help you generate the sql to add custom fields to bugs table.


-----------------------------------------------------------------------
Version 1.7.6 3/03/2004
-----------------------------------------------------------------------

* Custom fields now appear on print_bug.aspx and email notifications.

* When adding new bug, project dropdown defaults to last project
you worked with, not merely last project you added a bug to.

* Bugs page now remembers the last query you selected in dropdown

Bug Fixes:

* Added "Reported On" to print_bug.aspx

* Updating a bug with custom date field preserves the null.

* Date picker (calendar.js) is now works with European date formats.

* util.cs no longer changes the case of the SQL in order to modify
it to apply permissions.


-----------------------------------------------------------------------
Version 1.7.5 2/27/2004
-----------------------------------------------------------------------

* Added support for adding one attachment to outgoing emails.   
Attachments to emails become bug attachments too.   It's not a very 
nice implementation, but it's better than nothing.  

* Now checking that to, from, and subject fields of outgoing email 
are not blank.

Bug Fixes:

* Added missing column "us_auto_subscribe_own_bugs" to users table in
setup.sql

* Emails generated by clicking on "send email" link have proper magic
words in subject so that replies to them are posted back to same bug.

* Custom date fields now work when adding a new bug as opposed to just
updating an existing bug.  (no problem with other data types).
To add a custom field, use SQL like this to alter the bugs table:

alter table bugs add [Target Completion Date] datetime null


-----------------------------------------------------------------------
Version 1.7.4 2/19/2004
-----------------------------------------------------------------------


Added new setting "DefaultPermissionLevel" in Web.Config.   Previously,
default permission meant allow everything unless specifically denied.
Now you can set btnet to deny everything unless specifically allowed.

Added new way to subscribe to email notifications, Auto Subscribe Own.
When set, user to whom bug is assigned is automatically subscribed to
receive notifications.   See note below "Migrating to 1.7.4.

Added new values to Web.config which I hope help with date localization.
This isn't meant to be a complete solution yet.


"JustDateFormat" - use this to specify the date format without time

"SQLServerDateFormat" - tell btnet how SQL Server dates are formated.
I'm not sure if this really works.

These should help with custom columns of type datetype.   These should
also help allow users to enter dates in local format on the search page.
The calendar control still returns dates in YYYY-MM-DD format, however.


Other Bug fixes:

* Better handling of email errors.  Instead of crash, error message is
returned to user and info is written to log.

* Now able to turn off logging via LogEnabled setting in Web.config.

* Better handling of custom columns.   Now works with DateTime and
nvarchar.


-----------------------------------------------------------------------
Migrating to 1.7.4 
-----------------------------------------------------------------------

Run this sql:

alter table users add us_auto_subscribe_own_bugs int null default(0)
update users set us_auto_subscribe_own_bugs = 0



-----------------------------------------------------------------------
Version 1.7.3 2/7/2004
-----------------------------------------------------------------------

btnet_console.exe and btnet_service.exe now use these settings 
in Web.config as their btnet user/password when inserting bugs.'

<add key="ServiceUsername" value="email2"/>
<add key="ServicePassword" value="x"/>

These entries replace the "username" and "password" entries.

* Also for btnet_console and btnet_service, added new 
"SubjectCannotContain" entry to Web.config.   If not blank,
then emails containing the string are skipped.

* Bug descriptions are now hotlinks if the column heading starts with
the chars "DESC" (case insensitive).


Bug fixes:

* Fixed view_attachment.aspx.  Copyright notice had been part of 
response.

* Fixed page title of print_bug.aspx

* Now works with case-sensitive databases.

* Don't send notifications to users w/o view permission.

* Don't allow multiple default queries.

* Don't show "add attachment" and "send email" links for view only
users.

* No longer using hardcoded "email/x" username/password in 
btnet_service.exe and btnet_console.exe.   
Instead using "ServiceUsernname" and "ServicePassword".


-----------------------------------------------------------------------
Version 1.7.2 12/18/2003
-----------------------------------------------------------------------

* You can add custom columns to the bug table and they will
show up in the edit_bug.aspx form.   For example, if you want
a version field, execute:

alter table bugs add version varchar(20) null

No validation yet.   If you enter non-numeric data or a string that's
too long or leave a required field blank, you will not get a friendly
error message.

-----------------------------------------------------------------------
Version 1.7.1 12/9/2003
-----------------------------------------------------------------------

bug fixes only

* fixed inc_insert_bugs.aspx so as not to insert additional, duplicate,
subscriptions each time bug is changed

* fixed setup.sql to add missing comma in 
"create table project_user_xref"

-----------------------------------------------------------------------
Version 1.7.0 12/6/2003
-----------------------------------------------------------------------

* see note below how to migrate to this version.

* save queries as either "public" or "private".   "private" queries
are only visible to the person wh0 saved them.

* Admins can set project level permissions for users.   Per project, 
bugs are either hidden, readonly, or fully editable.   Since this logic
is new, please don't trust it 100% to prevent a malicious user from 
editing bugs they aren't supposed to.   There might still be holes. 

* btnet_console.exe and btnet_service.exe used to fail if the Subject
header came before the From headers.   Fixed.

-----------------------------------------------------------------------
Migrating 1.7.0
-----------------------------------------------------------------------

	alter table queries add qu_user int null
	alter table project_user_xref add pu_permission_level int default(2)

-----------------------------------------------------------------------
Version 1.6.9 11/12/2003
-----------------------------------------------------------------------

* see note below on how to migrate to this version.

* !!!! IMPORTANT !!!!
delete_bug was completely broken in 1.6.8 but even worse, before that
it was deleting the wrong stuff - like potentially a comment belonging
not to the bug being deleted but to another bug.   Fixed in this version

The sql used to say:
		sql = @"delete from bug_comments where bc_id = $1
			delete from bug_attachments where ba_id = $1
			delete from bug_subscriptions where bs_bug = $1
			delete from bugs where bg_id = $1";
Now it says:
		sql = @"delete from bug_comments where bc_bug = $1
			delete from bug_attachments where ba_bug = $1
			delete from bug_subscriptions where bs_bug = $1
			delete from bugs where bg_id = $1";


* A while back I made some columns bigger in setup.sql.   You might want
to do the same, but you don't have to.  Here's the SQL:

alter table bug_comments alter column bc_comment varchar(7000)
alter table bug_comments alter column bc_email_from varchar(255)
alter table queries alter column qu_sql varchar(7000)

* view_web_config.aspx was broken.  Fixed now.

* New "WindowsAuthentication" setting in Web.config.  See instructions