Skip to content

Instantly share code, notes, and snippets.

@lorenzocaum

lorenzocaum/new_gist_file.md

Created January 21, 2015 03:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lorenzocaum/68d5029ebd0311559a2a to your computer and use it in GitHub Desktop.
Save lorenzocaum/68d5029ebd0311559a2a to your computer and use it in GitHub Desktop.
Download ZIP
How to release an archived ticket in Event Espresso 4
Raw
new_gist_file.md

Event Espresso 4 will archive a ticket under the following conditions:

  1. There is at least one registration

  2. The price is changed for the ticket option

Editing the name, datetimes, or quantity will not archive a ticket. Editing the price when there is at least one existing registration will trigger archiving of the ticket.

You can override an option via the WordPress database to release the ticket. If you are not comfortable with working with the database then check with a WordPress professional.

Notice: making these changes on a live site is not recommended. Only apply these changes if you are testing Event Espresso 4 on a new installation and need to release an archived ticket before taking the site live (production mode).

Step 1) Backup your WordPress site including the database

Step 2) Go to the event that has the archived ticket in your WordPress dashboard: Event Espresso --> Events. Locate your event and click on the name. Then scroll to the ticket area and make a note of the ticket name (e.g. General Admission).

Step 3) Login to your database using a tool like PHPMyAdmin, Adminer, or an equivalent tool

Step 4) Browse to dbprefix_esp_ticket (e.g. wp_esp_ticket).

Step 5) Locate your ticket in the list. You may need to adjust the pagination to show more rows or switch to the next page. After you have found your ticket, click on it.

Step 6) You'll then see a screen that appears similar to this:

http://cl.ly/image/2w391e0A0x0S

Step 7) The archive option is controlled by TKT_deleted. If TKT_deleted is set to 1, then that ticket is archived. If it is set to 0, then it will not be archived.

Change the 1 to a 0 (http://cl.ly/image/3U2Q1E2k1v3H). Then click on Save.

Step 8) Return to your event editor from step 2 and refresh the page. You should now see your ticket and it should be available for editing.

You can then close out PHPMyAdmin, Adminer, or the tool that you are using to work with the database directly.

@lorenzocaum
Copy link
Author

References:

https://eventespresso.com/topic/delete-locked-tickets/
http://eventespresso.com/topic/ee4-ticket-locking/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment