Just installed the free version, and get sql errors
Hi,
I just install the free version, and when running the home page I get the generic error.
windows logs file show a sql error. I double check the connexionString, It's fine, the problem come from the request itself :
SELECT this.projectgroupmembershipid as projectg1210, this.projectid as projectid210, this.projectgroupid as projectg3210, this.userid as userid210, (select geminiprojectgroups.ProjectGroupName from geminiprojectgroups where geminiprojectgroups.projectgroupid = this.projectgroupid) as formula60, (select geminiprojects.ProjectName from geminiprojects where geminiprojects.projectid = this.projectid) as formula70 FROM geminiprojectgroupmembership this WHERE this_.userid = 0
Both subrequests use columns with cased names : gemini_projectgroups.ProjectGroupName. But in database, columns name are lower case... and sql server is case sensitive.
Is there a sql script to correct this, or a binary update ?
Thanks.
User26762
· 1 |
|
Thursday, June 23, 2011, 1:31:06 PM |
0
|
Make sure you model database is not case sensative. |
||||
|
0
|
Ok, I changed the interclassement. Now another issue, the client gemini program can't connect the webserver... wich is local for testing purpose (http://localhost/Gemini) Message : Invalid gemini URL? the website work well when accessing it locally with browsers, with or without the proxy. Is there any limitation ? also tried with local dns name without success. |
||||
|
0
|
You need to use the machine name if browsing from another PC: http://pc name/gemini |
||||
|
0
|
Not so stupid :) My tests are on the local machine with the webapp on the same machine. Using the machine name did'nt solve the issue. Still the same message. Again, I browser the site with the same url through IE and firefox without issue, and with or without the proxy configured. |
||||
|
0
|
Please check the app.log for errors: %appdata%\CounterSoft\Gemini\Desktop\app.log |
||||
|
0
|
Please make sure that anonymous access is allowed in IIS for the Gemini site. |
||||
|
0
|
Hi, the file exist, but is empty I checked the website access with simple code, and get a Http401 error on Gemini. Look like the website has some build in restriction, as I can access others website on the same machine with this code. WebRequest wr = HttpWebRequest.Create("http://localhost/Gemini"); WebResponse response = wr.GetResponse(); Stream str = response.GetResponseStream(); StreamReader read = new StreamReader(str); Console.Write(read.ReadToEnd()); Ok, solved the issue for my code in commenting out web.Config : !authorization!!deny users="?" /!!/authorization! ... But still no way for the Gemini app. Yes anonymous access is ON |
||||
|
0
|
Please send an email to support at countersoft dot com, we will do a remote session to see what the issue is. |
||||
|
0
|
ANSWER
For readers, the missing thing was pipeline mode on the application pool : set it integrated. Thanks for your help :) |
||||
|