SQL server permissions issue?
So I've got a Gemini v3.1.1 install partially up and running. I had it working in a test environment, but then I started with a manual install of Gemini in a production system, copying the database over from the test environment. I am able to change configuration parameters from within the admin interface. However, there are many things that I can't do. For example, when I try to assign an issue to myself
Assigned To
<span id="ctl00_Main_lblAssignedTo"></span>[<a id="ctl00_Main_ISSUE_ViewIssueAssignMe" href="javascript:__doPostBack('ctl00$Main$ISSUE_ViewIssueAssignMe','')">Assign Issue to me</a>]
<br><font size="2" face="Courier New"><br><font face="Arial">I get a javascript popup:</font><br><br>could not insert: [CounterSoft.Gemini.Commons.IssueResourceEN][SQL: INSERT INTO gemini_issueresources (issueid, userid) VALUES (?, ?); select SCOPE_IDENTITY()]<br><br><font face="Arial">I've been fighting with this, thinking it is a permissions issue with the SQL server, but no amount of messing with that has solved this. The app can read anything from the database, but can't write certain things. Other places of fail are when I try to add a comment to an issue - submitting the form doesn't go anywhere - it acts like it is posting, but then returns me to the same place of being able to add a comment, but didn't actually add it.<br><br>As far as I know I did not mess with the tables or any table-specific permissions in the Gemini database that would explain this.<br></font></font>
horatio
· 1 |
|
Wednesday, March 4, 2009, 2:47:11 PM |