Support

Home Forums Event Espresso Premium Promotional Codes not working (2)

Promotional Codes not working (2)

Posted: November 20, 2013 at 10:22 am


Ronise Stiefemann

November 20, 2013 at 10:22 am

When I tried to update the promotional codes i get the following error:
The discount code was not updated.
Debug:
Array ( [coupon_code] => TFEGC100 [coupon_code_price] => 161.48 [coupon_code_description] => Gift Certificate [use_percentage] => N ) Number of vars: 4
Number of cols: 4

And yes, these promotional codes are being used on the events.

Wordpress version: 3.7.1
Event Espresso version 3.1.32.2.P
Event Espresso Calendar, Multi Event Registration, Social Coupons and Requirements Check.
Site url: theFoodEvolution.com/classes/

  • This topic was modified 10 years, 4 months ago by  Ronise Stiefemann.
  • This topic was modified 4 years, 2 months ago by  Garth.


Tony

  • Support Staff

November 20, 2013 at 12:06 pm

Hi Ronise,

Has anything been changed within the Promotion code settings?

Editing a Promotion code, but not actually editing anything will throw that error.


Ronise Stiefemann

November 20, 2013 at 1:12 pm

Hello Tony,
No nothing has changed with the promotional codes.
You are right, just trying to edit the promotional code without changing anything gives the error, but why would they not show into the events?


Josh

  • Support Staff

November 20, 2013 at 1:23 pm

Hi there,

Can you go into the event editor and check to see if the “Allow Discount Codes?” option is set to Yes? It will look like this:


kcray

December 4, 2013 at 3:03 pm

I’m getting an error creating a promotion code.

Two Error codes. At the top of the page:
The discount code was not saved. Unknown column 'apply_to_all' in 'field list'.

Debug:
Array ( [coupon_code] => Sbird03 [coupon_code_price] => 100 [coupon_code_description] => This is a discount that sales can offer to any new detector purchasers who are interested in attending one of the Snowbird Workshops [use_percentage] => Y [apply_to_all] => 0 [wp_user] => 2 ) Number of vars: 6
Number of cols: 6

Then a database error displayed at the same time as above:
WordPress database error: [Unknown column 'apply_to_all' in 'field list']
INSERT INTO wp_events_discount_codes (coupon_code,coupon_code_price,coupon_code_description,use_percentage,apply_to_all,wp_user) VALUES ('Sbird03','100','This is a discount that sales can offer to any new detector purchasers who are interested in attending one of the Snowbird Workshops','Y',0,2)


Josh

  • Support Staff

December 4, 2013 at 4:55 pm

Hi kcray,

Can you try deactivating, then reactivating the Event Espresso plugin? It looks like the database update script needs to run.

The support post ‘Promotional Codes not working (2)’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso