On 2017-11-21 08:47, Javier <[email protected]> wrote: > The Categories created from Ofbiz are stored in the mysql database, the > error is only when you try to visualize it. > > > mysql> mysql> select * from PRODUCT_CATEGORY; > +---------------------+--------------------------+----------------------------+---------------+--------------------------------------------+------------------+--------------------+--------------------+--------------------+---------------+----------------+---------------------+-----------------------+---------------------+---------------------+ > | 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 | > +---------------------+--------------------------+----------------------------+---------------+--------------------------------------------+------------------+--------------------+--------------------+--------------------+---------------+----------------+---------------------+-----------------------+---------------------+---------------------+ > | 10000 | CATALOG_CATEGORY | NULL > | Varios | CategorÃa para productos sin categorizar. | NULL > | NULL | NULL | NULL | > NULL | NULL | 2017-11-16 06:27:59 | 2017-11-16 06:27:59 > | 2017-11-16 06:27:59 | 2017-11-16 06:27:59 | > | 10010 | CATALOG_CATEGORY | NULL > | Varios | NULL | NULL > | NULL | NULL | NULL | > NULL | NULL | 2017-11-17 21:39:03 | 2017-11-17 21:39:03 > | 2017-11-17 21:39:03 | 2017-11-17 21:39:03 | > | 10020 | CATALOG_CATEGORY | NULL > | Uncategorized | NULL | NULL > | NULL | NULL | NULL | > NULL | NULL | 2017-11-19 10:50:15 | 2017-11-19 10:50:15 > | 2017-11-19 10:50:15 | 2017-11-19 10:50:15 | > +---------------------+--------------------------+----------------------------+---------------+--------------------------------------------+------------------+--------------------+--------------------+--------------------+---------------+----------------+---------------------+-----------------------+---------------------+---------------------+ > 3 rows in set (0.00 sec) > > > 2017-11-21 8:41 GMT+00:00 Javier <[email protected]>: > > > 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/ca > >>>> talog/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. > >>> > >> > >> > >> > > > > > > -- > > > > >
I changed the mysql connector to 5.1.44 and I loaded the demo data and now everything works fine. Best regards
