The problem was in framework/entity/config/entityengine.xml
The same changes that where made in r528801 for derby need to be done for MySQL In localmysql configuration + use-pk-constraint-names="false" - alias-view-columns="true" + alias-view-columns="false" I made this changes and it worked fine. Thanks.- 2007/4/16, Guido Amarilla <[EMAIL PROTECTED]>:
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
-- Guido Amarilla
