OFBiz › OFBiz - User

Difference between One page checkout and Quick checkout

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 5 messages Options
Winster
Reply | Threaded
Open this post in threaded view
♦
♦
|

Difference between One page checkout and Quick checkout

Winster
Hi,

Are there any differences between "One page" and "Quick" checkouts?

I am getting an exception for "one page checkout" as follows while "quick
checkout" works correctly.

The Following Errors Occurred:

Did not complete the order, the following occurred:ERROR : Could not create
order (write error :Error while inserting:
[GenericEntity:OrderContactMech][contactMechId,10034(java.lang.String)][contactMechPurposeTypeId,PHONE_BILLING(java.lang.String)][createdStamp,2013-01-08
15:26:05.636(java.sql.Timestamp)][createdTxStamp,2013-01-08
15:26:05.569(java.sql.Timestamp)][lastUpdatedStamp,2013-01-08
15:26:05.636(java.sql.Timestamp)][lastUpdatedTxStamp,2013-01-08
15:26:05.569(java.sql.Timestamp)][orderId,WS10024(java.lang.String)] (SQL
Exception while executing the following:INSERT INTO ORDER_CONTACT_MECH
(ORDER_ID, CONTACT_MECH_PURPOSE_TYPE_ID, CONTACT_MECH_ID,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
key constraint fails (`ofbiz`.`ORDER_CONTACT_MECH`, CONSTRAINT
`ORDER_CMECH_CM` FOREIGN KEY (`CONTACT_MECH_ID`) REFERENCES `CONTACT_MECH`
(`CONTACT_MECH_ID`))))).


I went through "CheckOutHelper-createOrder" method. What I understand is
that, all Email address against the user will be fetched and stored as
"OrderContactMechanism". I have email address configured for "order
confirmation" and "primary" purposes.

What would have gone wrong here?

Thanks in advance
Winster T Jose
Director - Technology and Architecture
Chathurangam Creative Solutions Private Ltd.
Cell: +91-98469 31020
Mail: [hidden email]
Jacques Le Roux
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Difference between One page checkout and Quick checkout

Jacques Le Roux
Administrator
Can you reproduce on the demo server?

Jacques

From: "Winster Jose" <[hidden email]>

> Hi,
>
> Are there any differences between "One page" and "Quick" checkouts?
>
> I am getting an exception for "one page checkout" as follows while "quick
> checkout" works correctly.
>
> The Following Errors Occurred:
>
> Did not complete the order, the following occurred:ERROR : Could not create
> order (write error :Error while inserting:
> [GenericEntity:OrderContactMech][contactMechId,10034(java.lang.String)][contactMechPurposeTypeId,PHONE_BILLING(java.lang.String)][createdStamp,2013-01-08
> 15:26:05.636(java.sql.Timestamp)][createdTxStamp,2013-01-08
> 15:26:05.569(java.sql.Timestamp)][lastUpdatedStamp,2013-01-08
> 15:26:05.636(java.sql.Timestamp)][lastUpdatedTxStamp,2013-01-08
> 15:26:05.569(java.sql.Timestamp)][orderId,WS10024(java.lang.String)] (SQL
> Exception while executing the following:INSERT INTO ORDER_CONTACT_MECH
> (ORDER_ID, CONTACT_MECH_PURPOSE_TYPE_ID, CONTACT_MECH_ID,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
> key constraint fails (`ofbiz`.`ORDER_CONTACT_MECH`, CONSTRAINT
> `ORDER_CMECH_CM` FOREIGN KEY (`CONTACT_MECH_ID`) REFERENCES `CONTACT_MECH`
> (`CONTACT_MECH_ID`))))).
>
>
> I went through "CheckOutHelper-createOrder" method. What I understand is
> that, all Email address against the user will be fetched and stored as
> "OrderContactMechanism". I have email address configured for "order
> confirmation" and "primary" purposes.
>
> What would have gone wrong here?
>
> Thanks in advance
> Winster T Jose
> Director - Technology and Architecture
> Chathurangam Creative Solutions Private Ltd.
> Cell: +91-98469 31020
> Mail: [hidden email]
>
Atul Vani
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Difference between One page checkout and Quick checkout

Atul Vani
In reply to this post by Winster
Well, I am not even able to go to the third step on demo-trunk. Will work  
on the fix some time soon.

On Wed, 09 Jan 2013 10:27:08 +0530, Jacques Le Roux  
<[hidden email]> wrote:

