[jira] [Commented] (OFBIZ-6570) Anonymous unsubscribe from contact list generates an error
[
https://issues.apache.org/jira/browse/OFBIZ-6570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14702914#comment-14702914
]
Jacques Le Roux commented on OFBIZ-6570:
Please [~pfm.smits] confirm and close if necessary
[~shi.jinghai] should we not backport to releases?
Anonymous unsubscribe from contact list generates an error
--
Key: OFBIZ-6570
URL: https://issues.apache.org/jira/browse/OFBIZ-6570
Project: OFBiz
Issue Type: Bug
Components: marketing, specialpurpose/ecommerce
Affects Versions: Trunk
Reporter: Pierre Smits
Assignee: Shi Jinghai
When trying to unsubscribe as an anonymous user, following error is shown:
{code}
Exception thrown while creating the newEntity GenericValue:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:ContactListPartyStatus][contactListId,9000(java.lang.String)][createdStamp,2015-08-06
12:26:31.205(java.sql.Timestamp)][createdTxStamp,2015-08-06
12:26:31.007(java.sql.Timestamp)][lastUpdatedStamp,2015-08-06
12:26:31.205(java.sql.Timestamp)][lastUpdatedTxStamp,2015-08-06
12:26:31.007(java.sql.Timestamp)][partyId,_NA_(java.lang.String)][setByUserLoginId,system(java.lang.String)][statusDate,2015-08-06
12:26:31.205(java.sql.Timestamp)][statusId,CLPT_UNSUBS_PENDING(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.CONTACT_LIST_PARTY_STATUS (CONTACT_LIST_ID, PARTY_ID, FROM_DATE,
STATUS_DATE, STATUS_ID, SET_BY_USER_LOGIN_ID, OPT_IN_VERIFY_CODE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'FROM_DATE' cannot accept a
NULL value.)) (Error while inserting:
[GenericEntity:ContactListPartyStatus][contactListId,9000(java.lang.String)][createdStamp,2015-08-06
12:26:31.205(java.sql.Timestamp)][createdTxStamp,2015-08-06
12:26:31.007(java.sql.Timestamp)][lastUpdatedStamp,2015-08-06
12:26:31.205(java.sql.Timestamp)][lastUpdatedTxStamp,2015-08-06
12:26:31.007(java.sql.Timestamp)][partyId,_NA_(java.lang.String)][setByUserLoginId,system(java.lang.String)][statusDate,2015-08-06
12:26:31.205(java.sql.Timestamp)][statusId,CLPT_UNSUBS_PENDING(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.CONTACT_LIST_PARTY_STATUS (CONTACT_LIST_ID, PARTY_ID, FROM_DATE,
STATUS_DATE, STATUS_ID, SET_BY_USER_LOGIN_ID, OPT_IN_VERIFY_CODE,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Column 'FROM_DATE' cannot accept a
NULL value.)))
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (OFBIZ-6569) popup calendar icon missing and dialog is transparent in flat grey theme
[ https://issues.apache.org/jira/browse/OFBIZ-6569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux updated OFBIZ-6569: --- Affects Version/s: (was: Upcoming Branch) Priority: Trivial (was: Major) Fix Version/s: Upcoming Branch Description: Thanks Jinghai and Wai for report. I tried to backport to all releases, it's possible but would need to hand work, I gave up, not important enough while being almost in vacation popup calendar icon missing and dialog is transparent in flat grey theme Key: OFBIZ-6569 URL: https://issues.apache.org/jira/browse/OFBIZ-6569 Project: OFBiz Issue Type: Bug Components: framework Affects Versions: Trunk Reporter: Wai Assignee: Shi Jinghai Priority: Trivial Fix For: Upcoming Branch Thanks Jinghai and Wai for report. I tried to backport to all releases, it's possible but would need to hand work, I gave up, not important enough while being almost in vacation -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (OFBIZ-6576) Pricing error in Variant Products when setup with VAT-Tax and price set on Virtual Product
[ https://issues.apache.org/jira/browse/OFBIZ-6576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14702919#comment-14702919 ] Sharan Foga commented on OFBIZ-6576: Hi Jacques - I will run a test on 12.04 and let you know. Thanks Pricing error in Variant Products when setup with VAT-Tax and price set on Virtual Product -- Key: OFBIZ-6576 URL: https://issues.apache.org/jira/browse/OFBIZ-6576 Project: OFBiz Issue Type: Bug Components: product Affects Versions: Release Branch 13.07, Release Branch 14.12, Trunk Reporter: Peter Arnold Priority: Minor Fix For: 14.12.01, 13.07.03, Upcoming Branch In a VAT-Tax setup (i.e. sales-tax does not apply) and when using virtual- variant- products and the price is defined only on the virtual product and with Tax in Price set to Y, its variants should inherit the set price without adding any further taxes. This is currently not the case when in the e-commerce shop a variant product is added to the shopping cart. Currently sales-tax is added to the product price. Here is a detailed procedure to reproduce the error: In Party Manager: 1. Create new Party Group with Name SII_CHL (Leave all settings for group creation as per standard) 2. Assign Role Tax Authority to party SII_CHL In Accounting Module / Tax Autorities: 3. Create New Tax Authority with following settings: Geo:CHL Party: SII_CHL Include Tax in Price: Y Leave other setting as is 4. Under Product Rates create new tax with following settings: Type: Value Added Tax Tax Percentage: 19 From Date: Now Leave other settings as is 5. Expire the Sales Tax created under tax authority _NA_ by setting its corresponding thru date to NOW. 6. Under Catalog Manager / Stores: Modify following Settings for OFBiz Ecommerce Store (ID:9000) Tax settings: Show Prices with VAT tax included: Y VAT Tax Auth Geo Id: CHL VAT Tax Auth Party Id: 1 (Or the Party ID corresponding to the created Tax Authority SII_CHL) 7. Expire all Promotions for OFBIZ E-Commerce Store [ID:9000] by setting all thru-dates to NOW 8. Under Catalog Manager / Products: Create New Product with following settings: Internal Name: T-Shirt Is Virtual Product: Y 9. Under Catalog Manager / Products / Categories Assign the virtual product T-Shirt to the products category ID 200 (Widgets) - Product Category ID: 200 - From Date: Now Add 10 Under Catalog Manager / Products / Content In override Simple Fields Set Product Name to: T-Shirt Virtual Update 11. Under Catalog Manager / Features: Create New Feature Category. - Description: T-Shirt Colors Submit 12. Create new Feature within feature Category T-Shirt Colors: Create New Feature - Feature Type: Color - Description: Red Update Create New Feature - Feature Type: Color - Description: Blue Update 13. Create 2 variant products under the virtual product T-Shirt Under Catalog Manager / Products Find T-Shirt Product Once T-Shirt Product is selected: Press Features Tab Under Add product features from Category or Group - Choose T-Shirt Colors Category - Feature Application Type: Selectable Add Screen with Blue and Red T-Shirt Colors appears. Set for both colors From Date: Now Sequence:1 for blue Sequence:2 for red Set a tick on each feature in order to select the feature for adding it. Apply 14. Under Catalog Manager / Products with T-Shirt virtual product selected press the Variants tab The Quick add Variants screen appears. Define Product IDs for Blue and Red features. Blue: T-Shirt Blue Red: T-Shirt Red Set tick on both features in order to select for variant product creation. Create 15. Under Catalog Manager / Products / Prices set 2 new product prices for the created virtual product T-Shirt: - Default Price - From Date: Now - Price: 11.9 - Tax Percentage: 19 - Tax in price: Y Create - List Price - From Date: Now - Price: 11.9 - Tax Percentage: 19 - Tax in price: Y Create Now the products should be visible in the E-Shop. The Virtual Products Price appears at USD 14.16 If I Select the blue or the red T-Shirt Price is 11.9USD Now I modify the Product
[jira] [Updated] (OFBIZ-6566) SecurityGroup doesn't get removed from a Party
[ https://issues.apache.org/jira/browse/OFBIZ-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux updated OFBIZ-6566: --- Fix Version/s: 13.07.03 12.04.06 14.12.01 Backported to R14.12 r1696570 R13.07 r1696571 R12.04 r1696572 SecurityGroup doesn't get removed from a Party -- Key: OFBIZ-6566 URL: https://issues.apache.org/jira/browse/OFBIZ-6566 Project: OFBiz Issue Type: Improvement Components: party Affects Versions: Trunk, 12.04.05, 13.07.01 Reporter: Pierre Smits Assignee: Deepak Dixit Priority: Minor Labels: permissions Fix For: 14.12.01, 12.04.06, 13.07.03, Upcoming Branch Attachments: OFBIZ-6566.patch, RemoveSecurityGroup.patch, RemoveSecurityGroup.patch1 When trying to remove a security group from a party (e.g. DemoCustomer, see http://demo-trunk-ofbiz.apache.org/partymgr/control/ProfileEditUserLoginSecurityGroups?partyId=DemoCustomeruserLoginId=DemoCustomer), the security group doesn't get removed. request-map ProfileRemoveUserLoginFromSecurityGroup -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (OFBIZ-6576) Pricing error in Variant Products when setup with VAT-Tax and price set on Virtual Product
[ https://issues.apache.org/jira/browse/OFBIZ-6576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux updated OFBIZ-6576: --- Affects Version/s: (was: 13.07.01) (was: 13.07.02) Fix Version/s: (was: Release Branch 14.12) (was: 13.07.01) (was: 13.07.02) (was: Release Branch 13.07) (was: Trunk) Upcoming Branch Changing concerned versions, maybe R12.04 is also concerned Pricing error in Variant Products when setup with VAT-Tax and price set on Virtual Product -- Key: OFBIZ-6576 URL: https://issues.apache.org/jira/browse/OFBIZ-6576 Project: OFBiz Issue Type: Bug Components: product Affects Versions: Release Branch 13.07, Release Branch 14.12, Trunk Reporter: Peter Arnold Priority: Minor Fix For: 14.12.01, 13.07.03, Upcoming Branch In a VAT-Tax setup (i.e. sales-tax does not apply) and when using virtual- variant- products and the price is defined only on the virtual product and with Tax in Price set to Y, its variants should inherit the set price without adding any further taxes. This is currently not the case when in the e-commerce shop a variant product is added to the shopping cart. Currently sales-tax is added to the product price. Here is a detailed procedure to reproduce the error: In Party Manager: 1. Create new Party Group with Name SII_CHL (Leave all settings for group creation as per standard) 2. Assign Role Tax Authority to party SII_CHL In Accounting Module / Tax Autorities: 3. Create New Tax Authority with following settings: Geo:CHL Party: SII_CHL Include Tax in Price: Y Leave other setting as is 4. Under Product Rates create new tax with following settings: Type: Value Added Tax Tax Percentage: 19 From Date: Now Leave other settings as is 5. Expire the Sales Tax created under tax authority _NA_ by setting its corresponding thru date to NOW. 6. Under Catalog Manager / Stores: Modify following Settings for OFBiz Ecommerce Store (ID:9000) Tax settings: Show Prices with VAT tax included: Y VAT Tax Auth Geo Id: CHL VAT Tax Auth Party Id: 1 (Or the Party ID corresponding to the created Tax Authority SII_CHL) 7. Expire all Promotions for OFBIZ E-Commerce Store [ID:9000] by setting all thru-dates to NOW 8. Under Catalog Manager / Products: Create New Product with following settings: Internal Name: T-Shirt Is Virtual Product: Y 9. Under Catalog Manager / Products / Categories Assign the virtual product T-Shirt to the products category ID 200 (Widgets) - Product Category ID: 200 - From Date: Now Add 10 Under Catalog Manager / Products / Content In override Simple Fields Set Product Name to: T-Shirt Virtual Update 11. Under Catalog Manager / Features: Create New Feature Category. - Description: T-Shirt Colors Submit 12. Create new Feature within feature Category T-Shirt Colors: Create New Feature - Feature Type: Color - Description: Red Update Create New Feature - Feature Type: Color - Description: Blue Update 13. Create 2 variant products under the virtual product T-Shirt Under Catalog Manager / Products Find T-Shirt Product Once T-Shirt Product is selected: Press Features Tab Under Add product features from Category or Group - Choose T-Shirt Colors Category - Feature Application Type: Selectable Add Screen with Blue and Red T-Shirt Colors appears. Set for both colors From Date: Now Sequence:1 for blue Sequence:2 for red Set a tick on each feature in order to select the feature for adding it. Apply 14. Under Catalog Manager / Products with T-Shirt virtual product selected press the Variants tab The Quick add Variants screen appears. Define Product IDs for Blue and Red features. Blue: T-Shirt Blue Red: T-Shirt Red Set tick on both features in order to select for variant product creation. Create 15. Under Catalog Manager / Products / Prices set 2 new product prices for the created virtual product T-Shirt: - Default Price - From Date: Now - Price: 11.9 - Tax Percentage: 19 - Tax in price: Y Create - List Price - From
[jira] [Updated] (OFBIZ-6569) popup calendar icon missing and dialog is transparent in flat grey theme
[ https://issues.apache.org/jira/browse/OFBIZ-6569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux updated OFBIZ-6569: --- Description: popup calendar icon missing and dialog is transparent in flat grey theme (was: Thanks Jinghai and Wai for report. I tried to backport to all releases, it's possible but would need to hand work, I gave up, not important enough while being almost in vacation) Thanks Jinghai and Wai for report. I tried to backport to all releases, it's possible but would need to hand work, I gave up, not important enough while being almost in vacation popup calendar icon missing and dialog is transparent in flat grey theme Key: OFBIZ-6569 URL: https://issues.apache.org/jira/browse/OFBIZ-6569 Project: OFBiz Issue Type: Bug Components: framework Affects Versions: Trunk Reporter: Wai Assignee: Shi Jinghai Priority: Trivial Fix For: Upcoming Branch popup calendar icon missing and dialog is transparent in flat grey theme -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (OFBIZ-6566) SecurityGroup doesn't get removed from a Party
[ https://issues.apache.org/jira/browse/OFBIZ-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14702937#comment-14702937 ] Jacques Le Roux edited comment on OFBIZ-6566 at 8/19/15 12:28 PM: -- Thought it could be considered an improvement (moot point) I backported to R14.12 r1696570 R13.07 r1696571 R12.04 r1696572 was (Author: jacques.le.roux): Backported to R14.12 r1696570 R13.07 r1696571 R12.04 r1696572 SecurityGroup doesn't get removed from a Party -- Key: OFBIZ-6566 URL: https://issues.apache.org/jira/browse/OFBIZ-6566 Project: OFBiz Issue Type: Improvement Components: party Affects Versions: Trunk, 12.04.05, 13.07.01 Reporter: Pierre Smits Assignee: Deepak Dixit Priority: Minor Labels: permissions Fix For: 14.12.01, 12.04.06, 13.07.03, Upcoming Branch Attachments: OFBIZ-6566.patch, RemoveSecurityGroup.patch, RemoveSecurityGroup.patch1 When trying to remove a security group from a party (e.g. DemoCustomer, see http://demo-trunk-ofbiz.apache.org/partymgr/control/ProfileEditUserLoginSecurityGroups?partyId=DemoCustomeruserLoginId=DemoCustomer), the security group doesn't get removed. request-map ProfileRemoveUserLoginFromSecurityGroup -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (OFBIZ-6566) SecurityGroup doesn't get removed from a Party
[ https://issues.apache.org/jira/browse/OFBIZ-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14702937#comment-14702937 ] Jacques Le Roux edited comment on OFBIZ-6566 at 8/19/15 12:28 PM: -- Thought it could be considered an improvement (moot point) I backported to R14.12 r1696570 R13.07 r1696571 R12.04 r1696572 because it was simple and safe was (Author: jacques.le.roux): Thought it could be considered an improvement (moot point) I backported to R14.12 r1696570 R13.07 r1696571 R12.04 r1696572 SecurityGroup doesn't get removed from a Party -- Key: OFBIZ-6566 URL: https://issues.apache.org/jira/browse/OFBIZ-6566 Project: OFBiz Issue Type: Improvement Components: party Affects Versions: Trunk, 12.04.05, 13.07.01 Reporter: Pierre Smits Assignee: Deepak Dixit Priority: Minor Labels: permissions Fix For: 14.12.01, 12.04.06, 13.07.03, Upcoming Branch Attachments: OFBIZ-6566.patch, RemoveSecurityGroup.patch, RemoveSecurityGroup.patch1 When trying to remove a security group from a party (e.g. DemoCustomer, see http://demo-trunk-ofbiz.apache.org/partymgr/control/ProfileEditUserLoginSecurityGroups?partyId=DemoCustomeruserLoginId=DemoCustomer), the security group doesn't get removed. request-map ProfileRemoveUserLoginFromSecurityGroup -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (OFBIZ-6566) SecurityGroup doesn't get removed from a Party
[ https://issues.apache.org/jira/browse/OFBIZ-6566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14699370#comment-14699370 ] Jacques Le Roux edited comment on OFBIZ-6566 at 8/19/15 12:24 PM: -- IMO its not a bug, so changed the issue type from Bug to improvement. Thanks Pierre Smits and Neeraj Kumawat. Your patch is in trunk at r#1696234 was (Author: deepak.dixit): IMO its not a but, so changed the issue type from Bug to improvement. Thanks Pierre Smits and Neeraj Kumawat. Your patch is in trunk at r#1696234 SecurityGroup doesn't get removed from a Party -- Key: OFBIZ-6566 URL: https://issues.apache.org/jira/browse/OFBIZ-6566 Project: OFBiz Issue Type: Improvement Components: party Affects Versions: Trunk, 12.04.05, 13.07.01 Reporter: Pierre Smits Assignee: Deepak Dixit Priority: Minor Labels: permissions Fix For: Upcoming Branch Attachments: OFBIZ-6566.patch, RemoveSecurityGroup.patch, RemoveSecurityGroup.patch1 When trying to remove a security group from a party (e.g. DemoCustomer, see http://demo-trunk-ofbiz.apache.org/partymgr/control/ProfileEditUserLoginSecurityGroups?partyId=DemoCustomeruserLoginId=DemoCustomer), the security group doesn't get removed. request-map ProfileRemoveUserLoginFromSecurityGroup -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (OFBIZ-6568) Updates Groovy to 2.4.4 version
[ https://issues.apache.org/jira/browse/OFBIZ-6568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14703572#comment-14703572 ] Jacques Le Roux commented on OFBIZ-6568: See also https://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2015-3253 Updates Groovy to 2.4.4 version Key: OFBIZ-6568 URL: https://issues.apache.org/jira/browse/OFBIZ-6568 Project: OFBiz Issue Type: Task Components: framework Reporter: Jacques Le Roux Assignee: Jacques Le Roux Fix For: 14.12.01, 12.04.06, 13.07.03, Upcoming Branch Since it's a security fix we should also update all releases branches. http://groovy-lang.org/security.html -- This message was sent by Atlassian JIRA (v6.3.4#6332)
