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
