PHP: RE: Can not save two fields

Nope.

Nothing even remotely close.

From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf Of Jeremy Burns | Class Outfit
Sent: Thursday, February 07, 2013 12:49 AM
To: cake-php@googlegroups.com
Subject: Re: Can not save two fields

Long shot, but do you by any chance have models called transaction and/or correlation?

Jeremy Burns

Class Outfit

http://www.classoutfit.com

On 7 Feb 2013, at 04:05:02, "Advantage+" <movepixels@gmail.com> wrote:

/app/Controller/ShopController.php (line 307)

array(

'OrderItem' => array(

'5111f132-03dc-403b-99c4-357ac09b532a' => array(

'product_id' => '5111f132-03dc-403b-99c4-357ac09b532a',

'image' => '/img/uploads/products/a8716ec2421fb471bbab1bdce98a30ad.jpg',

'name' => 'Demo Product One',

'weight' => '0.50',

'price' => '29.99',

'quantity' => (int) 2,

'subtotal' => '59.98',

'totalweight' => '1.00',

'5111f167-e268-4829-8aa6-08c1c09b532a' => array(

'product_id' => '5111f167-e268-4829-8aa6-08c1c09b532a',

'image' => '/img/uploads/products/c303820d98bacda0e7993a9d6d46f968.jpg',

'name' => 'Demo Product Two',

'weight' => '2.00',

'price' => '39.99',

'quantity' => (int) 3,

'subtotal' => '119.97',

'totalweight' => '6.00'

)

'Order' => array(

'first_name' => 'Dave',

'last_name' => 'Something',

'email' => 'me@home.here',

'phone' => '888-888-8888',

'billing_address' => '123 King',

'billing_address2' => '',

'billing_city' => 'City',

'billing_state' => 'CA',

'billing_zip' => '12345',

'billing_country' => 'US',

'sameaddress' => '1',

'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) 5,

'weight' => '7.00',

'subtotal' => '179.95',

'total' => '179.95',

'shop' => (int) 1,

'status' => (int) 1,

'user_id' => '511326fb-a0ac-43cd-81b1-357ac09b532a',

'transaction' => '51L03443PX415533H',

'correlation' => 'ae3ff3824f582'

)

From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On Behalf Of Jeremy Burns | Class Outfit
Sent: Thursday, February 07, 2013 12:28 AM
To: cake-php@googlegroups.com
Subject: 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+" <movepixels@gmail.com> 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+" <movepixels@gmail.com> 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+" <movepixels@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
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+unsubscribe@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.

PHP

Wednesday, February 6, 2013

RE: Can not save two fields

No comments:

Blog Archive

About Me