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.
