CREATE TABLE `notification` ( `notification_id` bigint(20) unsigned default '0', `text_contents` varchar(4096) default '', `create_date` datetime default NULL, `notification_type_id` int(11) default '1', `application_id` int(11) default NULL, `minutes_to_expire` int(11) default NULL, `story_guid` varchar(100) default NULL, `not_identifier` varchar(100) default NULL, `modify_date` datetime default NULL, `active` int(11) default '1', `pushed` int(11) default '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1
But that is of course, after I re-set the storyGuid to varchar after it was somehow changed to int. So that problem is solved. The other one, remains. (see: RE: intBoolean) On Apr 14, 2011, at 4:58 PM, Kieran Kelleher wrote: > 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 ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com >> >> This email sent to [email protected] >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
