setting atomic to false successfully saves... so would appear to be a mysql problem? if so what am I doing wrong? The storage engine is set correctly as far as I can tell...
On Wed, Aug 17, 2011 at 11:45 PM, Greg Skerman <[email protected]> wrote: > This one has me stumped. > > I'm using Innodb storage engine, cakephp 1.3 > and doing the following: > > function withdraw() { > // dynamically associate Event with EventTransactions > $this->Event->bindModel( > array('hasOne' => array('EventTransaction')) > ); > $this->set('InventoryTypes', > $this->Event->EventTransaction->InventoryType->find('list')); > if (!empty($this->data)) { > > // check the result > $this->set('test', $this->data); > if ($this->Event->validates()) { > $this->set('validated', 'validated'); > } > $this->Event->saveAll($this->data); > > } > } > > > the validates check proves the model validates, however the transaction > seems to start, then I get nothing - No errors, no records are saved... > > I'm not enforcing foreign key constraints... I'm simply trying to store a > record in the events table, with a dynamically associated entry in the > event_transactions table. > > What have I done wrong here? > > Test view is: > <h2>Withdraw PI Material from POS Hanger</h2> > <?php > echo $this->Form->create('Event', array('url' => array('controller' => > 'transactions', 'action' => 'withdraw'))); > echo $this->Form->hidden('Event.user_id', array('value' => 1)); > echo $this->Form->hidden('Event.event_type_id', array('value' => 1)); > echo $this->Form->Select('EventTransaction.inventory_type_id', > $InventoryTypes); > echo $this->Form->Input('EventTransaction.amount'); > echo $this->Form->end('Submit'); > > pr($test); > pr($validated); > ?> > > output in the SQL query table at the bottom of the page is: > > NrQueryErrorAffectedNum. rows Took (ms) 1DESCRIBE `events` > 661 2DESCRIBE `event_types` > 4411 3DESCRIBE `users` > 881 4DESCRIBE `accounts` > 661 5DESCRIBE `characters` > 881 6DESCRIBE `periods` > 551 7DESCRIBE `event_transactions` > 662 8DESCRIBE `inventory_types` > 16161 9SELECT `InventoryType`.`id`, `InventoryType`.`typeName` FROM > `inventory_types` AS `InventoryType` WHERE 1 = 1 > 19091 19091175 10START TRANSACTION > 0 > 0 > > Help? (i'm sure I've used saveall before without this problem....) > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
