I'm using the 5.1.6 version of mysql connector. [build.gradle file] compile 'mysql:mysql-connector-java:5.1.6'
2017-11-21 8:38 GMT+00:00 Javier <[email protected]>: > :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. >> > > > -- Saludos