> Can you reproduce on the demo server?
>
> Jacques
>
> From: "Winster Jose" <[hidden email]>
>> Hi,
>>
>> Are there any differences between "One page" and "Quick" checkouts?
>>
>> I am getting an exception for "one page checkout" as follows while  
>> "quick
>> checkout" works correctly.
>>
>> The Following Errors Occurred:
>>
>> Did not complete the order, the following occurred:ERROR : Could not  
>> create
>> order (write error :Error while inserting:
>> [GenericEntity:OrderContactMech][contactMechId,10034(java.lang.String)][contactMechPurposeTypeId,PHONE_BILLING(java.lang.String)][createdStamp,2013-01-08
>> 15:26:05.636(java.sql.Timestamp)][createdTxStamp,2013-01-08
>> 15:26:05.569(java.sql.Timestamp)][lastUpdatedStamp,2013-01-08
>> 15:26:05.636(java.sql.Timestamp)][lastUpdatedTxStamp,2013-01-08
>> 15:26:05.569(java.sql.Timestamp)][orderId,WS10024(java.lang.String)]  
>> (SQL
>> Exception while executing the following:INSERT INTO ORDER_CONTACT_MECH
>> (ORDER_ID, CONTACT_MECH_PURPOSE_TYPE_ID, CONTACT_MECH_ID,
>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,  
>> CREATED_TX_STAMP)
>> VALUES (?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a  
>> foreign
>> key constraint fails (`ofbiz`.`ORDER_CONTACT_MECH`, CONSTRAINT
>> `ORDER_CMECH_CM` FOREIGN KEY (`CONTACT_MECH_ID`) REFERENCES  
>> `CONTACT_MECH`
>> (`CONTACT_MECH_ID`))))).
>>
>>
>> I went through "CheckOutHelper-createOrder" method. What I understand is
>> that, all Email address against the user will be fetched and stored as
>> "OrderContactMechanism". I have email address configured for "order
>> confirmation" and "primary" purposes.
>>
>> What would have gone wrong here?
>>
>> Thanks in advance
>> Winster T Jose
>> Director - Technology and Architecture
>> Chathurangam Creative Solutions Private Ltd.
>> Cell: +91-98469 31020
>> Mail: [hidden email]
>>


--
Using Opera's revolutionary email client: http://www.opera.com/mail/
Winster
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Difference between One page checkout and Quick checkout

Winster
Okay. I am working on Ofbiz 11.04. When comparing screens for Quick
checkout and One page checkout, I found that "Payment method selection" is
missing in One page checkout.
I compared "checkoutoptions.ftl" and "OnePageCheckoutProcess.ftl" and
confirmed it. Am I missing anything?



On Wed, Jan 9, 2013 at 10:50 AM, Atul Vani <[hidden email]>wrote:

> Well, I am not even able to go to the third step on demo-trunk. Will work
> on the fix some time soon.
>
>
> On Wed, 09 Jan 2013 10:27:08 +0530, Jacques Le Roux <
> [hidden email]> wrote:
>
>  Can you reproduce on the demo server?
>>
>> Jacques
>>
>> From: "Winster Jose" <[hidden email]>
>>
>>> Hi,
>>>
>>> Are there any differences between "One page" and "Quick" checkouts?
>>>
>>> I am getting an exception for "one page checkout" as follows while "quick
>>> checkout" works correctly.
>>>
>>> The Following Errors Occurred:
>>>
>>> Did not complete the order, the following occurred:ERROR : Could not
>>> create
>>> order (write error :Error while inserting:
>>> [GenericEntity:**OrderContactMech][**contactMechId,10034(java.lang.**
>>> String)][**contactMechPurposeTypeId,**PHONE_BILLING(java.lang.**
>>> String)][createdStamp,2013-01-**08
>>> 15:26:05.636(java.sql.**Timestamp)][createdTxStamp,**2013-01-08
>>> 15:26:05.569(java.sql.**Timestamp)][lastUpdatedStamp,**2013-01-08
>>> 15:26:05.636(java.sql.**Timestamp)][**lastUpdatedTxStamp,2013-01-08
>>> 15:26:05.569(java.sql.**Timestamp)][orderId,WS10024(**java.lang.String)]
>>> (SQL
>>> Exception while executing the following:INSERT INTO ORDER_CONTACT_MECH
>>> (ORDER_ID, CONTACT_MECH_PURPOSE_TYPE_ID, CONTACT_MECH_ID,
>>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
>>> CREATED_TX_STAMP)
>>> VALUES (?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign
>>> key constraint fails (`ofbiz`.`ORDER_CONTACT_MECH`, CONSTRAINT
>>> `ORDER_CMECH_CM` FOREIGN KEY (`CONTACT_MECH_ID`) REFERENCES
>>> `CONTACT_MECH`
>>> (`CONTACT_MECH_ID`))))).
>>>
>>>
>>> I went through "CheckOutHelper-createOrder" method. What I understand is
>>> that, all Email address against the user will be fetched and stored as
>>> "OrderContactMechanism". I have email address configured for "order
>>> confirmation" and "primary" purposes.
>>>
>>> What would have gone wrong here?
>>>
>>> Thanks in advance
>>> Winster T Jose
>>> Director - Technology and Architecture
>>> Chathurangam Creative Solutions Private Ltd.
>>> Cell: +91-98469 31020
>>> Mail: [hidden email]
>>>
>>>
>
> --
> Using Opera's revolutionary email client: http://www.opera.com/mail/
>



