WTF with my DB?

Hey,

What is going on with my DB (MS SQL Server 2005)?

select * from mantis_project_table

id  name  status  enabled  view_state  access_min  file_path  description
1    Password Resets    50    1    10    10        Requests for password
resets.
2    Email Problems    50    1    10    10
3    PC Upgrade    50    1    10    10        PC Upgrade
4    Install    50    1    10    10
5    New User    50    1    10    10        New User
6    Purchasing    50    1    10    10
7    FTP Server Access    50    1    10    10        FTP Server Access
8    Phone    50    1    10    10        Phone requests.
9    Report Requests    50    1    10    10
10    Hardware Problems    50    1    10    10
11    Internet problems    50    1    10    10
12    SQL Server    50    1    10    10
13    Software Problems    50    1    10    10
14    Cincom    50    1    10    10
15    Distribution List    50    1    10    10

select * from mantis_project_category_table where project_id > 15

project_id    category    user_id
16    Access    13
16    QicLink    13
17    Desktop    8
17    Fax Machine    8
17    Keyboard/Mouse    8
17    Laptop    8
17    Monitor    8
17    Printer    8
18    Report Issue    8
19    Request    11
20    MS Office    8
21    Request    7
22    Add people    5
22    New List    5
22    Remove people    5

All this was done from the web-side.  How is it possible that when I add a
category, it goes to some project_id that does not exist?

Here is another weird issue:

select * from mantis_project_table where [category] = 'Access'

Msg 207, Level 16, State 1, Line 1
Invalid column name 'category'.

Thanks for any help,

Jim

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com

_______________________________________________
mantisbt-help mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mantisbt-help