:ERROR MESSAGE: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://product/widget/catalog/CategoryScreens.xml#FindCategory]: 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 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))
2017-11-21 8:37 GMT+00:00 Javier <[email protected]>: > > > 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. >
