Sorry for posting again. I think it may be a bug or an issue with MySQL in svn commit: r528801...
2007/4/16, Guido Amarilla <[EMAIL PROTECTED]>:
Maybe is a bug introduced in svn commit: r528804 ??? (Low level view changes) I am using MySQL 2007/4/16, Guido Amarilla <[EMAIL PROTECTED]>: > After updating to the latest SVN and running ant run-install-seed I > started to have the following ERROR in EditProductInventoryItems. I > have very little customization. > > Can you confirm this error? > > (By the way, is there any active Demo server with the latest SVN > version, where I can test if this problem can be reproduced there, > before posting to the ML?) > > > :ERROR MESSAGE: > org.ofbiz.base.util.GeneralException: Error rendering screen > [component://product/widget/catalog/ProductScreens.xml#EditProductInventoryItems]: > org.ofbiz.base.util.GeneralException: Error rendering screen > [component://product/widget/catalog/CatalogCommonScreens.xml#CommonProductDecorator]: > org.ofbiz.entity.transaction.GenericTransactionException: The current > transaction is marked for rollback, not beginning a new transaction > and aborting current operation; the rollbackOnly was caused by: > Failure in findByCondition operation for entity [OrderHeaderAndItems]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception while > executing the following:SELECT OH.ORDER_ID AS ORDER_ID, OH.ORDER_DATE > AS ORDER_DATE, OH.STATUS_ID AS ORDER_STATUS_ID, OH.GRAND_TOTAL AS > GRAND_TOTAL, OH.PRODUCT_STORE_ID AS PRODUCT_STORE_ID, OH.ORDER_TYPE_ID > AS ORDER_TYPE_ID, OI.ORDER_ITEM_SEQ_ID AS ORDER_ITEM_SEQ_ID, > OI.PRODUCT_ID AS PRODUCT_ID, OI.QUANTITY AS QUANTITY, > OI.CANCEL_QUANTITY AS CANCEL_QUANTITY, OI.UNIT_PRICE AS UNIT_PRICE, > OI.UNIT_LIST_PRICE AS UNIT_LIST_PRICE, OI.ITEM_DESCRIPTION AS > ITEM_DESCRIPTION, OI.STATUS_ID AS ITEM_STATUS_ID, > OI.ESTIMATED_SHIP_DATE AS ESTIMATED_SHIP_DATE, > OI.ESTIMATED_DELIVERY_DATE AS ESTIMATED_DELIVERY_DATE, > OI.ORDER_ITEM_TYPE_ID AS ORDER_ITEM_TYPE_ID FROM ORDER_HEADER OH INNER > JOIN ORDER_ITEM OI ON OH.ORDER_ID = OI.ORDER_ID WHERE (ORDER_STATUS_ID > <> ? AND ORDER_STATUS_ID <> ? AND ORDER_STATUS_ID <> ? AND > ITEM_STATUS_ID <> ? AND ITEM_STATUS_ID <> ? AND ITEM_STATUS_ID <> ? > AND ORDER_TYPE_ID = ? AND PRODUCT_ID = ?) ORDER BY > ESTIMATED_DELIVERY_DATE DESC, ORDER_DATE ASC (Unknown column > 'ORDER_STATUS_ID' in 'where clause'). Rolling back > transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception > while executing the following:SELECT OH.ORDER_ID AS ORDER_ID, > OH.ORDER_DATE AS OR... > > -- > Guido Amarilla > -- Guido Amarilla
-- Guido Amarilla
