Support

Home › Forums › Event Espresso Premium › WordPress Database Error

WordPress Database Error

Posted: July 2, 2012 at 11:46 am

Viewing 6 reply threads


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 12 years, 6 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 12 years, 5 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!
Viewing 6 reply threads

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.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: closed

Updated by kbzz 12 years, 5 months ago ago

Topic Tags

Notifications

This topic is: resolved
Event Espresso