[
https://issues.apache.org/jira/browse/OFBIZ-4498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13133867#comment-13133867
]
Jacques Le Roux commented on OFBIZ-4498:
----------------------------------------
While working on this I found another (not related) bug. It shows only in the
log
{code}
2011-10-23 20:16:08,562 (http-0.0.0.0-8443-2) [
GenericDelegator.java:1787:ERROR]
---- exception report ----------------------------------------------------------
Failure in findByCondition operation for entity [ProductCategory]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT PRODUCT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTI
ON FROM OFBIZ.PRODUCT_CATEGORY WHERE (((PRODUCT_CATEGORY_ID = (?, ?) OR
PRODUCT_CATEGORY_ID = (?, ?) OR PRODUCT_CATEGORY_ID = (?,
?)))) ORDER BY PRODUCT_CATEGORY_ID ASC, CATEGORY_NAME ASC, DESCRIPTION ASC (Sy
ntax error: Encountered "," at line 1, column 117.). Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT
PRODUCT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION FROM
OFBIZ.PRODUCT_CATEGORY WHERE (((PRODUCT_CATEGORY_ID = (?, ?) OR
PRODUCT_CATEGORY_ID = (?, ?) OR
PRODUCT_CATEGORY_ID = (?, ?)))) ORDER BY PRODUCT_CATEGORY_ID ASC,
CATEGORY_NAME ASC, DESCRIPTION ASC (Syntax error: Encountered ","
at line 1, column 117.)
---- cause ---------------------------------------------------------------------
Exception: java.sql.SQLSyntaxErrorException
Message: Syntax error: Encountered "," at line 1, column 117.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.impl.jdbc.EmbedSQLException
Message: Syntax error: Encountered "," at line 1, column 117.
---- cause ---------------------------------------------------------------------
Exception: org.apache.derby.iapi.error.StandardException
Message: Syntax error: Encountered "," at line 1, column 117.
---- stack trace ---------------------------------------------------------------
ERROR 42X01: Syntax error: Encountered "," at line 1, column 117.
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)
org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:291)
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:291)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:363)
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:770)
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1743)
org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1775)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)
org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
FindAutocompleteOptions.run(FindAutocompleteOptions.groovy:117)
{code}
> Store Facility tab is messed up in admin console
> ------------------------------------------------
>
> Key: OFBIZ-4498
> URL: https://issues.apache.org/jira/browse/OFBIZ-4498
> Project: OFBiz
> Issue Type: Bug
> Components: product, specialpurpose/ecommerce
> Affects Versions: Release Branch 11.04, SVN trunk
> Reporter: Kiran Gawde
> Priority: Minor
> Attachments: OFBIZ-4498-ProductStoreFacilities.png
>
>
> In admin console,
> select store
> Click on facility tab.
> You will see entire admin console again. Seems like wrong decorator is used.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
