Support

How to use MER

Posted: October 23, 2013 at 2:31 pm


Akshay Pradhan

October 23, 2013 at 2:31 pm

I purchased ESPRESSO and multiple event registration add-on. I has error. Please advise.


Josh

  • Support Staff

October 23, 2013 at 2:54 pm

Hi there,

Can you let us know what the error is that you are having? Thanks!


Akshay Pradhan

October 23, 2013 at 4:21 pm

Add to cart does not do any good. It took to the screen where I can choose tickets. After it errorred out.


Akshay Pradhan

October 23, 2013 at 4:27 pm

I have an event where I ask people to register (one ticket) and add more tickets for food. The ticket can be for a group or individual. I need to store all info somewhere. Can I do it in MER-espresso?

I need to reproduce error.

Please advise if espresso has all these features.


Dean

October 24, 2013 at 3:30 am

Hi,

Can you please confirm what the exact error is?


Akshay Pradhan

October 31, 2013 at 12:29 pm

WordPress database error: [Table ‘osa2014wp.wp_events_detail’ doesn’t exist]
INSERT INTO wp_events_detail (event_code,event_name,event_desc,display_desc,display_reg_form,event_identifier,address,address2,city,state,zip,country,phone,virtual_url,virtual_phone,venue_title,venue_url,venue_phone,venue_image,registration_start,registration_end,start_date,end_date,allow_multiple,send_mail,is_active,event_status,conf_mail,use_coupon_code,member_only,externalURL,early_disc,early_disc_date,early_disc_percentage,alt_email,question_groups,registration_startT,registration_endT,reg_limit,additional_limit,recurrence_id,email_id,wp_user,event_meta,require_pre_approval,timezone_string,submitted,ticket_id) VALUES (‘2-5272a146b8f56′,’OSA-Registration’,’OSA Registration’,’Y’,’Y’,’osa-reg2-5272a146b8f56′,”,”,”,”,”,”,”,”,”,”,”,”,”,’2013-10-26′,’2014-07-06′,’2014-07-03′,’2014-07-06′,’N’,’N’,’Y’,’A’,”,’N’,’N’,”,”,”,’Y’,”,’a:1:{i:1;s:1:\”1\”;}’,’08:00′,’22:00′,999999,5,0,0,2,’a:9:{s:8:\”venue_id\”;i:0;s:28:\”additional_attendee_reg_info\”;s:1:\”1\”;s:28:\”add_attendee_question_groups\”;a:1:{i:1;s:1:\”1\”;}s:14:\”date_submitted\”;s:19:\”2013-10-31 14:28:22\”;s:22:\”default_payment_status\”;s:0:\”\”;s:13:\”event_hashtag\”;s:0:\”\”;s:12:\”event_format\”;s:0:\”\”;s:18:\”event_livestreamed\”;s:0:\”\”;s:0:\”\”;s:0:\”\”;}’,’0′,”,’2013-10-31 14:28:22′,0)

There was an error in your submission. The event was not saved! Please try again.

WordPress database error: []
INSERT INTO wp_events_start_end (event_id, start_time, end_time, reg_limit) VALUES (‘0′, ’08:00′, ’17:00’, 0)

WordPress database error: [Table ‘osa2014wp.wp_events_detail’ doesn’t exist]
SELECT e.id event_id, e.event_name, e.event_identifier, e.registration_start, e.registration_startT, e.registration_end, e.registration_endT, e.start_date, e.end_date, e.is_active, e.recurrence_id, e.wp_user, e.event_status, e.reg_limit, e.venue_title, e.phone, e.address, e.address2, e.city, e.state, e.zip, e.country FROM wp_events_detail e WHERE e.is_active = “Y” AND ( e.event_status = “A” OR e.event_status = “O” ) AND ( e.end_date >= “2013-10-31” OR e.event_status = “O” ) GROUP BY e.id ORDER BY e.start_date ASC, e.event_name ASC LIMIT 50 OFFSET 0


Akshay Pradhan

October 31, 2013 at 12:31 pm

While creating event, I got the above error.


Josh

  • Support Staff

October 31, 2013 at 2:01 pm

Hi Akshay,

Did the WordPress table prefix get changed after Event Espresso was installed? If so, the database table definitions in _options will need to be updated. Similar to step four in this guide, but specific to Event Espresso’s tables.


Akshay Pradhan

October 31, 2013 at 5:07 pm

I have not changed any prefix while installation. Please advise in details.


Akshay Pradhan

October 31, 2013 at 6:07 pm

I don’t see any table called wp_events_detail in the database. Do you have table creation scripts which I can run to create them?


Akshay Pradhan

October 31, 2013 at 7:00 pm

wp_events_detail and wp_events_attendee are missing so far. To reinstall plugin, do I need to clean up database? I have other plugins installed there. Let me know how to proceed.


Seth Shoultes

  • Support Staff

October 31, 2013 at 7:08 pm

Usually, deactivating and reactivating the plugin will install the necessary tables.

Just curious, what type of server is hosting this website?


Akshay Pradhan

October 31, 2013 at 8:25 pm

we are hosted by GoDaddy!


Akshay Pradhan

October 31, 2013 at 8:29 pm

I did deactivate and reactivate. But the tables still present in the database. Always
wp_events_detail and wp_events_attendee are missing regardless.

I can’t drop database or schema since other plugins are installed and website is LIVE now.


Seth Shoultes

  • Support Staff

November 1, 2013 at 12:28 am

Sorry about that. Ya, Godaddy is notorious for database problems and not updating their servers. I suspect the MySQL server is outdated or maybe permissions issues. We have a server requirements page here: https://eventespresso.com/requirements/

I will track down a database table export for you.


Seth Shoultes

  • Support Staff

November 1, 2013 at 12:42 am

Here are the Event Espresso tables in SQL.

http://s3.amazonaws.com/ee-screenshots/wp_events_table_install.sql.zip

The support post ‘How to use MER’ 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