You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "Javier H." <dr...@gmail.com> on 2017/11/21 08:20:34 UTC
Error rendering screen [component://product/widget/catalog/LookupScreens.xml#LookupProductCategory]
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.
Re: Error rendering screen [component://product/widget/catalog/LookupScreens.xml#LookupProductCategory]
Posted by "Javier H." <dr...@gmail.com>.
On 2017-11-21 08:47, Javier <dr...@gmail.com> 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 <dr...@gmail.com>:
>
> > 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 <dr...@gmail.com>:
> >
> >> :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 <dr...@gmail.com>:
> >>
> >>>
> >>>
> >>> 2017-11-21 8:20 GMT+00:00 Javier H. <dr...@gmail.com>:
> >>>
> >>>> 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
Re: Error rendering screen [component://product/widget/catalog/LookupScreens.xml#LookupProductCategory]
Posted by Javier <dr...@gmail.com>.
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 <dr...@gmail.com>:
> 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 <dr...@gmail.com>:
>
>> :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 <dr...@gmail.com>:
>>
>>>
>>>
>>> 2017-11-21 8:20 GMT+00:00 Javier H. <dr...@gmail.com>:
>>>
>>>> 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.
>>>
>>
>>
>>
>
>
> --
>
>
Re: Error rendering screen [component://product/widget/catalog/LookupScreens.xml#LookupProductCategory]
Posted by Javier <dr...@gmail.com>.
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 <dr...@gmail.com>:
> :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 <dr...@gmail.com>:
>
>>
>>
>> 2017-11-21 8:20 GMT+00:00 Javier H. <dr...@gmail.com>:
>>
>>> 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
Re: Error rendering screen [component://product/widget/catalog/LookupScreens.xml#LookupProductCategory]
Posted by Javier <dr...@gmail.com>.
: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 <dr...@gmail.com>:
>
>
> 2017-11-21 8:20 GMT+00:00 Javier H. <dr...@gmail.com>:
>
>> 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.
>
Re: Error rendering screen [component://product/widget/catalog/LookupScreens.xml#LookupProductCategory]
Posted by Javier <dr...@gmail.com>.
2017-11-21 8:20 GMT+00:00 Javier H. <dr...@gmail.com>:
> 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.