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
