Time:2015-04-15 18:15:00,023 Level:ERROR Programfile:f:\ZKTime.Net 2.0\ZKTimeNet_Mexico_Access3.5\ZKTimeNet.DAL\NHibernateDaoHelper.cs 423line Message:could not execute query [ select distinct user0_.id as id21_0_, role2_.id as id5_1_, privilege4_.id as id0_2_, menu5_.ID as ID24_3_, user0_.username as username21_0_, user0_.user_pwd as user3_21_0_, user0_.iuser1 as iuser4_21_0_, user0_.iuser2 as iuser5_21_0_, user0_.iuser3 as iuser6_21_0_, user0_.cuser1 as cuser7_21_0_, user0_.cuser2 as cuser8_21_0_, user0_.cuser3 as cuser9_21_0_, user0_.remark as remark21_0_, role2_.role_name as role2_5_1_, role2_.role_available as role3_5_1_, role2_.iuser1 as iuser4_5_1_, role2_.iuser2 as iuser5_5_1_, role2_.iuser3 as iuser6_5_1_, role2_.cuser1 as cuser7_5_1_, role2_.cuser2 as cuser8_5_1_, role2_.cuser3 as cuser9_5_1_, role2_.remark as remark5_1_, rolelist1_.userid as userid0__, rolelist1_.role_id as role10_0__, privilege4_.privilege_name as privilege2_0_2_, privilege4_.iuser1 as iuser3_0_2_, privilege4_.iuser2 as iuser4_0_2_, privilege4_.iuser3 as iuser5_0_2_, privilege4_.cuser1 as cuser6_0_2_, privilege4_.cuser2 as cuser7_0_2_, privilege4_.cuser3 as cuser8_0_2_, privilege4_.remark as remark0_2_, privilege4_.menu_id as menu10_0_2_, role_right3_.role_id as role11_1__, role_right3_.role_pri_id as role10_1__, menu5_.MenuNo as MenuNo24_3_, menu5_.ParentNo as ParentNo24_3_, menu5_.MenuFlag as MenuFlag24_3_, menu5_.MenuName as MenuName24_3_, menu5_.type as type24_3_, menu5_.UserFlag as UserFlag24_3_, menu5_.ModelName as ModelName24_3_, menu5_.Remark as Remark24_3_, menu5_.HelpURL as HelpURL24_3_ from sys_user user0_ left outer join sys_user_role rolelist1_ on user0_.id=rolelist1_.userid left outer join sys_role role2_ on rolelist1_.role_id=role2_.id left outer join sys_role_rights role_right3_ on role2_.id=role_right3_.role_id left outer join sys_privilege privilege4_ on role_right3_.role_pri_id=privilege4_.id left outer join sys_menu menu5_ on privilege4_.menu_id=menu5_.ID where user0_.username=@p0 ] Name:Username - Value:Admin [SQL: select distinct user0_.id as id21_0_, role2_.id as id5_1_, privilege4_.id as id0_2_, menu5_.ID as ID24_3_, user0_.username as username21_0_, user0_.user_pwd as user3_21_0_, user0_.iuser1 as iuser4_21_0_, user0_.iuser2 as iuser5_21_0_, user0_.iuser3 as iuser6_21_0_, user0_.cuser1 as cuser7_21_0_, user0_.cuser2 as cuser8_21_0_, user0_.cuser3 as cuser9_21_0_, user0_.remark as remark21_0_, role2_.role_name as role2_5_1_, role2_.role_available as role3_5_1_, role2_.iuser1 as iuser4_5_1_, role2_.iuser2 as iuser5_5_1_, role2_.iuser3 as iuser6_5_1_, role2_.cuser1 as cuser7_5_1_, role2_.cuser2 as cuser8_5_1_, role2_.cuser3 as cuser9_5_1_, role2_.remark as remark5_1_, rolelist1_.userid as userid0__, rolelist1_.role_id as role10_0__, privilege4_.privilege_name as privilege2_0_2_, privilege4_.iuser1 as iuser3_0_2_, privilege4_.iuser2 as iuser4_0_2_, privilege4_.iuser3 as iuser5_0_2_, privilege4_.cuser1 as cuser6_0_2_, privilege4_.cuser2 as cuser7_0_2_, privilege4_.cuser3 as cuser8_0_2_, privilege4_.remark as remark0_2_, privilege4_.menu_id as menu10_0_2_, role_right3_.role_id as role11_1__, role_right3_.role_pri_id as role10_1__, menu5_.MenuNo as MenuNo24_3_, menu5_.ParentNo as ParentNo24_3_, menu5_.MenuFlag as MenuFlag24_3_, menu5_.MenuName as MenuName24_3_, menu5_.type as type24_3_, menu5_.UserFlag as UserFlag24_3_, menu5_.ModelName as ModelName24_3_, menu5_.Remark as Remark24_3_, menu5_.HelpURL as HelpURL24_3_ from sys_user user0_ left outer join sys_user_role rolelist1_ on user0_.id=rolelist1_.userid left outer join sys_role role2_ on rolelist1_.role_id=role2_.id left outer join sys_role_rights role_right3_ on role2_.id=role_right3_.role_id left outer join sys_privilege privilege4_ on role_right3_.role_pri_id=privilege4_.id left outer join sys_menu menu5_ on privilege4_.menu_id=menu5_.ID where user0_.username=@p0] ----------------------------------------- NHibernate.Exceptions.GenericADOException: could not execute query [ select distinct user0_.id as id21_0_, role2_.id as id5_1_, privilege4_.id as id0_2_, menu5_.ID as ID24_3_, user0_.username as username21_0_, user0_.user_pwd as user3_21_0_, user0_.iuser1 as iuser4_21_0_, user0_.iuser2 as iuser5_21_0_, user0_.iuser3 as iuser6_21_0_, user0_.cuser1 as cuser7_21_0_, user0_.cuser2 as cuser8_21_0_, user0_.cuser3 as cuser9_21_0_, user0_.remark as remark21_0_, role2_.role_name as role2_5_1_, role2_.role_available as role3_5_1_, role2_.iuser1 as iuser4_5_1_, role2_.iuser2 as iuser5_5_1_, role2_.iuser3 as iuser6_5_1_, role2_.cuser1 as cuser7_5_1_, role2_.cuser2 as cuser8_5_1_, role2_.cuser3 as cuser9_5_1_, role2_.remark as remark5_1_, rolelist1_.userid as userid0__, rolelist1_.role_id as role10_0__, privilege4_.privilege_name as privilege2_0_2_, privilege4_.iuser1 as iuser3_0_2_, privilege4_.iuser2 as iuser4_0_2_, privilege4_.iuser3 as iuser5_0_2_, privilege4_.cuser1 as cuser6_0_2_, privilege4_.cuser2 as cuser7_0_2_, privilege4_.cuser3 as cuser8_0_2_, privilege4_.remark as remark0_2_, privilege4_.menu_id as menu10_0_2_, role_right3_.role_id as role11_1__, role_right3_.role_pri_id as role10_1__, menu5_.MenuNo as MenuNo24_3_, menu5_.ParentNo as ParentNo24_3_, menu5_.MenuFlag as MenuFlag24_3_, menu5_.MenuName as MenuName24_3_, menu5_.type as type24_3_, menu5_.UserFlag as UserFlag24_3_, menu5_.ModelName as ModelName24_3_, menu5_.Remark as Remark24_3_, menu5_.HelpURL as HelpURL24_3_ from sys_user user0_ left outer join sys_user_role rolelist1_ on user0_.id=rolelist1_.userid left outer join sys_role role2_ on rolelist1_.role_id=role2_.id left outer join sys_role_rights role_right3_ on role2_.id=role_right3_.role_id left outer join sys_privilege privilege4_ on role_right3_.role_pri_id=privilege4_.id left outer join sys_menu menu5_ on privilege4_.menu_id=menu5_.ID where user0_.username=@p0 ] Name:Username - Value:Admin [SQL: select distinct user0_.id as id21_0_, role2_.id as id5_1_, privilege4_.id as id0_2_, menu5_.ID as ID24_3_, user0_.username as username21_0_, user0_.user_pwd as user3_21_0_, user0_.iuser1 as iuser4_21_0_, user0_.iuser2 as iuser5_21_0_, user0_.iuser3 as iuser6_21_0_, user0_.cuser1 as cuser7_21_0_, user0_.cuser2 as cuser8_21_0_, user0_.cuser3 as cuser9_21_0_, user0_.remark as remark21_0_, role2_.role_name as role2_5_1_, role2_.role_available as role3_5_1_, role2_.iuser1 as iuser4_5_1_, role2_.iuser2 as iuser5_5_1_, role2_.iuser3 as iuser6_5_1_, role2_.cuser1 as cuser7_5_1_, role2_.cuser2 as cuser8_5_1_, role2_.cuser3 as cuser9_5_1_, role2_.remark as remark5_1_, rolelist1_.userid as userid0__, rolelist1_.role_id as role10_0__, privilege4_.privilege_name as privilege2_0_2_, privilege4_.iuser1 as iuser3_0_2_, privilege4_.iuser2 as iuser4_0_2_, privilege4_.iuser3 as iuser5_0_2_, privilege4_.cuser1 as cuser6_0_2_, privilege4_.cuser2 as cuser7_0_2_, privilege4_.cuser3 as cuser8_0_2_, privilege4_.remark as remark0_2_, privilege4_.menu_id as menu10_0_2_, role_right3_.role_id as role11_1__, role_right3_.role_pri_id as role10_1__, menu5_.MenuNo as MenuNo24_3_, menu5_.ParentNo as ParentNo24_3_, menu5_.MenuFlag as MenuFlag24_3_, menu5_.MenuName as MenuName24_3_, menu5_.type as type24_3_, menu5_.UserFlag as UserFlag24_3_, menu5_.ModelName as ModelName24_3_, menu5_.Remark as Remark24_3_, menu5_.HelpURL as HelpURL24_3_ from sys_user user0_ left outer join sys_user_role rolelist1_ on user0_.id=rolelist1_.userid left outer join sys_role role2_ on rolelist1_.role_id=role2_.id left outer join sys_role_rights role_right3_ on role2_.id=role_right3_.role_id left outer join sys_privilege privilege4_ on role_right3_.role_pri_id=privilege4_.id left outer join sys_menu menu5_ on privilege4_.menu_id=menu5_.ID where user0_.username=@p0] ---> System.Data.SQLite.SQLiteException: SQLite error no such table: sys_user at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) at System.Data.SQLite.SQLiteCommand.BuildNextCommand() at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) --- End of inner exception stack trace --- at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) at NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters) at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results) at NHibernate.Impl.SessionImpl.List(String query, QueryParameters queryParameters, IList results) at NHibernate.Impl.SessionImpl.List[T](String query, QueryParameters parameters) at NHibernate.Impl.QueryImpl.List[T]() at ZKTimeNet.DAL.NHibernateDaoHelper.GetEntities[T](String strHQL, Hashtable parameter) in f:\ZKTime.Net 2.0\ZKTimeNet_Mexico_Access3.5\ZKTimeNet.DAL\NHibernateDaoHelper.cs:line 415