Re: Can not save two fields
Guys, I know I'm not offering a solution to the problem, but can you stop quoting previous messages in your responses. This one topic took close to 5000 lines content of the summary email that was sent out yesterday which I'm sure is hindering anyone even bothering to read about the problem or status of any potential solutions. cheers BREWER -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
RE: Can not save two fields
No, from the beginning they were as you see now, then in talks last night we
changed the 2 fields in question to something without _ underscore to see if
anything happened but the $order['Order'][fields] matched up all the same in
the controller to db.
These are not fields in the form, authorization / transaction info sent back
from merchant account based on successful payment so just manually adding it
to the data to be saved.
if( $process_payment['ACK'] === 'Success'){
$order['Order']['correlation_id'] =
$process_payment['CORRELATIONID'];
$order['Order']['transaction_id'] =
$process_payment['TRANSACTIONID'];
}
And rest of the code...
$save = $this->Order->saveAssociated($order,array('validate'=>false) );
-Original Message-
From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
Of lowpass
Sent: Thursday, February 07, 2013 11:19 PM
To: cake-php@googlegroups.com
Subject: Re: Can not save two fields
On Thu, Feb 7, 2013 at 9:18 PM, Advantage+ wrote:
>
> 'correlation_id' => 'e448a45e8d429',
> 'transaction_id' => '2LH603618P261513G',
Earlier you said the fields were correlation and transaction, but here
they're correlation_id and transaction_id. I'm guessing your form inputs use
the latter names and Cake is dropping them because they don't match the
schema.
--
Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter
http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
Re: Can not save two fields
On Thu, Feb 7, 2013 at 9:18 PM, Advantage+ wrote: > > 'correlation_id' => 'e448a45e8d429', > 'transaction_id' => '2LH603618P261513G', Earlier you said the fields were correlation and transaction, but here they're correlation_id and transaction_id. I'm guessing your form inputs use the latter names and Cake is dropping them because they don't match the schema. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
RE: Can not save two fields
Still no luck with this mystery.
I dropped the db table and recreated it. Same thing, refuses to save those 2
fields. (Fields in bold in the array below)
So the fields are populated with the data, when I remove the debug / die it
saves everything except these 2 maddening fields!
public function beforeSave(){
debug($this->data['Order']);
die();
}
I dump the data before the save in the Order model:
/app/Model/Order.php (line 55)
array(
'first_name' => 'Dave',
'last_name' => 'Dave',
'email' => 'd...@here.com',
'phone' => '555-555-',
'billing_address' => '123 King',
'billing_address2' => '',
'billing_city' => 'St Johns',
'billing_state' => 'NL',
'billing_zip' => '12345',
'billing_country' => 'CA',
'sameaddress' => '0',
'shipping_address' => 'Ship 1',
'shipping_address2' => 'Ship 2',
'shipping_city' => 'Ship City',
'shipping_state' => 'Ship State',
'shipping_zip' => 'Ship Zip',
'shipping_country' => 'Ship CA',
'order_type' => 'creditcard',
'order_item_count' => (int) 2,
'quantity' => (int) 10,
'weight' => '12.50',
'subtotal' => '349.90',
'total' => '349.90',
'shop' => (int) 1,
'status' => (int) 1,
'user_id' => '51145f50-3058-47cf-b7ef-61f0c09b532a',
'correlation_id' => 'e448a45e8d429',
'transaction_id' => '2LH603618P261513G',
'modified' => '2013-02-07 18:13:42',
'created' => '2013-02-07 18:13:42'
)
From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
Of crush
Sent: Thursday, February 07, 2013 4:36 AM
To: cake-php@googlegroups.com
Subject: Re: Can not save two fields
Make sure you delete the model caches, debug level 1 and maybe reload apache
to force it to recheck the DB and see the new fields. That's gotten me a few
times when it just wouldn't save something.
Also, just in case, you can do a $this->Model->save($this->request->data,
array('validate'=>false)); to make sure the validation is still not a
problem.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
RE: Can not save two fields
Yeah I did all that, on nGinx but still restarted. I cleared the model cache
and did the query on the new fields just to make sure it was finding the new
and they came back from the query fine (empty) but the fields were found in
the table.
I do debug() before the save and the data for the 2 fields are there, but
for some reason beyond all who have suggested various ideas none seem to
work.
Will try the validate false and see if that does anything even though I
stripped out all validation rules for now.
Thanks,
Dave
From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
Of crush
Sent: Thursday, February 07, 2013 4:36 AM
To: cake-php@googlegroups.com
Subject: Re: Can not save two fields
Make sure you delete the model caches, debug level 1 and maybe reload apache
to force it to recheck the DB and see the new fields. That's gotten me a few
times when it just wouldn't save something.
Also, just in case, you can do a $this->Model->save($this->request->data,
array('validate'=>false) ); to make sure the validation is still not a
problem.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
Re: Can not save two fields
Make sure you delete the model caches, debug level 1 and maybe reload
apache to force it to recheck the DB and see the new fields. That's gotten
me a few times when it just wouldn't save something.
Also, just in case, you can do a $this->Model->save($this->request->data,
array('validate'=>false)); to make sure the validation is still not a
problem.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
RE: Can not save two fields
BEGIN110 3INSERT INTO ` master`.`orders` (`first_name`, `last_name`,
`email`, `phone`, `billing_address`, `billing_address2`, `billing_city`,
`billing_state`, `billing_zip`, `billing_country`, `shipping_address`,
`shipping_address2`, `shipping_city`, `shipping_state`, `shipping_zip`,
`shipping_country`, `order_type`, `order_item_count`, `weight`, `subtotal`,
`total`, `status`, `user_id`, `modified`, `created`, `id`) VALUES ('dave',
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'creditcard', 1,
'0.50', 29.99, 29.99, '1', '511358cd-6f84-4762-bfee-553ac09b532a',
'2013-02-06 23:33:39', '2013-02-06 23:33:39',
'511358d3-7dc4-4f6e-8736-553ac09b532a')111 4INSERT INTO `
master`.`order_items` (`product_id`, `name`, `weight`, `price`, `quantity`,
`subtotal`, `order_id`, `modified`, `created`, `id`) VALUES
('5111f132-03dc-403b-99c4-357ac09b532a', 'Demo Product One', '0.50', 29.99,
1, 29.99, '511358d3-7dc4-4f6e-8736-553ac09b532a', '2013-02-06 23:33:39',
'2013-02-06 23:33:39', '511358d3-4980-4e50-81a6-553ac09b532a')110 5COMMIT
If does not try to insert and values for those 2 fields.
Even manually tried a saveField after the initial Save()
$this->Product->Order->id = $this->Product->Order->getLastInsertID();
$this->Product->Order->saveField('trans-x', 'sgsdfsfsdf');
From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
Of david.s...@gmail.com
Sent: Thursday, February 07, 2013 3:18 AM
To: cake-php@googlegroups.com
Subject: Re: Can not save two fields
What is the SQL that is generated from the save function?
Do you have a debugging environment set up so you can step through the code?
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
Re: Can not save two fields
What is the SQL that is generated from the save function? Do you have a debugging environment set up so you can step through the code? -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: Can not save two fields
Can you show the entire data array that's being saved...
Jeremy Burns
Class Outfit
http://www.classoutfit.com
On 7 Feb 2013, at 03:52:15, "Advantage+" wrote:
> These 2 fields are unique to the site so they are nowhere else if that is
> what you mean.
> And all the other fields for the relations get saved.
>
> It just does not want to pay any attention to these new fields.
>
>
> From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
> Of Jeremy Burns | Class Outfit
> Sent: Thursday, February 07, 2013 12:19 AM
> To: cake-php@googlegroups.com
> Subject: Re: Can not save two fields
>
> Do you have all the required joining fields in your array when you are saving
> it - in other words, can Cake determine where and how to save it?
>
> Jeremy Burns
> Class Outfit
>
> http://www.classoutfit.com
>
> On 7 Feb 2013, at 03:27:55, "Advantage+" wrote:
>
>
> I tried changing the Varchars(255), CHAR(36) all kinds. No index set on
> either field, null, not null and even when set to NN the record saves,
> thinking it should at least fail there since it must have some value….no?
>
> Even tried with the fields set to CHAR(36) and:
>
> $order['Order']['transaction'] = String::uuid();
> $order['Order']['correlation'] = String::uuid();
>
> If just has no time for these 2 fields L
>
> From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
> Of Jeremy Burns | Class Outfit
> Sent: Wednesday, February 06, 2013 11:53 PM
> To: cake-php@googlegroups.com
> Subject: Re: Can not save two fields
>
> Although it's not failing Cake's validation is it breaking any database rules
> or unique indexes?
>
> Jeremy Burns
> Class Outfit
>
> http://www.classoutfit.com
>
> On 7 Feb 2013, at 03:18:43, "Advantage+" wrote:
>
>
>
> I am stumped why 2 fields in my db refuse to save any data.
>
>
> Inside my save()
>
> if( $process['ACK'] == 'Success'){
> //debug($process);
>
>
> $order['Order']['transaction'] = $process['TRANSACTIONID'];
> $order['Order']['correlation'] = $process['CORRELATIONID'];
>
>
>
>
> //debug($order);
> //die();
>
>
>
>
> $save = $this->Product->Order->saveAssociated($order);
> //$save = $this->Product->Order->saveAll($order);
>
>
> No matter what it will not save these two fields, transaction and
> correlation. I have removed all validation, all the other fields save.
>
> Debug shows
> array(
> 'TIMESTAMP' => '2013-02-07T03:14:09Z',
> 'CORRELATIONID' => '33ad86af8f701',
> 'ACK' => 'Success',
> 'VERSION' => '95',
> 'BUILD' => '5060305',
> 'AMT' => '179.95',
> 'CURRENCYCODE' => 'USD',
> 'AVSCODE' => 'X',
> 'CVV2MATCH' => 'M',
> 'TRANSACTIONID' => '35U47260N8975103S'
> )
>
>
> and
>
> 'Order' => array(
> …….
> 'user_id' =>
> '51131bfc-9208-4253-a0cb-2691c09b532a',
> 'transaction' => '35U47260N8975103S',
> 'correlation' => '33ad86af8f701'
> )
>
> Seems so simple that its just crazy!
>
> Any ideas?
>
> Dave
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from i
RE: Can not save two fields
These 2 fields are unique to the site so they are nowhere else if that is
what you mean.
And all the other fields for the relations get saved.
It just does not want to pay any attention to these new fields.
From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
Of Jeremy Burns | Class Outfit
Sent: Thursday, February 07, 2013 12:19 AM
To: cake-php@googlegroups.com
Subject: Re: Can not save two fields
Do you have all the required joining fields in your array when you are
saving it - in other words, can Cake determine where and how to save it?
Jeremy Burns
Class Outfit
http://www.classoutfit.com
On 7 Feb 2013, at 03:27:55, "Advantage+" wrote:
I tried changing the Varchars(255), CHAR(36) all kinds. No index set on
either field, null, not null and even when set to NN the record saves,
thinking it should at least fail there since it must have some value..no?
Even tried with the fields set to CHAR(36) and:
$order['Order']['transaction'] = String::uuid();
$order['Order']['correlation'] = String::uuid();
If just has no time for these 2 fields L
From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
Of Jeremy Burns | Class Outfit
Sent: Wednesday, February 06, 2013 11:53 PM
To: cake-php@googlegroups.com
Subject: Re: Can not save two fields
Although it's not failing Cake's validation is it breaking any database
rules or unique indexes?
Jeremy Burns
Class Outfit
<http://www.classoutfit.com> http://www.classoutfit.com
On 7 Feb 2013, at 03:18:43, "Advantage+" < <mailto:movepix...@gmail.com>
movepix...@gmail.com> wrote:
I am stumped why 2 fields in my db refuse to save any data.
Inside my save()
if( $process['ACK'] == 'Success'){
//debug($process);
$order['Order']['transaction'] = $process['TRANSACTIONID'];
$order['Order']['correlation'] = $process['CORRELATIONID'];
//debug($order);
//die();
$save = $this->Product->Order->saveAssociated($order);
//$save = $this->Product->Order->saveAll($order);
No matter what it will not save these two fields, transaction and
correlation. I have removed all validation, all the other fields save.
Debug shows
array(
'TIMESTAMP' => '2013-02-07T03:14:09Z',
'CORRELATIONID' => '33ad86af8f701',
'ACK' => 'Success',
'VERSION' => '95',
'BUILD' => '5060305',
'AMT' => '179.95',
'CURRENCYCODE' => 'USD',
'AVSCODE' => 'X',
'CVV2MATCH' => 'M',
'TRANSACTIONID' => '35U47260N8975103S'
)
and
'Order' => array(
...
'user_id' =>
'51131bfc-9208-4253-a0cb-2691c09b532a',
'transaction' =>
'35U47260N8975103S',
'correlation' => '33ad86af8f701'
)
Seems so simple that its just crazy!
Any ideas?
Dave
--
Like Us on FaceBook <https://www.facebook.com/CakePHP>
https://www.facebook.com/CakePHP
Find us on Twitter <http://twitter.com/CakePHP> http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to <mailto:cake-php+unsubscr...@googlegroups.com>
cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to <mailto:cake-php@googlegroups.com>
cake-php@googlegroups.com.
Visit this group at <http://groups.google.com/group/cake-php?hl=en>
http://groups.google.com/group/cake-php?hl=en.
For more options, visit <https://groups.google.com/groups/opt_out>
https://groups.google.com/groups/opt_out.
--
Like Us on FaceBook <https://www.facebook.com/CakePHP>
https://www.facebook.com/CakePHP
Find us on Twitter <http://twitter.com/CakePHP> http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to <mailto:cake-php+unsubscr...@googlegroups.com>
cake-php+unsubscr...@googlegroups.com.
To post to
Re: Can not save two fields
Do you have all the required joining fields in your array when you are saving
it - in other words, can Cake determine where and how to save it?
Jeremy Burns
Class Outfit
http://www.classoutfit.com
On 7 Feb 2013, at 03:27:55, "Advantage+" wrote:
> I tried changing the Varchars(255), CHAR(36) all kinds. No index set on
> either field, null, not null and even when set to NN the record saves,
> thinking it should at least fail there since it must have some value….no?
>
> Even tried with the fields set to CHAR(36) and:
>
> $order['Order']['transaction'] = String::uuid();
> $order['Order']['correlation'] = String::uuid();
>
> If just has no time for these 2 fields L
>
> From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
> Of Jeremy Burns | Class Outfit
> Sent: Wednesday, February 06, 2013 11:53 PM
> To: cake-php@googlegroups.com
> Subject: Re: Can not save two fields
>
> Although it's not failing Cake's validation is it breaking any database rules
> or unique indexes?
>
> Jeremy Burns
> Class Outfit
>
> http://www.classoutfit.com
>
> On 7 Feb 2013, at 03:18:43, "Advantage+" wrote:
>
>
> I am stumped why 2 fields in my db refuse to save any data.
>
>
> Inside my save()
>
> if( $process['ACK'] == 'Success'){
> //debug($process);
>
>
> $order['Order']['transaction'] = $process['TRANSACTIONID'];
> $order['Order']['correlation'] = $process['CORRELATIONID'];
>
>
>
>
> //debug($order);
> //die();
>
>
>
>
> $save = $this->Product->Order->saveAssociated($order);
> //$save = $this->Product->Order->saveAll($order);
>
>
> No matter what it will not save these two fields, transaction and
> correlation. I have removed all validation, all the other fields save.
>
> Debug shows
> array(
> 'TIMESTAMP' => '2013-02-07T03:14:09Z',
> 'CORRELATIONID' => '33ad86af8f701',
> 'ACK' => 'Success',
> 'VERSION' => '95',
> 'BUILD' => '5060305',
> 'AMT' => '179.95',
> 'CURRENCYCODE' => 'USD',
> 'AVSCODE' => 'X',
> 'CVV2MATCH' => 'M',
> 'TRANSACTIONID' => '35U47260N8975103S'
> )
>
>
> and
>
> 'Order' => array(
> …….
> 'user_id' =>
> '51131bfc-9208-4253-a0cb-2691c09b532a',
> 'transaction' => '35U47260N8975103S',
> 'correlation' => '33ad86af8f701'
> )
>
> Seems so simple that its just crazy!
>
> Any ideas?
>
> Dave
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
&g
RE: Can not save two fields
I tried changing the Varchars(255), CHAR(36) all kinds. No index set on
either field, null, not null and even when set to NN the record saves,
thinking it should at least fail there since it must have some value..no?
Even tried with the fields set to CHAR(36) and:
$order['Order']['transaction'] = String::uuid();
$order['Order']['correlation'] = String::uuid();
If just has no time for these 2 fields L
From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf
Of Jeremy Burns | Class Outfit
Sent: Wednesday, February 06, 2013 11:53 PM
To: cake-php@googlegroups.com
Subject: Re: Can not save two fields
Although it's not failing Cake's validation is it breaking any database
rules or unique indexes?
Jeremy Burns
Class Outfit
http://www.classoutfit.com
On 7 Feb 2013, at 03:18:43, "Advantage+" wrote:
I am stumped why 2 fields in my db refuse to save any data.
Inside my save()
if( $process['ACK'] == 'Success'){
//debug($process);
$order['Order']['transaction'] = $process['TRANSACTIONID'];
$order['Order']['correlation'] = $process['CORRELATIONID'];
//debug($order);
//die();
$save = $this->Product->Order->saveAssociated($order);
//$save = $this->Product->Order->saveAll($order);
No matter what it will not save these two fields, transaction and
correlation. I have removed all validation, all the other fields save.
Debug shows
array(
'TIMESTAMP' => '2013-02-07T03:14:09Z',
'CORRELATIONID' => '33ad86af8f701',
'ACK' => 'Success',
'VERSION' => '95',
'BUILD' => '5060305',
'AMT' => '179.95',
'CURRENCYCODE' => 'USD',
'AVSCODE' => 'X',
'CVV2MATCH' => 'M',
'TRANSACTIONID' => '35U47260N8975103S'
)
and
'Order' => array(
...
'user_id' =>
'51131bfc-9208-4253-a0cb-2691c09b532a',
'transaction' =>
'35U47260N8975103S',
'correlation' => '33ad86af8f701'
)
Seems so simple that its just crazy!
Any ideas?
Dave
--
Like Us on FaceBook <https://www.facebook.com/CakePHP>
https://www.facebook.com/CakePHP
Find us on Twitter <http://twitter.com/CakePHP> http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to <mailto:cake-php+unsubscr...@googlegroups.com>
cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to <mailto:cake-php@googlegroups.com>
cake-php@googlegroups.com.
Visit this group at <http://groups.google.com/group/cake-php?hl=en>
http://groups.google.com/group/cake-php?hl=en.
For more options, visit <https://groups.google.com/groups/opt_out>
https://groups.google.com/groups/opt_out.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
Re: Can not save two fields
Although it's not failing Cake's validation is it breaking any database rules
or unique indexes?
Jeremy Burns
Class Outfit
http://www.classoutfit.com
On 7 Feb 2013, at 03:18:43, "Advantage+" wrote:
> I am stumped why 2 fields in my db refuse to save any data.
>
>
> Inside my save()
>
> if( $process['ACK'] == 'Success'){
> //debug($process);
>
>
> $order['Order']['transaction'] = $process['TRANSACTIONID'];
> $order['Order']['correlation'] = $process['CORRELATIONID'];
>
>
>
>
> //debug($order);
> //die();
>
>
>
>
> $save = $this->Product->Order->saveAssociated($order);
> //$save = $this->Product->Order->saveAll($order);
>
>
> No matter what it will not save these two fields, transaction and
> correlation. I have removed all validation, all the other fields save.
>
> Debug shows
> array(
> 'TIMESTAMP' => '2013-02-07T03:14:09Z',
> 'CORRELATIONID' => '33ad86af8f701',
> 'ACK' => 'Success',
> 'VERSION' => '95',
> 'BUILD' => '5060305',
> 'AMT' => '179.95',
> 'CURRENCYCODE' => 'USD',
> 'AVSCODE' => 'X',
> 'CVV2MATCH' => 'M',
> 'TRANSACTIONID' => '35U47260N8975103S'
> )
>
>
> and
>
> 'Order' => array(
> …….
> 'user_id' =>
> '51131bfc-9208-4253-a0cb-2691c09b532a',
> 'transaction' => '35U47260N8975103S',
> 'correlation' => '33ad86af8f701'
> )
>
> Seems so simple that its just crazy!
>
> Any ideas?
>
> Dave
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
