Support » Plugin: Events Manager » Unable To Add Tickets

  • Resolved bobjgarrett

    (@bobjgarrett)



    I am unable to add tickets to either current events or new events.
    I am able modify tickets in current events.
    The message I get is:
    Your event details are incorrect and cannot be published, please correct these errors first:
    There was a problem saving the ticket.

    The square block against a ticket being added is grey and remains grey.
    I tried disabling all plugins and going to a default theme but the problem remained.
    This is a new problem as the software has worked correctly for some time.

    Could it be to do with the new timezone feature that I have not enabled?
    What can I do?

Viewing 10 replies - 16 through 25 (of 25 total)
  • Plugin Support angelo_nwl

    (@angelo_nwl)

    at the moment we are unable to replicate this issue on our test server; did you already check your php logs to see if there’s any other error?

    bobjgarrett

    (@bobjgarrett)

    Good thought, I had not had!

    I just tried to add a ticket and then checked the log to find:
    [23-May-2018 10:11:01 UTC] WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_em_tickets (ticket_id, event_id, ticket_name, ticket_price, ticket_spaces, ticket_members, ticket_guests, ticket_required) VALUES (0, 97, ‘Standard Ticket’, 0.000000, ’10’, 0, 0, 0) made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, EM_Event_Post_Admin::save_post, EM_Event->save_meta, EM_Tickets->save, EM_Ticket->save
    [23-May-2018 10:11:01 UTC] WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_em_tickets (ticket_id, event_id, ticket_name, ticket_price, ticket_spaces, ticket_members, ticket_guests, ticket_required) VALUES (0, 97, ‘test ticket’, 0.000000, ’10’, 0, 0, 0) made by edit_post, wp_update_post, wp_insert_post, do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, EM_Event_Post_Admin::save_post, EM_Event->save_meta, EM_Tickets->save, EM_Ticket->save

    What does this suggest?

    Plugin Support angelo_nwl

    (@angelo_nwl)

    would it be possible to reset EM under Events > Settings > General > Admin Tools > Uninstall/Reset ?

    bobjgarrett

    (@bobjgarrett)

    I will be able to do this in a couple of weeks when we have no events open for bookings. Is there an easy way to restore all the other user settings after doing a reset?

    I have now tried the Reset after carefully doing a backup and storing all my settings so I could re-enter them again afterwards.
    Having done the reset I was still unable to add tickets to events or create new events containing tickets. The error reported was the same.
    This was before I re-entered all my settings.
    So, where do we go from here. I really don’t want to uninstall and reinstall if it can be avoided as I will lose all events in the past and future.

    patrikcarlsson80

    (@patrikcarlsson80)

    Hi,
    i have the exact same problem. And this is a totaly new and clean installation.
    I can add an event but i cant add tickets to it. i get the exact same error:

    “Your event details are incorrect and cannot be published, please correct these errors first:
    There was a problem saving the ticket.”

    I have also inactivated all the plugins except EM. Still not working…

    WordPress: 4.9.7
    PHP version: 7.0.6
    mySQL: 5.5.5-10.1.29-MariaDB

    pls help!

    ——–
    Edit:1
    I have narrowed it down to i cant edit tickets…
    I can add a ticket the very firt time i add one. To edit i need to uncheck “enable registration” for this event.
    than i have to update. Then i can check “Enable registration for this event” again, add a new ticket and this is saved.
    BUT! Still, when i try to make a booking on the front end i still get “Missing field: ticket_id”
    ———

    patrikcarlsson80

    (@patrikcarlsson80)

    Now i have come to the point and checked the database, and the table _em_tickets has one post. with id 0…
    I changed this id to 1, and now it works.
    I think this is not a thing i would need to do when start using a plugin.

    Plugin Author Marcus

    (@netweblogic)

    Whilst this isn’t a bug everyone seems to be seeing, I’ve seen another couple of reports with that same SQL error. I think it might be related to the MySQL version.

    Regardless, we added a line to the latest dev version that should fix this problem. Could you try the latest dev version? To upgrade, it’s much like updating your plugin with a few extra clicks, as per these instructions.

    This seems to have fixed the problem. Thank you.
    Is it safe to continue use of this development version pending what I assume will be a new release?

    Plugin Author Marcus

    (@netweblogic)

    Yes indeed. Normally anything in the dev version just gets added to until we package it as a release (i.e. more bugfixes, new features etc.). You could think of it like a small release.

Viewing 10 replies - 16 through 25 (of 25 total)
  • You must be logged in to reply to this topic.