Bug Tracking System


Posted Date:     Total Responses: 0    Posted By: Sameer Sayani   Member Level: Gold   Points/Cash: 115   


Bug Tracking System is a web based application developed as a common platform for both developer and QA. QA can do the folowing:-

1. Add new Projects to the system.
2. Post new bugs to the system.
3. Delete existing bugs from the system.
4. Upload snaphots of errors in the system.
5. System will automatically send email notification to the concern developer(s) about the Bug(s).
6. Both developer & QA can share their comments on the Buglist of Projects.
7. Developer can only view the Buglist and can update the status of Bug as Pending, Completed, Inprogress or Bot an Bug etc as provided by the system.
8. QA can re-open the closed Bug if QA feels that the Bug need to be rectified more afterwards.
9. A logfile is maintained for the QA where he can watch how many developers visited the buglist.
10. This Bug Tracking System can be used by any Software Development Organisation.


Attachments

  • database script (661-212343-dbBTS.txt)
  • Bug Tracking System (661-25216-BugTracker.zip)

    • Project Feedbacks
    Author: Member Level: BronzeRevenue Score: 1 out of 5
    nice post


    icon.txt
    Author: Member Level: BronzeRevenue Score: 1 out of 5
    nice project


    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    I m getting error while adding a new bug as below.

    Could not find stored procedure 'dbo.AspNet_SqlCacheUpdateChangeIdStoredProcedure'.This procecure called in inside the trigger.

    Please help me.


    Author: Member Level: GoldRevenue Score: 1 out of 5
    nice sharing, but it has any licencing issue?


    Author: Member Level: GoldRevenue Score: 5 out of 55 out of 55 out of 55 out of 55 out of 5
    I tried your project but fail because of your database script, its showing lot off errors. i am trying to execute script in SQLSERVER 2000, so please write some detail so other can assess this project

    Below are the errors

    Server: Msg 170, Level 15, State 1, Line 13
    Line 13: Incorrect syntax near '('.
    Server: Msg 2812, Level 16, State 62, Line 2
    Could not find stored procedure 'sys.sp_addextendedproperty'.
    Server: Msg 170, Level 15, State 1, Line 14
    Line 14: Incorrect syntax near '('.
    Server: Msg 2812, Level 16, State 62, Line 2
    Could not find stored procedure 'sys.sp_addextendedproperty'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 2812, Level 16, State 62, Line 2
    Could not find stored procedure 'sys.sp_addextendedproperty'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Warning: The table 'tbl_Bugs' has been created but its maximum row size (9273) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
    Server: Msg 208, Level 16, State 1, Line 2
    Invalid object name 'sys.triggers'.
    Server: Msg 2812, Level 16, State 62, Line 2
    Could not find stored procedure 'sys.sp_addextendedproperty'.
    Server: Msg 2812, Level 16, State 62, Line 2
    Could not find stored procedure 'sys.sp_addextendedproperty'.
    Server: Msg 2812, Level 16, State 62, Line 2
    Could not find stored procedure 'sys.sp_addextendedproperty'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.views'.
    Server: Msg 2812, Level 16, State 62, Line 2
    Could not find stored procedure 'sys.sp_addextendedproperty'.
    Server: Msg 2812, Level 16, State 62, Line 2
    Could not find stored procedure 'sys.sp_addextendedproperty'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.



    Author: Member Level: SilverRevenue Score: 3 out of 53 out of 53 out of 5
    I m getting error below while running the SQL script.

    Cannot add rows to sysd"epends for the current object because it depends on the missing object 'dbo.AspNet_SqlCacheUpdateChangeIdStoredProcedure'. The object will still be created."

    Please help me



    Author: Member Level: GoldRevenue Score: 5 out of 55 out of 55 out of 55 out of 55 out of 5
    Hi kumaraswamy,
    1.You have to create a virtual directory.
    2.Download project. Unzip all files.
    3. Create DB in sql & run sql script by copy paste in sql query analyzer.
    4. Change your connection string as required.
    5. Copy all pages in the virtual diecrtory.
    6. Finally build project & on success run website.

    If still you find difficulty, drop me a mail at sameersayani@gmail.com

    Regards,
    Sameer




    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    nisar,
    find the db file & create a database with same name & run the script in sql analyzer. It will create all tables & stored procedures.


    Author: Member Level: GoldRevenue Score: 5 out of 55 out of 55 out of 55 out of 55 out of 5
    Hi kumaraswamy,
    1.You have to create a virtual directory.
    2.Download project. Unzip all files.
    3. Create DB in sql & run sql script by copy paste in sql query analyzer.
    4. Change your connection string as required.
    5. Copy all pages in the virtual diecrtory.
    6. Finally build project & on success run website.

    If still you find difficulty, drop me a mail at sameersayani@gmail.com

    Regards,
    Sameer






    Author: Member Level: GoldRevenue Score: 5 out of 55 out of 55 out of 55 out of 55 out of 5
    Hi kumaraswamy,
    1.You have to create a virtual directory.
    2.Download project. Unzip all files.
    3. Create DB in sql & run sql script by copy paste in sql query analyzer.
    4. Change your connection string as required.
    5. Copy all pages in the virtual diecrtory.
    6. Finally build project & on success run website.

    If still you find difficulty, drop me a mail at sameersayani@gmail.com

    Regards,
    Sameer


    Author: Member Level: GoldRevenue Score: 3 out of 53 out of 53 out of 5
    Hi,

    I ma again uploading the db script for bug tracking system project. Note that the DB is in SQL-2005. Just copy paste the script from txt file to SQL2005 query analyzer & run. It will generate all the tables, stored procedures, views & user defined feunctions.

    Regards,
    Sameer



    dbBugtracker.txt
    Author: Member Level: GoldRevenue Score: 1 out of 5
    DB Script Bug Tracking System. Find Below:-


    dbBugtracker.txt
    Author: Member Level: GoldRevenue Score: 1 out of 5
    Dear All,
    Please follow the attached db script for the project Bug Tracking System.


    Author: Member Level: SilverRevenue Score: 1 out of 5
    can u tell me how to use this project


    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    Hi,
    Its really nice. I would like learn such type of things.

    It will be greatful for me to send the files.

    Thanks
    Siva Sreenath


    Author: Member Level: GoldRevenue Score: 2 out of 52 out of 5
    how to run this project. i am very confusing.

    can u post clearly and mention unique id to find out which application to be run first.


    Post Feedback
    You must Sign In to post a feedback.
    Next Project: Sample AJAX & With out AJAX Web site
    Previous Project: IPAddress To Country Resolver

    Return to Project Index

    Post New Project

    Related Projects


    Top Contributors
    Today
      Last 7 Days
        more...

        Awards & Gifts

        Online Members

        More...
         
        Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India