Using build 1952

Tried to save a filter and promptly got my ass wooped!

Server Error in '/Gemini' Application.

---

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.

Description: 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.

Exception Details: 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.

Thanks, this had been fixed for the release (build  1955).

 

No it hasnt - just downloaded 1955, installed it fine and tried to save a filter with the error:

Server Error in '/Gemini' Application.

---

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.

Description: 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.

Exception Details: 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.

Source Error:

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.

Stack Trace:

Some clarification is needed now, just done more testing. This does not happen if you set a personal filter on a single project.

I get the error when I perform the following:

1. Main gemini page, select "All Projects Issue Reporting"
2. Set my filters according and click View
3. Enter a name into the "Saved Filters" area and the error occurs

We have multiple projects hence why this may occur to us and not specifically everyone else - i'm trying to save a default set of filters for a global view of the projects

Regards

Simon

Are you using an old 3.0 database? Please check that the column projectid allows nulls n the gemini_userissuesviews table.

Yes that column allows nulls - the db was upgraded from V2.2 through 3 beta then RC1, RC2 and final build

Sorry, wrong table, it should be gemini_personalfilters

It didnt but it does now that i've set it and indeed it does fix the problem - thanks