*sigh*... nevermind... restarted mysql service, life is good again.
On Thu, Aug 18, 2011 at 12:47 AM, Greg Skerman <[email protected]> wrote: > 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