--
Winster T Jose
Director - Technology and Architecture
Chathurangam Creative Solutions Private Ltd.
Cell: +91-98469 31020
Mail: [hidden email]
Atul Vani
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Difference between One page checkout and Quick checkout

Atul Vani
One page checkout on 1104 is working fine for me.

On Wed, 09 Jan 2013 11:37:02 +0530, Winster Jose  
<[hidden email]> wrote:

> Okay. I am working on Ofbiz 11.04. When comparing screens for Quick
> checkout and One page checkout, I found that "Payment method selection"  
> is
> missing in One page checkout.
> I compared "checkoutoptions.ftl" and "OnePageCheckoutProcess.ftl" and
> confirmed it. Am I missing anything?
>
>
>
> On Wed, Jan 9, 2013 at 10:50 AM, Atul Vani  
> <[hidden email]>wrote:
>
>> Well, I am not even able to go to the third step on demo-trunk. Will  
>> work
>> on the fix some time soon.
>>
>>
>> On Wed, 09 Jan 2013 10:27:08 +0530, Jacques Le Roux <
>> [hidden email]> wrote:
>>
>>  Can you reproduce on the demo server?
>>>
>>> Jacques
>>>
>>> From: "Winster Jose" <[hidden email]>
>>>
>>>> Hi,
>>>>
>>>> Are there any differences between "One page" and "Quick" checkouts?
>>>>
>>>> I am getting an exception for "one page checkout" as follows while  
>>>> "quick
>>>> checkout" works correctly.
>>>>
>>>> The Following Errors Occurred:
>>>>
>>>> Did not complete the order, the following occurred:ERROR : Could not
>>>> create
>>>> order (write error :Error while inserting:
>>>> [GenericEntity:**OrderContactMech][**contactMechId,10034(java.lang.**
>>>> String)][**contactMechPurposeTypeId,**PHONE_BILLING(java.lang.**
>>>> String)][createdStamp,2013-01-**08
>>>> 15:26:05.636(java.sql.**Timestamp)][createdTxStamp,**2013-01-08
>>>> 15:26:05.569(java.sql.**Timestamp)][lastUpdatedStamp,**2013-01-08
>>>> 15:26:05.636(java.sql.**Timestamp)][**lastUpdatedTxStamp,2013-01-08
>>>> 15:26:05.569(java.sql.**Timestamp)][orderId,WS10024(**java.lang.String)]
>>>> (SQL
>>>> Exception while executing the following:INSERT INTO ORDER_CONTACT_MECH
>>>> (ORDER_ID, CONTACT_MECH_PURPOSE_TYPE_ID, CONTACT_MECH_ID,
>>>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
>>>> CREATED_TX_STAMP)
>>>> VALUES (?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a  
>>>> foreign
>>>> key constraint fails (`ofbiz`.`ORDER_CONTACT_MECH`, CONSTRAINT
>>>> `ORDER_CMECH_CM` FOREIGN KEY (`CONTACT_MECH_ID`) REFERENCES
>>>> `CONTACT_MECH`
>>>> (`CONTACT_MECH_ID`))))).
>>>>
>>>>
>>>> I went through "CheckOutHelper-createOrder" method. What I understand  
>>>> is
>>>> that, all Email address against the user will be fetched and stored as
>>>> "OrderContactMechanism". I have email address configured for "order
>>>> confirmation" and "primary" purposes.
>>>>
>>>> What would have gone wrong here?
>>>>
>>>> Thanks in advance
>>>> Winster T Jose
>>>> Director - Technology and Architecture
>>>> Chathurangam Creative Solutions Private Ltd.
>>>> Cell: +91-98469 31020
>>>> Mail: [hidden email]
>>>>
>>>>
>>
>> --
>> Using Opera's revolutionary email client: http://www.opera.com/mail/
>>
>
>
>


--
Using Opera's revolutionary email client: http://www.opera.com/mail/
Free forum by Nabble Edit this page