Bug saving filter
Using build 1952
Tried to save a filter and promptly got my ass wooped!
Server Error in '/Gemini' Application.
<h2> <i>Cannot
insert the value NULL into column 'projectid', table
'Gemini3.dbo.gemini_personalfilters'; column does not allow nulls.
INSERT fails.
The statement has been terminated.
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.
<b> Exception Details: </b>System.Data.SqlClient.SqlException:
Cannot insert the value NULL into column 'projectid', table
'Gemini3.dbo.gemini_personalfilters'; column does not allow nulls.
INSERT fails.
The statement has been terminated.
SimonASE
· 1 |
|
Monday, May 12, 2008, 3:11:12 PM |
0
|
Thanks, this had been fixed for the release (build 1955).
|
||||
|
0
|
No it hasnt - just downloaded 1955, installed it fine and tried to save a filter with the error: Server Error in '/Gemini' Application.
insert the value NULL into column 'projectid', table
'Gemini3.dbo.gemini_personalfilters'; column does not allow nulls.
INSERT fails.
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.
Cannot insert the value NULL into column 'projectid', table
'Gemini3.dbo.gemini_personalfilters'; column does not allow nulls.
INSERT fails.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
|
||||
|
0
|
Some clarification is needed now, just done more testing. This does not happen if you set a personal filter on a single project.
Regards Simon |
||||
|
0
|
Are you using an old 3.0 database? Please check that the column projectid allows nulls n the gemini_userissuesviews table. |
||||
|
0
|
Yes that column allows nulls - the db was upgraded from V2.2 through 3 beta then RC1, RC2 and final build |
||||
|
0
|
Sorry, wrong table, it should be gemini_personalfilters |
||||
|
0
|
It didnt but it does now that i've set it and indeed it does fix the problem - thanks |
||||
|