OK, so InnoDB appears to be part of the MySQL Community Server. I'll have a look. Thanks.
On Dec 1, 2010, at 9:24 PM, Chuck Hill wrote: > It is free. Look in the community edition. > > > On Dec 1, 2010, at 6:24 PM, Andrew R. Kinnie wrote: > >> eesh. I'm not being paid for my time (except in beer and wings) so I don't >> think I can do a commercial transaction engine. :-/ >> >> Is there something else that is effectively free for something this small? >> >> On Dec 1, 2010, at 9:09 PM, Chuck Hill wrote: >> >>> >>> 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 >>> >>> >>> >>> >>> >>> >>> >> > > -- > 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 > > > > > > > _______________________________________________ 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
