Unable To Add Tickets

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?

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?

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

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.

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”
———

• This reply was modified 6 years, 7 months ago by patrikcarlsson80.
• This reply was modified 6 years, 7 months ago by 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.

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?

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.