Support

Home Forums Event Espresso Premium WordPress Database Error

WordPress Database Error

Posted: July 2, 2012 at 11:46 am


kbzz

July 2, 2012 at 11:46 am

Just started using the premium version of Event Espresso. When I try to submit a new event, I get this message:

WordPress database error: [Unknown column ‘ticket_id’ in ‘field list’]

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

WordPress database error: [] INSERT INTO 5312_FreedomSchoolPartners_events_prices (event_id, event_cost, surcharge, surcharge_type, price_type, member_price, member_price_type) VALUES (‘1173’, ‘0.00’, ‘0.00’, ‘flat_rate’, ‘General Admission’, ‘0.00’, ‘Members Admission’)

Any help would be greatly appreciated.

  • This topic was modified 11 years, 11 months ago by  kbzz.


Josh

  • Support Staff

July 2, 2012 at 2:04 pm

Had you updated from another version? Or is this a new install?


kbzz

July 2, 2012 at 2:16 pm

I had the lite version installed, then I installed and activated the premium plugin and deactivated lite.

  • This reply was modified 11 years, 11 months ago by  kbzz.


Chris Reynolds

  • Support Staff

July 2, 2012 at 2:23 pm

It sounds like some of the database tables did not get set up correctly. What version of the Lite plugin were you using? Do you have access to phpMyAdmin?


kbzz

July 2, 2012 at 2:28 pm

Thanks for your help – version 3.1.20.L.

Yes, I have access to phpMyAdmin.


Chris Reynolds

  • Support Staff

July 2, 2012 at 2:49 pm

Try adding a new column called ‘ticket_id’ to your 5312_FreedomSchoolPartners_events_detail database table in phpMyAdmin. You can also try just deactivating/reactivating the plugin to see if the tables are created on activation (in fact, try that before manually adding the column). Before making any database changes, you’ll want to create a backup of your db just in case.


kbzz

July 3, 2012 at 7:48 am

I added the column and that seems to have worked – thanks a ton!

The support post ‘WordPress Database Error’ 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