[ 
https://issues.apache.org/jira/browse/OFBIZ-1462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12623697#action_12623697
 ] 

Jacques Le Roux commented on OFBIZ-1462:
----------------------------------------

Just tested with 
Country = France
State = No States/Provinces exists

I get this error 

2008-08-19 16:42:45,828 (http-0.0.0.0-18443-2) [   
GenericDelegator.java:768:ERROR]
---- exception report ----------------------------------------------------------
Failure in create operation for entity [PostalAddress]: 
org.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:PostalAddress][address1,2004 Factory 
Blvd(java.lang.String)][address2,nul
l()][city,Orem(java.lang.String)][contactMechId,10012(java.lang.String)][countryGeoId,FRA(java.lang.String)][createdStamp,2008-08-19
 16:42:45.765(java.sql.Timestamp)][createdTxStamp,2008-08-19 16:42:45.531(ja
va.sql.Timestamp)][lastUpdatedStamp,2008-08-19 
16:42:45.765(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-19 
16:42:45.531(java.sql.Timestamp)][postalCode,34560(java.lang.String)][stateProvinceGeoId,undefine
d(java.lang.String)] (SQL Exception while executing the following:INSERT INTO 
public.POSTAL_ADDRESS (CONTACT_MECH_ID, TO_NAME, ATTN_NAME, ADDRESS1, ADDRESS2, 
DIRECTIONS, CITY, POSTAL_CODE, POSTAL_CODE_EXT, CO
UNTRY_GEO_ID, STATE_PROVINCE_GEO_ID, COUNTY_GEO_ID, POSTAL_CODE_GEO_ID, 
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (
ERREUR: une instruction insert ou update sur la table ? postal_address ? viole 
la contrainte de cl?
?trang?re ? post_addr_spgeo ?
  Detail: La cl? (state_province_geo_id)=(undefined) n'est pas pr?sente dans la 
table ? geo ?.)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Error while inserting: [GenericEntity:PostalAddress][address1,2004 
Factory 
Blvd(java.lang.String)][address2,null()][city,Orem(java.lang.String)][contactMechId,10012(java.lang.String)][countryGeoId,FR
A(java.lang.String)][createdStamp,2008-08-19 
16:42:45.765(java.sql.Timestamp)][createdTxStamp,2008-08-19 
16:42:45.531(java.sql.Timestamp)][lastUpdatedStamp,2008-08-19 
16:42:45.765(java.sql.Timestamp)][lastUpd
atedTxStamp,2008-08-19 
16:42:45.531(java.sql.Timestamp)][postalCode,34560(java.lang.String)][stateProvinceGeoId,undefined(java.lang.String)]
 (SQL Exception while executing the following:INSERT INTO public.POS
TAL_ADDRESS (CONTACT_MECH_ID, TO_NAME, ATTN_NAME, ADDRESS1, ADDRESS2, 
DIRECTIONS, CITY, POSTAL_CODE, POSTAL_CODE_EXT, COUNTRY_GEO_ID, 
STATE_PROVINCE_GEO_ID, COUNTY_GEO_ID, POSTAL_CODE_GEO_ID, LAST_UPDATED_STA
MP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERREUR: une instruction insert ou 
update sur la table ? postal_address ? viole la contra
inte de cl?
?trang?re ? post_addr_spgeo ?
  Detail: La cl? (state_province_geo_id)=(undefined) n'est pas pr?sente dans la 
table ? geo ?.))
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:PostalAddress][address1,2004 Factory 
Blvd(java.lang.String)][address2,null()][city,Orem(java.lang.String)][contactMechId,10012(ja
va.lang.String)][countryGeoId,FRA(java.lang.String)][createdStamp,2008-08-19 
16:42:45.765(java.sql.Timestamp)][createdTxStamp,2008-08-19 
16:42:45.531(java.sql.Timestamp)][lastUpdatedStamp,2008-08-19 16:42:45.
765(java.sql.Timestamp)][lastUpdatedTxStamp,2008-08-19 
16:42:45.531(java.sql.Timestamp)][postalCode,34560(java.lang.String)][stateProvinceGeoId,undefined(java.lang.String)]
 (SQL Exception while executing the
following:INSERT INTO public.POSTAL_ADDRESS (CONTACT_MECH_ID, TO_NAME, 
ATTN_NAME, ADDRESS1, ADDRESS2, DIRECTIONS, CITY, POSTAL_CODE, POSTAL_CODE_EXT, 
COUNTRY_GEO_ID, STATE_PROVINCE_GEO_ID, COUNTY_GEO_ID, POST
AL_CODE_GEO_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, 
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 
(ERREUR: une instruction insert ou update sur la table ?
postal_address ? viole la contrainte de cl?
?trang?re ? post_addr_spgeo ?
  Detail: La cl? (state_province_geo_id)=(undefined) n'est pas pr?sente dans la 
table ? geo ?.))

Which means that the state_province_geo_id  undefined does not exist in Entity 
Geo...

> One Page Checkout Process implemented in ecommerce
> --------------------------------------------------
>
>                 Key: OFBIZ-1462
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1462
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: ecommerce
>            Reporter: Pankaj Savita
>            Assignee: Vikas Mayur
>            Priority: Minor
>         Attachments: Ecommerce_OnePage_CheckoutProcess.patch, 
> Ecommerce_OnePage_CheckoutProcess.patch, OnePageCheckoutFtl.png, 
> onePageCheckoutUiEnhancement.patch
>
>
> Here it is, the One Page Checkout Process implemented in ecommerce.
> The work remained in this: 
> 1) Processing Gift Card , PO number. & also
> 2) Some UI related work.
> Done By :
> Anurag Meshram (Team Leader)
> Pankaj Savita (Team Member)
> UI design is based on Original work by   "Ryan Foster <[EMAIL PROTECTED]>"

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to