What is the value that it is actually trying to insert/ On Sun, May 16, 2010 at 7:30 PM, Nathan Stott <[email protected]> wrote:
> I'm having some issues with rhino security and MySQL. > > NHibernate creates the tables fine (I'm using NH 2.1.2) but then I get this > error when a UserGroup is being created. It created the UserGroup table > with Id of VARCHAR(40) and Latin1 collation. I changed this to UTF8 > thinking that was the problem, but I get the same error. > > Any advice appreciated. > > Here is the stack trace: > > [MySqlException (0x80004005): Incorrect string value: '\xCE\xE9\xA0C\xCDT...' > for column 'Id' at row 1] > MySql.Data.MySqlClient.MySqlStream.ReadPacket() +251 > MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, > Int64& lastInsertId) +103 > MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +87 > MySql.Data.MySqlClient.MySqlDataReader.NextResult() +1451 > MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior > behavior) +1762 > MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() +32 > MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() +69 > NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) +303 > NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) > +65 > NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, > Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, > ISessionImplementor session) +923 > > [GenericADOException: could not insert: > [Rhino.Security.Model.UsersGroup#43a0e9ce-54cd-4963-b29f-9d7800ecce85][SQL: > INSERT INTO security_UsersGroups (Name, Parent, Id) VALUES (?, ?, ?)]] > NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, > Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, > ISessionImplementor session) +1321 > NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, > Object[] fields, Object obj, ISessionImplementor session) +312 > NHibernate.Action.EntityInsertAction.Execute() +368 > NHibernate.Engine.ActionQueue.Execute(IExecutable executable) +187 > NHibernate.Engine.ActionQueue.ExecuteActions(IList list) +125 > NHibernate.Engine.ActionQueue.ExecuteActions() +35 > > NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource > session) +221 > > NHibernate.Event.Default.DefaultAutoFlushEventListener.OnAutoFlush(AutoFlushEvent > event) +201 > NHibernate.Impl.SessionImpl.AutoFlushIfRequired(ISet`1 querySpaces) +295 > NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +519 > NHibernate.Impl.CriteriaImpl.List(IList results) +66 > NHibernate.Impl.CriteriaImpl.List() +65 > NHibernate.Impl.CriteriaImpl.UniqueResult() +31 > NHibernate.Impl.CriteriaImpl.UniqueResult() +44 > Rhino.Security.Services.AuthorizationRepository.GetOperationByName(String > operationName) +141 > Rhino.Security.Services.AuthorizationRepository.CreateOperation(String > operationName) +224 > > WB.Calendar.Web.Controllers.<>c__DisplayClass25.<InitializeSecurity>b__f(String > operation) in > C:\working\calendar\src\WB.Calendar.Web\Controllers\DatabaseController.cs:184 > System.Collections.Generic.List`1.ForEach(Action`1 action) +56 > EnumerableHelper.ForEach(IEnumerable`1 sequence, Action`1 action) +102 > WB.Calendar.Web.Controllers.<>c__DisplayClass25.<InitializeSecurity>b__e() > in > C:\working\calendar\src\WB.Calendar.Web\Controllers\DatabaseController.cs:184 > > WB.Calendar.Web.Controllers.<>c__DisplayClass25.<InitializeSecurity>b__d(Action > x) in > C:\working\calendar\src\WB.Calendar.Web\Controllers\DatabaseController.cs:170 > WB.Calendar.Web.Controllers.DatabaseController.InitializeSecurity() in > C:\working\calendar\src\WB.Calendar.Web\Controllers\DatabaseController.cs:174 > lambda_method(ExecutionScope , ControllerBase , Object[] ) +74 > System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, > Object[] parameters) +17 > System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext > controllerContext, IDictionary`2 parameters) +178 > > System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext > controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 > parameters) +24 > System.Web.Mvc.<>c__DisplayClassa.<InvokeActionMethodWithFilters>b__7() +52 > > System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter > filter, ActionExecutingContext preContext, Func`1 continuation) +254 > System.Web.Mvc.<>c__DisplayClassc.<InvokeActionMethodWithFilters>b__9() +19 > > System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext > controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, > IDictionary`2 parameters) +192 > System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext > controllerContext, String actionName) +399 > System.Web.Mvc.Controller.ExecuteCore() +126 > System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +27 > > System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext > requestContext) +7 > System.Web.Mvc.MvcHandler.ProcessRequest(HttpContextBase httpContext) +151 > System.Web.Mvc.MvcHandler.ProcessRequest(HttpContext httpContext) +57 > > System.Web.Mvc.MvcHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext > httpContext) +7 > > System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() > +181 > System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& > completedSynchronously) +75 > > -- > You received this message because you are subscribed to the Google Groups > "Rhino Tools Dev" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<rhino-tools-dev%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/rhino-tools-dev?hl=en. > -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
