What is the output from the following statement in your mysql database: 

        SHOW CREATE TABLE NOTIFICATION;



On Apr 14, 2011, at 4:03 PM, Andrew Kinnie wrote:

> Well, today is just doing a bang-up job of making me question my profession.
> 
> In attempting to ensure that my version of WO and Wonder were in agreement 
> with the server, I got the latest wonder from git, installed it per the 
> instructions on the wiki, and now my app won't run on the development machine 
> with a completely different error on save changes.
> 
> EOGeneralAdaptorException: EvaluateExpression failed: 
> <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "INSERT INTO 
> NOTIFICATION(notification_type_id, not_identifier, pushed, active, 
> text_contents, modify_date, minutes_to_expire, create_date, application_id, 
> story_guid, notification_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 
> withBindings: 1:2(notificationTypeID), 2:"42"(notificationIdentifier), 
> 3:true(pushed), 4:true(active), 5:"Yadda Yadda"(textContents), 6:2011-04-14 
> 15:54:31(modifyDate), 7:23(minutesToExpire), 8:2011-04-14 
> 15:54:31(createDate), 9:1(applicationId), 10:"ljkdfgs"(storyGuid), 
> 11:42(notification_Id)>:
>     Next exception:SQL State:HY000 -- error code: 1366 -- msg: Incorrect 
> integer value: 'ljkdfgs' for column 'story_guid' at row 1
>   at 
> com.webobjects.eoaccess.EODatabaseContext._exceptionWithDatabaseContextInformationAdded(EODatabaseContext.java:4504)
>      ... skipped 1 stack elements
>   at 
> com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:376)
>   at 
> com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192)
> 
> The database is the same (storyGuid is a varchar 100), the model is the same 
> (storyGuid is a string -> varchar 100).  I have regenerated.  Somehow, for no 
> reason I understand, EOF has decided it is an int.  So if I pass in text, I 
> get this crash.  The IT guy hasn't come back yet, so I didn't check anything 
> on the server (other than the db itself, to ensure that is a varchar 100).
> 
> Any ideas on this?
> 
> Andrew
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com
> 
> This email sent to kelleh...@gmail.com

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to