[jira] Created: (OFBIZ-3797) Find Orders Broken
Locked
[jira] Created: (OFBIZ-3797) Find Orders Broken
 
|
Find Orders Broken
------------------ Key: OFBIZ-3797 URL: https://issues.apache.org/jira/browse/OFBIZ-3797 Project: OFBiz Issue Type: Bug Components: order Affects Versions: SVN trunk Reporter: Chirag Manocha Priority: Blocker Fix For: SVN trunk Go to Order Manager Go to Find Orders Click on Search Expected Result : All orders should be Displayed or No order Founds should be displayed in search result. Actual Result : The Following Errors Occurred: SQL Exception while executing the following:SELECT DISTINCT OH.ORDER_ID, OH.ORDER_TYPE_ID, OH.ORDER_NAME, OH.ORDER_DATE, OH.STATUS_ID, OH.CURRENCY_UOM, OH.REMAINING_SUB_TOTAL, OH.GRAND_TOTAL FROM OFBIZ.ORDER_HEADER OH WHERE () ORDER BY OH.ORDER_DATE DESC, OH.ORDER_ID DESC (Syntax error: Encountered ")" at line 1, column 182.) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-3797) Find Orders Broken
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-3797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-3797. ---------------------------------- Assignee: Adam Heath Resolution: Cannot Reproduce I guess it has been fixed by Adam at r950767 > Find Orders Broken > ------------------ > > Key: OFBIZ-3797 > URL: https://issues.apache.org/jira/browse/OFBIZ-3797 > Project: OFBiz > Issue Type: Bug > Components: order > Affects Versions: SVN trunk > Reporter: Chirag Manocha > Assignee: Adam Heath > Priority: Blocker > Fix For: SVN trunk > > > Go to Order Manager > Go to Find Orders > Click on Search > Expected Result : All orders should be Displayed or No order Founds should be displayed in search result. > Actual Result : > The Following Errors Occurred: > SQL Exception while executing the following:SELECT DISTINCT OH.ORDER_ID, OH.ORDER_TYPE_ID, OH.ORDER_NAME, OH.ORDER_DATE, OH.STATUS_ID, OH.CURRENCY_UOM, OH.REMAINING_SUB_TOTAL, OH.GRAND_TOTAL FROM OFBIZ.ORDER_HEADER OH WHERE () ORDER BY OH.ORDER_DATE DESC, OH.ORDER_ID DESC (Syntax error: Encountered ")" at line 1, column 182.) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-3797) Find Orders Broken
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-3797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chirag Manocha updated OFBIZ-3797: ---------------------------------- Attachment: OFBiz-3797.png Still an issue. Attaching screenshot of trunk. > Find Orders Broken > ------------------ > > Key: OFBIZ-3797 > URL: https://issues.apache.org/jira/browse/OFBIZ-3797 > Project: OFBiz > Issue Type: Bug > Components: order > Affects Versions: SVN trunk > Reporter: Chirag Manocha > Assignee: Adam Heath > Priority: Blocker > Fix For: SVN trunk > > Attachments: OFBiz-3797.png > > > Go to Order Manager > Go to Find Orders > Click on Search > Expected Result : All orders should be Displayed or No order Founds should be displayed in search result. > Actual Result : > The Following Errors Occurred: > SQL Exception while executing the following:SELECT DISTINCT OH.ORDER_ID, OH.ORDER_TYPE_ID, OH.ORDER_NAME, OH.ORDER_DATE, OH.STATUS_ID, OH.CURRENCY_UOM, OH.REMAINING_SUB_TOTAL, OH.GRAND_TOTAL FROM OFBIZ.ORDER_HEADER OH WHERE () ORDER BY OH.ORDER_DATE DESC, OH.ORDER_ID DESC (Syntax error: Encountered ")" at line 1, column 182.) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Reopened: (OFBIZ-3797) Find Orders Broken
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-3797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chirag Manocha reopened OFBIZ-3797: ----------------------------------- > Find Orders Broken > ------------------ > > Key: OFBIZ-3797 > URL: https://issues.apache.org/jira/browse/OFBIZ-3797 > Project: OFBiz > Issue Type: Bug > Components: order > Affects Versions: SVN trunk > Reporter: Chirag Manocha > Assignee: Adam Heath > Priority: Blocker > Fix For: SVN trunk > > Attachments: OFBiz-3797.png > > > Go to Order Manager > Go to Find Orders > Click on Search > Expected Result : All orders should be Displayed or No order Founds should be displayed in search result. > Actual Result : > The Following Errors Occurred: > SQL Exception while executing the following:SELECT DISTINCT OH.ORDER_ID, OH.ORDER_TYPE_ID, OH.ORDER_NAME, OH.ORDER_DATE, OH.STATUS_ID, OH.CURRENCY_UOM, OH.REMAINING_SUB_TOTAL, OH.GRAND_TOTAL FROM OFBIZ.ORDER_HEADER OH WHERE () ORDER BY OH.ORDER_DATE DESC, OH.ORDER_ID DESC (Syntax error: Encountered ")" at line 1, column 182.) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-3797) Find Orders Broken
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-3797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-3797. ---------------------------------- Resolution: Fixed Chirag, The trunk is not up to date, it's only updated every 24 hours. For instance if you look into the footer in the image you attached you will see Release-revision : trunk-950339, and this has been fixed at r950767. Since then the trunk has been updated and it works well, also locally > Find Orders Broken > ------------------ > > Key: OFBIZ-3797 > URL: https://issues.apache.org/jira/browse/OFBIZ-3797 > Project: OFBiz > Issue Type: Bug > Components: order > Affects Versions: SVN trunk > Reporter: Chirag Manocha > Assignee: Adam Heath > Priority: Blocker > Fix For: SVN trunk > > Attachments: OFBiz-3797.png > > > Go to Order Manager > Go to Find Orders > Click on Search > Expected Result : All orders should be Displayed or No order Founds should be displayed in search result. > Actual Result : > The Following Errors Occurred: > SQL Exception while executing the following:SELECT DISTINCT OH.ORDER_ID, OH.ORDER_TYPE_ID, OH.ORDER_NAME, OH.ORDER_DATE, OH.STATUS_ID, OH.CURRENCY_UOM, OH.REMAINING_SUB_TOTAL, OH.GRAND_TOTAL FROM OFBIZ.ORDER_HEADER OH WHERE () ORDER BY OH.ORDER_DATE DESC, OH.ORDER_ID DESC (Syntax error: Encountered ")" at line 1, column 182.) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-3797) Find Orders Broken
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-3797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12874973#action_12874973 ] Chirag Manocha commented on OFBIZ-3797: --------------------------------------- Yeah, I missed the revision number in footer. Checked this on latest trunk right now. Working Fine. Thanks for the clarification Jacques. > Find Orders Broken > ------------------ > > Key: OFBIZ-3797 > URL: https://issues.apache.org/jira/browse/OFBIZ-3797 > Project: OFBiz > Issue Type: Bug > Components: order > Affects Versions: SVN trunk > Reporter: Chirag Manocha > Assignee: Adam Heath > Priority: Blocker > Fix For: SVN trunk > > Attachments: OFBiz-3797.png > > > Go to Order Manager > Go to Find Orders > Click on Search > Expected Result : All orders should be Displayed or No order Founds should be displayed in search result. > Actual Result : > The Following Errors Occurred: > SQL Exception while executing the following:SELECT DISTINCT OH.ORDER_ID, OH.ORDER_TYPE_ID, OH.ORDER_NAME, OH.ORDER_DATE, OH.STATUS_ID, OH.CURRENCY_UOM, OH.REMAINING_SUB_TOTAL, OH.GRAND_TOTAL FROM OFBIZ.ORDER_HEADER OH WHERE () ORDER BY OH.ORDER_DATE DESC, OH.ORDER_ID DESC (Syntax error: Encountered ")" at line 1, column 182.) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |