Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Invalid column name 'ResetPWD' Exception After Install

web-app

On a brand new installation of Gemini I'm getting the following stack trace when accessing it for the first time...

[SqlException (0x80131904): Invalid column name 'ResetPWD'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.getMetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +216
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +243
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +201
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +70
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +102

[ADOException: could not execute query
[ SELECT this
.userid as userid340, this.username as username340, this.firstname as firstname340, this.surname as surname340, this.pwd as pwd340, this.emailaddress as emailadd6340, this.roles as roles340, this.created as created340, this.lastupdated as lastupda9340, this.ResetPWD as ResetPWD340, this.active as active340, this.comment as comment340, this.apikey as apikey340, this.logindate as logindate340, this.previouslogindate as previou15340, this.tstamp as tstamp340, this.firstname + ' ' + this.surname as formula130 FROM geminiusers this WHERE this.username = @p0 and this.pwd = @p1 and this.active = @p2 ]
Positional parameters: #0>anon #1>System.Byte[] #2>True
[SQL: SELECT this
.userid as userid340, this.username as username340, this.firstname as firstname340, this.surname as surname340, this.pwd as pwd340, this.emailaddress as emailadd6340, this.roles as roles340, this.created as created340, this.lastupdated as lastupda9340, this.ResetPWD as ResetPWD340, this.active as active340, this.comment as comment340, this.apikey as apikey340, this.logindate as logindate340, this.previouslogindate as previou15340, this.tstamp as tstamp340, this.firstname + ' ' + this.surname as formula130 FROM geminiusers this WHERE this.username = @p0 and this.pwd = @p1 and this.active = @p2]]
CounterSoft.Gemini.Default.AuthUser(String strUID, String strPWD) +61
CounterSoft.Gemini.Default.Page
Load(Object sender, EventArgs e) +315
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
What might be going on?

Thanks.

dnezamfar
· 1
dnezamfar
Replies (2)
helpful
0
not helpful

seems like your database setting is case sensative. Please edit the gemini_users table and rename the column to the same casing (ResetPWD) or install to a case insensative database.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Using a case insensitive database got me working again.

Thanks for the help.


dnezamfar
· 1
dnezamfar