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.
>>>
>>
>>
>>
>
>
> --
>
>
