[SOLVED] Unknown column 'pm' in 'field list'
- zahmundzornig
- OFFLINE
-
Premium Member
- Posts: 159
- Thanks: 17
- Karma: 3
4 years 1 month ago - 4 years 1 month ago #317161
by zahmundzornig
www.zahmundzornig.de thanx joomlapolis for the great work and support!
Build with CB: www.jaii.de
[SOLVED] Unknown column 'pm' in 'field list' was created by zahmundzornig
I get the error message "Unknown column 'pm' in 'field list'" in front and backend, when I use a promotion code. Also is the list of used promotions empty. Any idea how I can solve this?
Thank you!
Thank you!
www.zahmundzornig.de thanx joomlapolis for the great work and support!
Build with CB: www.jaii.de
Last edit: 4 years 1 month ago by krileon. Reason: Added [SOLVED] tag to subject
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68482
- Thanks: 9076
- Karma: 1434
4 years 1 month ago #317167
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Unknown column 'pm' in 'field list'
Can you be more specific? What do you mean when you use a promotion code in backend? In frontend I assume you mean during the basket process in CBSubs? Try unpublishing all your promotion codes and creating a new one with a flat discount for 1 then see if the issue persists using that promotion code.I get the error message "Unknown column 'pm' in 'field list'" in front and backend, when I use a promotion code.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- zahmundzornig
- OFFLINE
-
Premium Member
- Posts: 159
- Thanks: 17
- Karma: 3
4 years 1 month ago - 4 years 1 month ago #317171
by zahmundzornig
www.zahmundzornig.de thanx joomlapolis for the great work and support!
Build with CB: www.jaii.de
Replied by zahmundzornig on topic Unknown column 'pm' in 'field list'
Sorry, it depends NOT on the promotion codes.
This are the steps to the error:
1. User buys a new pay-subscription in frontend (offline payment)
2. Admin (in backend) goes to Subscription -> Shopping Cart and click the button "pay" in the status row
3.The page "CB Paid Subscriptions: edit shopping cart manually" opens and the admin press then left top corner button "Pay"
4. The error "Unknown column 'pm' in 'field list'" appears.
Same error appears when a user in frontend unsubscribe a subscription.
This are the steps to the error:
1. User buys a new pay-subscription in frontend (offline payment)
2. Admin (in backend) goes to Subscription -> Shopping Cart and click the button "pay" in the status row
3.The page "CB Paid Subscriptions: edit shopping cart manually" opens and the admin press then left top corner button "Pay"
4. The error "Unknown column 'pm' in 'field list'" appears.
Same error appears when a user in frontend unsubscribe a subscription.
www.zahmundzornig.de thanx joomlapolis for the great work and support!
Build with CB: www.jaii.de
Last edit: 4 years 1 month ago by zahmundzornig.
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68482
- Thanks: 9076
- Karma: 1434
4 years 1 month ago #317175
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Unknown column 'pm' in 'field list'
Are you trying to set the value of the PM field using CBSubs Fields integration within your plan or with CB Auto Actions? Try unpublishing CB Auto Actions and CBSubs CB Field within CB > Plugin Management and see if the issue persists.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: zahmundzornig
Please Log in to join the conversation.
- zahmundzornig
- OFFLINE
-
Premium Member
- Posts: 159
- Thanks: 17
- Karma: 3
4 years 1 month ago #317180
by zahmundzornig
www.zahmundzornig.de thanx joomlapolis for the great work and support!
Build with CB: www.jaii.de
Replied by zahmundzornig on topic Unknown column 'pm' in 'field list'
Thank you for the hint! Plan - Integration - CB Field - pm - Set: field = value
I took the wrong field.
Problem solved.
I took the wrong field.
Problem solved.
www.zahmundzornig.de thanx joomlapolis for the great work and support!
Build with CB: www.jaii.de
The following user(s) said Thank You: krileon
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.229 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- [SOLVED] Unknown column 'pm' in 'field list'