Done! https://issues.apache.org/jira/browse/OFBIZ-1697
2008/3/7, Jacques Le Roux <[EMAIL PROTECTED]>: > > Could you please open a Jira issue for this ? > > TIA > > Jacques > > From: "Bruno Busco" <[EMAIL PROTECTED]> > > > You are right, i apologize for having confused the troubleshooting. > > > > But still playing with the page of the Shopping List I have found that > if I > > enter an invalid product code in the text box of the "Quick Add to > shopping > > list" and press the "Add to Shopping List" button an unformatted error > > string is displayed as follow: > > > > The Following Errors Occurred: > > > > ERROR: Could not complete the Create a ShoppingList Item > > > [file:/opt/j2ee/domains/hotwaxmedia.com/demo/deployments/demo.hotwaxmedia.com/applications/order/script/org/ofbiz/order/shoppinglist/ShoppingListServices.xml#createShoppingListItem] > > process [problem creating the newEntity value: Error while inserting: > > [GenericEntity:ShoppingListItem][createdStamp,2008-03-07 14:45:50.442( > > java.sql.Timestamp)][createdTxStamp,2008-03-07 14:45:50.324( > > java.sql.Timestamp)][lastUpdatedStamp,2008-03-07 14:45:50.442( > > java.sql.Timestamp)][lastUpdatedTxStamp,2008-03-07 14:45:50.324( > > java.sql.Timestamp)][productId,qqq(java.lang.String)][quantity,1.0( > > java.lang.Double)][shoppingListId,10001(java.lang.String > > )][shoppingListItemSeqId,00004(java.lang.String)] (SQL Exception while > > executing the following:INSERT INTO > > OFBIZ.SHOPPING_LIST_ITEM(SHOPPING_LIST_ID, SHOPPING_LIST_ITEM_SEQ_ID, > > PRODUCT_ID, QUANTITY, > > RESERV_START, RESERV_LENGTH, RESERV_PERSONS, QUANTITY_PURCHASED, > CONFIG_ID, > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > CREATED_TX_STAMP) > > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table > > 'SHOPPING_LIST_ITEM' caused a violation of foreign key constraint > > 'SHLIST_ITEM_PROD' for key (qqq). The statement has been rolled back.))] > > > > > > > > 2008/3/7, BJ Freeman <[EMAIL PROTECTED]>: > >> > >> your error is different than the previous reported error. > >> I would say not all data was put in the form > >> from this part of the error. > >> > >> > >> > [in-validate] got false for condition: > >> > [shippingMethodString][is-not-empty][true][String] > >> > ServiceEcaRule.java:127:INFO ] For Service ECA > [updateShoppingList] > >> on > >> > [in-validate] got false for condition: > >> > [frequency][is-not-empty][true][String] > >> > >> > >> > >> Bruno Busco sent the following on 3/7/2008 12:20 AM: > >> > >> > Hi, > >> > i cannot save (create) a Shopping List as well. > >> > When i press the save button nothing happens. > >> > I agree with Vikas that having the revision label printed somewhere > will > >> be > >> > a of great help. > >> > I am running trunk rev. 634426 and what i get in debug.log is the > >> following: > >> > > >> > > >> > ---------------------------------------------------------------------------- > >> > CoyoteAdapter.java:403:DEBUG] Requested cookie session id is > >> > 49674BE0BDE845CB5FDCA4AF7B13D1D8.jvm1 > >> > StandardWrapper.java:804:TRACE] Returning non-STM instance > >> > ControlServlet.java:93 :INFO ] The character encoding of the > request > >> is: > >> > [null]. The character encoding we will use for the request and > response > >> is: > >> > [UTF-8] > >> > ControlServlet.java:126:DEBUG] [[[updateShoppingList] Servlet > >> Starting, > >> > doing setup- total:0.0,since last(Begin):0.0]] > >> > ControlServlet.java:185:DEBUG] [[[updateShoppingList] Setup done, > >> doing > >> > Event(s) and View(s)- total:0.0,since last([updateShoppingLi...):0.0 > ]] > >> > UtilXml.java:241:DEBUG] XML Read 0.047s: > >> > jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml > >> > ConfigXMLReader.java:564:INFO ] ConfigMap Created: (5) records in > 0.0s > >> > ConfigXMLReader.java:722:INFO ] HandlerMap Created: (4) view > handlers > >> and > >> > (7) request/event handlers in 0.0s > >> > ConfigXMLReader.java:297:INFO ] RequestMap Created: (246) records > in > >> > 0.016s > >> > ConfigXMLReader.java:391:INFO ] ViewMap Created: (89) records in > 0.0s > >> > RequestHandler.java:243:INFO ] [Processing Request]: > >> updateShoppingList > >> > sessionId=49674BE0BDE845CB5FDCA4AF7B13D1D8.jvm1 > >> > ServiceEcaRule.java:127:INFO ] For Service ECA > [updateShoppingList] > >> on > >> > [in-validate] got false for condition: > >> > [shippingMethodString][is-not-empty][true][String] > >> > ServiceEcaRule.java:127:INFO ] For Service ECA > [updateShoppingList] > >> on > >> > [in-validate] got false for condition: > >> > [frequency][is-not-empty][true][String] > >> > WebappClassLoader.java:1049:DEBUG] > >> > getResource(org/ofbiz/order/shoppinglist/ShoppingListServices.xml) > >> > WebappClassLoader.java:927:DEBUG] > >> > findResource(org/ofbiz/order/shoppinglist/ShoppingListServices.xml) > >> > WebappClassLoader.java:946:DEBUG] --> Resource not found, > returning > >> null > >> > WebappClassLoader.java:1099:DEBUG] --> Returning > >> > > >> > 'file:/F:/ofbiz/applications/order/script/org/ofbiz/order/shoppinglist/ShoppingListServices.xml' > >> > UtilXml.java:241:DEBUG] XML Read 0.031s: > >> > > >> > file:/F:/ofbiz/applications/order/script/org/ofbiz/order/shoppinglist/ShoppingListServices.xml > >> > RequestHandler.java:433:INFO ] [RequestHandler.doRequest]: > Response > >> is a > >> > view. sessionId=49674BE0BDE845CB5FDCA4AF7B13D1D8.jvm1 > >> > RequestHandler.java:584:INFO ] servletName=control, > >> view=editShoppingList > >> > sessionId=49674BE0BDE845CB5FDCA4AF7B13D1D8.jvm1 > >> > UtilXml.java:241:DEBUG] XML Read 0.0s: > >> > file:/F:/ofbiz/applications/ecommerce/widget/ShoppingListScreens.xml > >> > ScreenFactory.java:118:INFO ] Got 1 screens in 0.016s from: > >> > file:/F:/ofbiz/applications/ecommerce/widget/ShoppingListScreens.xml > >> > UtilXml.java:241:DEBUG] XML Read 0.015s: > >> > file:/F:/ofbiz/applications/ecommerce/widget/CommonScreens.xml > >> > ScreenFactory.java:118:INFO ] Got 14 screens in 0.015s from: > >> > file:/F:/ofbiz/applications/ecommerce/widget/CommonScreens.xml > >> > UtilXml.java:241:DEBUG] XML Read 0.016s: > >> > file:/F:/ofbiz/applications/ecommerce/widget/CartScreens.xml > >> > ScreenFactory.java:118:INFO ] Got 7 screens in 0.016s from: > >> > file:/F:/ofbiz/applications/ecommerce/widget/CartScreens.xml > >> > ModelScreenWidget.java:463:INFO ] In the include-screen tag the > screen > >> name > >> > was empty, ignoring include; in screen [main-decorator] > >> > UtilXml.java:241:DEBUG] XML Read 0.016s: > >> > file:/F:/ofbiz/applications/ecommerce/widget/CatalogScreens.xml > >> > ScreenFactory.java:118:INFO ] Got 26 screens in 0.016s from: > >> > file:/F:/ofbiz/applications/ecommerce/widget/CatalogScreens.xml > >> > UtilXml.java:241:DEBUG] XML Read 0.0s: > >> > file:/F:/ofbiz/applications/ecommerce/widget/ContentScreens.xml > >> > ScreenFactory.java:118:INFO ] Got 8 screens in 0.0s from: > >> > file:/F:/ofbiz/applications/ecommerce/widget/ContentScreens.xml > >> > WebappClassLoader.java:1239:DEBUG] loadClass( > >> > org.ofbiz.product.price.PriceServices, false) > >> > WebappClassLoader.java:1324:DEBUG] Searching local repositories > >> > WebappClassLoader.java:843:DEBUG] findClass( > >> > org.ofbiz.product.price.PriceServices) > >> > WebappClassLoader.java:871:TRACE] findClassInternal( > >> > org.ofbiz.product.price.PriceServices) > >> > WebappClassLoader.java:903:TRACE] --> Passing on > >> ClassNotFoundException > >> > WebappClassLoader.java:1341:DEBUG] Delegating to parent classloader > at > >> > end: org.ofbiz.base.util.CachedClassLoader(__globalContext) / > >> > [EMAIL PROTECTED] > >> > WebappClassLoader.java:1349:DEBUG] Loading class from parent > >> > ControlServlet.java:291:DEBUG] [[[updateShoppingList] Done > rendering > >> > page, Servlet Finished- total:0.5,since last([updateShoppingLi...): > 0.5]] > >> > > >> > > >> > > >> > 2008/3/7, Vikas Mayur <[EMAIL PROTECTED]>: > >> >> If its a revision before the fix goes in (that might be because it > is > >> >> updated in some regular intervals, might be day or two or more), > than I > >> am > >> >> not sure why this (creating shopping list) was working on the Demo > >> Site. > >> >> > >> >> IMO it would be good to have the revision number along with the > label > >> >> Trunk > >> >> Demo and Release 4.0 Branch Demo so that it will help in testing > things > >> >> against the Demo and that because most of the time we do (I do ...) > >> this > >> >> to > >> >> verify things if some things goes wrong on the local instance. > >> >> > >> >> > >> >> > >> >> Vikas > >> >> > >> >> > >> >> On Thu, Mar 6, 2008 at 11:49 PM, BJ Freeman <[EMAIL PROTECTED]> > >> wrote: > >> >> > >> >>> your are using a rev before the fix he put in. > >> >>> you code does not match the latest trunk used on the demo > >> >>> > >> >>> > >> >>> Vikas Mayur sent the following on 3/6/2008 5:51 AM: > >> >>>> Bilgin, Thanks for looking at it. > >> >>>> Tomorrow I will give it a try and let you know how it goes. > >> >>>> > >> >>>> I am not sure why this is working on Demo Ecommerce Site, if they > run > >> >> on > >> >>>> latest trunk. > >> >>>> > >> >>>> Vikas > >> >>>> > >> >>>> On Thu, Mar 6, 2008 at 4:05 PM, Bilgin Ibryam < > [EMAIL PROTECTED]> > >> >>> wrote: > >> >>>>> Hi Vikas, > >> >>>>> > >> >>>>> You can check rev630718 and OFBIZ-1590 for details about these > new > >> >>>>> fields. > >> >>>>> > >> >>>>> I just committed a fix for it in rev634211. You can update and > tell > >> >> me > >> >>>>> if the bug still exists. > >> >>>>> > >> >>>>> Regards, > >> >>>>> Bilgin Ibryam > >> >>>>> > >> >>>>> > >> >>> > >> > > >> > >> > > > >