2017-11-21 8:20 GMT+00:00 Javier H. <[email protected]>: > Hello, > > I use Ofbiz 16.11.03 with Mysql Ver 14.14 Distrib 5.7.20, for Linux > (x86_64) using EditLine wrapper. > > Whitout demo data. > > I created some participants, a store, catalog and category. > > I could add a store to the catalog, but I have problems adding > participants or categories. > > In /catalog/control/EditProdCatalogCategories?prodCatalogId=10000 > > If I try to find a Category to add to Category ID, this error is left in > the category search dialog. > > > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen > [component://product/widget/catalog/LookupScreens.xml#LookupProductCategory]: > org.apache.ofbiz.entity.transaction.GenericTransactionException: Roll > back error, could not commit transaction, was rolled back instead because > of: Error in Service [executeFind]: Error running Find on the > ProductCategory entity: SQL Exception while executing the following:SELECT > PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, > CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, > LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP > FROM PRODUCT_CATEGORY (You have an error in your SQL syntax; check the > manual that corresponds to your MySQL server version for the right syntax > to use near 'OPTION SQL_SELECT_LIMIT=20' at line 1) (Roll back error, could > not commit transaction, was rolled back instead beca > use of: Error in Service [executeFind]: Error running Find on the > ProductCategory entity: SQL Exception while executing the following:SELECT > PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, > CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, > LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP > FROM PRODUCT_CATEGORY (You have an error in your SQL syntax; check the > manual that corresponds to your MySQL server version for the right syntax > to use near 'OPTION SQL_SELECT_LIMIT=20' at line 1)) > > How is it possible to solve this? > > Best regards. >
Also, in /catalog/control/FindCategory I can not view the created categories.
