On Dec 1, 2010, at 6:06 PM, Andrew R. Kinnie wrote: > I don't know what InnoDB is, so I'd have to say no.
I don't use MySQL. But I do know that MySQL without InnoDB is... not something I would trust data to. Check the Wiki or search for posts on this by Kieran. > I did delete all the bookings and add new ones. No change. :-/ > > The bookings for the feature are still not appearing either, even though they > are new, but I assume that's a different issue. Could be lack of InnoDB, but more likely something wrong in your app or model. Chuck > > On Dec 1, 2010, at 9:01 PM, Chuck Hill wrote: > >> On Dec 1, 2010, at 5:58 PM, Andrew R. Kinnie wrote: >>> On Dec 1, 2010, at 8:42 PM, Chuck Hill wrote: >>> On Dec 1, 2010, at 5:35 PM, Andrew R. Kinnie wrote: >>>> >>>>> Hmm. That was checked, but set as false. In any event, I was using an >>>>> auto-increment. I gather I should remove this? EOF will do the right >>>>> thing and create it's own pk? >>>> >>>> Yes. Auto-increment does not mix well with data created from EOF. >>>> >>>> >>>>> I changed the debug enabled to true and got this in the console when I >>>>> tried to delete a duplicate: >>>> >>>>> ... >>>>> SELECT t0.AGENT_ID, t0._rowid, t0.COMIC_ID FROM BOOKING t0 FOR UPDATE >>>>> ... >>>>> >>>> >>>> >>>> That is a pretty clear sign that EOF is visibly upset. :-) See if >>>> removing the auto-increment helps. >>>> >>> >>> I already tried that and it didn't help. :-/ >>> >>> Of course now the other issue is that the bookings for the feature act are >>> not showing up at all. >>> >>> This is a new site. Am I better off just deleting all the bookings and >>> adding new ones? (there's only about 25 of them) >> >> >> That is worth a try. If you created data with auto-increment and don't have >> the FK constraints enforced in the database, the relationships might be >> broken (bad data). >> >> Are you running MySQL with InnoDB? >> >> >> Chuck >> >> -- >> Chuck Hill Senior Consultant / VP Development >> >> Practical WebObjects - for developers who want to increase their overall >> knowledge of WebObjects or who are trying to solve specific problems. >> http://www.global-village.net/products/practical_webobjects >> >> >> >> >> >> >> > -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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
