Support

Home Forums Event Espresso Premium Event set-up problem

Event set-up problem

Posted: July 2, 2014 at 8:28 am

Viewing 11 reply threads


Tom Williams

July 2, 2014 at 8:28 am

i have been trying to set up events–but i got this crash message: There is an automatic update for Espresso Permissions Pro available but your Site License Key is invalid. Either you have entered the wrong key on the Event Espresso General Settings page (EE3+ users) or Your Organization Settings page (EE4+ users) OR you no longer have access to the updates for this plugin. Please log into your account to manage your Site License Keys or purchase a support license now. [url=]Dismiss[/url] Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/event-management/update_event.php on line 354 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/event-management/update_event.php on line 363 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/event-management/update_event.php on line 376 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/event-management/update_event.php on line 389 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/event-management/update_event.php on line 423 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/event-management/update_event.php on line 423 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/event-management/update_event.php on line 439 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/event-management/update_event.php on line 503 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 WordPress database error: [Unknown column ‘term_reverse’ in ‘field list’] INSERT IGNORE INTO wp_relevanssi (doc, term, term_reverse, content, title, comment, tag, link, author, category, excerpt, taxonomy, customfield, type, taxonomy_detail, customfield_detail, mysqlcolumn) VALUES (484, ‘discount’, REVERSE(‘discount’), 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ‘post’, ‘a:1:{s:8:\”category\”;i:1;}’, ”, 0), (484, ‘tickets’, REVERSE(‘tickets’), 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ‘post’, ‘a:1:{s:8:\”category\”;i:1;}’, ”, 0), (484, ‘ticket’, REVERSE(‘ticket’), 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ‘post’, ‘a:1:{s:8:\”category\”;i:1;}’, ”, 0), (484, ‘deal’, REVERSE(‘deal’), 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ‘post’, ‘a:1:{s:8:\”category\”;i:1;}’, ”, 0), (484, ‘day’, REVERSE(‘day’), 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ‘post’, ‘a:1:{s:8:\”category\”;i:1;}’, ”, 0), (484, ‘million’, REVERSE(‘million’), 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘dollar’, REVERSE(‘dollar’), 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘quartet’, REVERSE(‘quartet’), 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘thursday’, REVERSE(‘thursday’), 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘july’, REVERSE(‘july’), 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘2014’, REVERSE(‘2014’), 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘map’, REVERSE(‘map’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘directions’, REVERSE(‘directions’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘register’, REVERSE(‘register’), 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘description’, REVERSE(‘description’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘smash’, REVERSE(‘smash’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘hit’, REVERSE(‘hit’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘musical’, REVERSE(‘musical’), 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘inspired’, REVERSE(‘inspired’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘famed’, REVERSE(‘famed’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘1956’, REVERSE(‘1956’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘recording’, REVERSE(‘recording’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘session’, REVERSE(‘session’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘brought’, REVERSE(‘brought’), 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘rock’, REVERSE(‘rock’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘roll’, REVERSE(‘roll’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘icons’, REVERSE(‘icons’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘johnny’, REVERSE(‘johnny’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘cash’, REVERSE(‘cash’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘jerry’, REVERSE(‘jerry’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘lee’, REVERSE(‘lee’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘lewis’, REVERSE(‘lewis’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘carl’, REVERSE(‘carl’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘perkins’, REVERSE(‘perkins’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘elvis’, REVERSE(‘elvis’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘presley’, REVERSE(‘presley’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘time’, REVERSE(‘time’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘legendary’, REVERSE(‘legendary’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘night’, REVERSE(‘night’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘life’, REVERSE(‘life’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘thrilling’, REVERSE(‘thrilling’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘features’, REVERSE(‘features’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘score’, REVERSE(‘score’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘hits’, REVERSE(‘hits’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘including’, REVERSE(‘including’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘blue’, REVERSE(‘blue’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘suede’, REVERSE(‘suede’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘shoes’, REVERSE(‘shoes’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘great’, REVERSE(‘great’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘balls’, REVERSE(‘balls’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘walk’, REVERSE(‘walk’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘line’, REVERSE(‘line’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘lotta’, REVERSE(‘lotta’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘shakin’, REVERSE(‘shakin’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘goin’, REVERSE(‘goin’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘hound’, REVERSE(‘hound’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘dog’, REVERSE(‘dog’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘don’, REVERSE(‘don’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘miss’, REVERSE(‘miss’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘chance’, REVERSE(‘chance’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘fly’, REVERSE(‘fly’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘wall’, REVERSE(‘wall’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘fame’, REVERSE(‘fame’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘open’, REVERSE(‘open’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0), (484, ‘run’, REVERSE(‘run’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0) Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/event-management/update_event.php on line 593 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 Event details updated for Million Dollar Quartet for 07/03/2014. Event Title Event Title Unique Event Identifier: Shortcode Short URL Full URL Event Description Add Media Add Coupon GMW Form [url=]Text[/url] [url=]Visual[/url] p View Event Duplicate Event Start Date July 3, 2014 Current Status: NOT_OPEN group.pngAttendees: 0/400 email_go.png Email Event Attendees

redacted

Delete all events in this series Attendee Limit: (leave blank for unlimited) Allow group registrations? Max Group Registrants: Additional Attendee Registration info? Advanced Options: Is this an active event? Event Status: question-frame.png Display description? Display registration form? Default Payment Status for Event: Alternate Registration Page (optional) question-frame.png Alternate Email Address (optional) question-frame.png Custom Ticket \n\n\n\n Add Featured Image Member only event? Ballet Dance Bluegrass Blues Boxing Broadway Musical Childrens Theatre Classical College Baseball College Basketball College Football College Hockey College Scoccer Comedy Country Dance Disco Drama Ethnic Folk Golf Horse Racing Jazz Late Night Show Major League Baseball Minor League Baseball Motor Sports Music Opera Performance Art Pop Rock Premium Tickets Pro Basketball Pro Hockey Pro Soccer Professional Football Rap Hip Hop Revues Sketch Improv Sports Theatre Manage Categories Early Registration Discount End Date: Amount: Percentage: (Leave blank if not applicable) Allow discount codes? question-frame.png Manage Promotional Codes Question Groups Add a pre-populated group of questions to your event. The personal information group is required for all events. Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/includes/functions/admin.php on line 1663 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147 Personal Information Address Information Question Groups Add a pre-populated group of questions to your event. The personal information group is required for all events. Personal Information Address Information Registration Dates Registration Start: Registration End: Event Dates Event Start Date Event End Date Registration Times

Reg Start Time Reg End Time

Event Times

Start 1 End
Start 2 End

Current Time : July 2, 2014 12:44 am Change timezone and date format settings? Would you like to apply any of the changes that you have made to this event to: Only this instance. All events in the series This and all upcoming events. Is this a recurring event?

Create dates automatically or select manually? question-frame.png
If you plan on using different registration dates for each event, please enter the First Event’s Registration Start/End Dates below. Otherwise, enter the registration dates that will cover all events in the series. Registration Starts On: Registration Ends On:
Are all events available between the registration dates above? question-frame.png No (each event’s registration start and end dates will be incremented according to a formula). Yes (all created events are available for registration between the above registration dates).
You can add as many days as you would like. Start with the very first event date. Event Date: to remove.gif Event Date: to remove.gifadd.png

Standard Pricing

Name 2 Price $ Surcharge Surcharge Type remove.gif

( enter 0.00 for free events, enter 2 place decimal i.e. $ 7.00) Member Pricing

Name 2: Price: $remove.gif

(enter 0.00 for free events, enter 2 place decimal i.e. $7.00) Note: A non-member price MUST be entered for each row, even if this is a member only event. Advanced Options Venue Information Select from Venue Manager list\n\n Virtual Location Phone: URL of Event: http://www.apollochicago.com Call in Number: Using Event Meta boxes question-frame.png

Key: Value: remove.gif
Key: Value: remove.gif
Key: Value: remove.gif
Key: Value: remove.gif

Send custom confirmation emails for this event? question-frame.png Use a pre-existing email ? question-frame.png OR Create a custom email: question-frame.png Add Media Add Coupon GMW Form [url=]Text[/url] [url=]Visual[/url] p View Custom Email Tags | Email Example Add/Update post for this event? If no, delete current post? Author: Tags: Post Categories:

All Categories
Most Used

Discount Tickets
Ticket Deal of the Day
Film
Music
Bluegrass
Blues
Classical
Country
Disco/Dance
Ethnic
Folk
Jazz
Pop/Rock
Pop/Rock
Rap Hip Hop
Sports
Boxing
College Baseball
College Basketball
College Football
College Hockey
College Scoccer
Golf
Major League Baseball
Minor League baseball
Motor Sports
Professional Basketball
Professional Football
Professional Hockey
Professional Scoccer
Theater
Ballet/Dance
Broadway Musical
Cabaret
Children’s Theatre
Comedy
Drama
Late Night Show
Opera
Performance Art
Revue
Sketch/Improv
Uncategorized
Advanced Ticket Desls
Coupons
Free Ticket Offers
Gift Certificates
Preview Ticket Deals
Subscription Offers

+ Add New Category

  • This topic was modified 10 years, 6 months ago by Lorenzo Orlando Caum. Reason: redact contact information


Lorenzo Orlando Caum

  • Support Staff

July 2, 2014 at 8:53 am

Hi Tom,

I’ve just rolled over your Support License Key and created a new one for you.

You can find it in your Event Espresso account:

https://eventespresso.com/users/theatrepatronsclub/

If you are using Event Espresso 3, please login to your WordPress admin and locate Event Espresso in the admin menu. Then click on General Settings. Scroll down to the bottom of the page and locate the area for Support License. Now copy the existing key. Then erase the existing key and click on Save Options. After the page refreshes, scroll back down to the Support License area and paste your key and click on Save Options.

These steps will refresh your Support License Key for Event Espresso and allow you to update.

Once this has been done, could you try updating your event again?


Lorenzo


Tom Williams

July 6, 2014 at 4:29 pm

I did all the steps you said-BUT it still doesn’t work–here is what i see when I view the event at : http://nationalticketclub.com/event-registration/?ee=142

Warning: Missing argument 2 for wpdb::prepare(), called in /home/nationt/public_html/wp-content/plugins/event-espresso/templates/registration_page.php on line 81 and defined in /home/nationt/public_html/wp-includes/wp-db.php on line 1147

How can I get the software to work?????
Tom Williams


Dean

July 7, 2014 at 2:31 am

Hi,

You are using Event Espresso version 3.1.28.4.P and WordPress 3.9.1.

Due to a change in a core WordPress function in WordPress 3.5 we were forced to update our plugin to allow it to continue to work.

You will need to update Event Espresso (the latest is version 3.1.36.5) in order to fix this issue.


Tom Williams

July 7, 2014 at 1:23 pm

So how do i update Event Espresso to 3.1.36.5? Can you do it for me? Why is this so hard?
Tom Williams


Tom Williams

July 7, 2014 at 1:26 pm

I just went to the Event Espress0 and I didn’t find a link to update it? How can I do that?
Tom Williams


Lorenzo Orlando Caum

  • Support Staff

July 7, 2014 at 2:33 pm

Here is information on manually updating:

https://eventespresso.com/wiki/updating-event-espresso/#update_manually

Be sure to backup before making any changes.


Lorenzo


Tom Williams

July 7, 2014 at 3:18 pm

i looked at the above instructions–and it calls for me to uploads a new version–where do i get that? “Click Choose File

Select the .zip file that you have just downloaded

Click the Install Now button”

Can you do that for me?

Why is this so hard?
Tom


Tom Williams

July 7, 2014 at 3:19 pm

Also, how do i do a “backup”? I have never done that before??
TW


Lorenzo Orlando Caum

  • Support Staff

July 7, 2014 at 3:31 pm

Hi,

This is a public forum. I’ve removed your login information but please go ahead and change your password.

Backing up your site before making any changes is a good practice:

http://codex.wordpress.org/WordPress_Backups

http://codex.wordpress.org/WordPress_Backups#Automatic_Backups

We do not provide update services at this time but its something that we may consider for the future.

You can download the latest version of Event Espresso from your account page:

https://eventespresso.com/users/theatrepatronsclub/#ee3-downloads

http://cl.ly/image/130g0k3k160P


Lorenzo


Tom Williams

July 7, 2014 at 4:01 pm

I think i got the event espresso updated–NOW-I just got this message:

Event Espresso – Calendar
Settings | Deactivate | Edit

A full calendar addon for Event Espresso. Includes month, week, and day views.
Version 2.2.3.p | By Event Espresso | Visit plugin site

There is a new version of Espresso Calendar available. View What’s New with version 2.2.4.p. You need a valid Site License Key to enable automatic upgrades. The key you have entered is invalid or expired. Please log into your account to manage your Site License Keys or purchase a support license now.

so what do I do now?
Tom


Dean

July 8, 2014 at 1:43 am

Hi Tom,

Your licence key has not been activated, please go to the General Settings and add it in there and save the options. If it has already been added, please check that it is correct and does not have any spaces before or after it. The licence key is in your account page here at eventespresso.com should you need to double check it.

Viewing 11 reply threads

The support post ‘Event set-up problem’ 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