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?
I get the error message "Unknown column 'pm' in 'field list'" in front and backend, when I use a promotion code.
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.
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.
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.
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
krileon
