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
