OK, well I did that, and even re-booted the machine. No change. In other news if I eliminate my second sort ordering, the previously missing booking appears. I changed it to use ERXSortOrdering and get the same result.
I need a beer. On Dec 1, 2010, at 9:39 PM, Pascal Robert wrote: > At a minimum, create a file called my.cnf in /etc , and add this text in the > file: > > [mysqld] > lower_case_table_names = 1 > default-storage-engine = InnoDB > > And restart MySQL. EOF will be more happy. The default table type in MySQL is > MyISAM, which is fast but is not transactions safe (and it auto commit). > >> 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/probert%40macti.ca >> >> This email sent to prob...@macti.ca > _______________________________________________ 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
