Re: Ponder: Error on login attempt

You're using MySQL... it doesn't defer FK constraints.  You should consider postgresql ;-)  If you are just a glutton for punishment tho, add

com.webobjects.eoaccess.ERXEntityDependencyOrderingDelegate.active=true

to your properties. It should fix these as long as there are no circularly required relationships anywhere.

Ramsey


On Dec 7, 2012, at 9:55 AM, James Cicenia wrote:

> Ok -
> 
> Finished up some nice modeling, migrations and some nav stuff.
> Went to try out your new logging code and got:
> 
> And I don't think ERAuthDirectAction : eo.validateForSave(); ever triggers an exception.
> 
> 
> 
> com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "INSERT INTO ERAuthenticationResponse(authenticationRequestID, authenticationFailed, userID, subtype, id, authenticationFailureType) VALUES (?, ?, ?, ?, ?, ?)" withBindings: 1:6(authenticationRequestID), 2:true(authenticationFailed), 3:_EOIntegralKeyGlobalID[ERUser (java.lang.Integer)1](userID), 4:"ERTwoFactorAuthenticationResponse"(subtype), 5:6(id), 6:ACCOUNT_DEACTIVATED(authenticationFailureType)>: Next exception:SQL State:23000 -- error code: 1452 -- msg: Cannot add or update a child row: a foreign key constraint fails (`PurplePush`.`ERAuthenticationResponse`, CONSTRAINT `ERAuthenticationResponse_authenticationRequestID_id_FK` FOREIGN KEY (`authentic
 ationRequestID`) REFERENCES `ERAuthenticationRequest` (`id`))
> 
> 
> Thanks
> James
> 
> 
> ------------------------------------------------------------------------------
> LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
> Remotely access PCs and mobile devices and provide instant support
> Improve your efficiency, and focus on delivering more value-add services
> Discover what IT Professionals Know. Rescue delivers
> http://p.sf.net/sfu/logmein_12329d2d_______________________________________________
> Wonder-disc mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/wonder-disc


------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d