Error rendering screen [component://product/widget/ca
Locked
Error rendering screen [component://product/widget/ca
 
|
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/ca
|
|
2017-11-21 8:20 GMT+00:00 Javier H. <[hidden email]>: Hello, Also, in /catalog/control/FindCategory I can not view the created categories.
|
Re: Error rendering screen [component://product/widget/ca
|
|
: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 <[hidden email]>: > > > 2017-11-21 8:20 GMT+00:00 Javier H. <[hidden email]>: > >> 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/ca
|
|
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 <[hidden email]>: > :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 <[hidden email]>: > >> >> >> 2017-11-21 8:20 GMT+00:00 Javier H. <[hidden email]>: >> >>> 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/ca
|
|
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 <[hidden email]>: > 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 <[hidden email]>: > >> :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 <[hidden email]>: >> >>> >>> >>> 2017-11-21 8:20 GMT+00:00 Javier H. <[hidden email]>: >>> >>>> 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/ca
|
|
On 2017-11-21 08:47, Javier <[hidden email]> 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 <[hidden email]>: > > > 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 <[hidden email]>: > > > >> :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 <[hidden email]>: > >> > >>> > >>> > >>> 2017-11-21 8:20 GMT+00:00 Javier H. <[hidden email]>: > >>> > >>>> 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 |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |