I recently consolidated three bugtracker databases into one. I did a lot of it by hand in Excel. Once I merged all of the tables together and imported them back into the database I thought everything was working. Now when I query bugs I get 31 pages of bugs when there are only bugs on 17 pages. It also says that I only have 914 bugs in the database when I have 1170. Has anyone else had this type of problem? I could use some help.
thanks,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I figured out the problem. I hadn't merged the site and severity tables from the three databases. This was causing me not to see a lot of bugs. So just an FYI, make sure you look at all the tables when you consolidate.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I recently consolidated three bugtracker databases into one. I did a lot of it by hand in Excel. Once I merged all of the tables together and imported them back into the database I thought everything was working. Now when I query bugs I get 31 pages of bugs when there are only bugs on 17 pages. It also says that I only have 914 bugs in the database when I have 1170. Has anyone else had this type of problem? I could use some help.
thanks,
I figured out the problem. I hadn't merged the site and severity tables from the three databases. This was causing me not to see a lot of bugs. So just an FYI, make sure you look at all the tables when you consolidate.