Support

September 9, 2014 at 8:12 am

Hi Sean,

Can you tell me what the Default Registration Status is on that event please?

Also which version of EE4 are you currently running?

September 9, 2014 at 8:34 am

There was a bug in 4.2.X that was fixed in 4.3.0 in that if the Default Registration Status was set to Approved a registration would apply to the sold value before any registration details has been entered.

If you check the total ‘Sold’ value of your tickets does this equal 50?

Could you provide a screenshot of your ticket editor within that event?

September 9, 2014 at 9:29 am

You need to use a photo sharing site like flickr and upload your screenshot to them for hosting, then post in a link to it here.

Some screenshot software such as Monosnap will manage that for you.

Services like flickr and Monosnap are much better equipped to handle your images than we are.

September 9, 2014 at 4:36 pm

Hi,

That screenshot appears very small and we can’t see the details:

http://cl.ly/image/1l0h2z3U323u

Could you try again or email the original screenshot to the email below:

support [at] eventespresso.com

If you send an email, please be sure to include a link to this support post here:

https://eventespresso.com/topic/sold-out-or-not-wee4/

—
Lorenzo

September 10, 2014 at 10:41 am

Hi Sean,

That’s caused by the bug mentioned previously.

If users selected a ticket, clicked ‘Register now’ but then didn’t proceed, those tickets would could towards the ‘Sold’ values for the Ticket and the Datetime.

Do you have access to phpMyAdmin or similar?

Before going any further you’ll need to make a backup of the database. We have a guide on how to do this here:

https://eventespresso.com/wiki/how-to-back-up-your-site/

Once you have a backup I can instruct you on how to fix this through phpMyAdmin.

September 10, 2014 at 11:17 am

Within the database find the table:

*prefix*_esp_datetime

Usually the prefix will be ‘wp’ but it may not be.

Within there you’ll need to find the datetime for your event, depending on how many events you’ve created this may be troublesome. Match up the dates/times with your event (as your ticket has no name).

Once you’ve found it change the DTT_sold value to match your registrations. Which appears to be 38. Here’s an example from my table – http://take.ms/66odX

Then you need to do the same for the ticket, so go to the *prefix*_esp_tickets table, find your ticket within that table and change the TKT_sold column to match your registrations.

Then refresh the Event Editor page (or navigate to it if you’ve closed it) and check the values have changed. You may also need to Update the event so that EE will recheck your Event Status.

Just be sure you have a backup and make sure you edit the correct datetime and ticket within the tables and it should work fine.

As mentioned this bug has been fixed within 4.3.0+ so as long as you continue using versions above that you should not need to do this again.

September 10, 2014 at 3:00 pm

Its not actually when the event was created but no there should be no more issues.

Basically when you selected your tickets and confirmed (before entering any details) with the default registration set to approved it would trigger the function to add the ticket values to those columns in the db. We changed the way that works to prevent this in 4.3.0 so as long as u use 4.3.0 or above you should not see this issue again.

I’m glad this solves your problem 🙂 be sure to edit the correct values and to input the correct amount of registrations for the correct event (sounds obvious but very easy to confuse these so good to double check)

September 10, 2014 at 5:10 pm

Hello,

If this support post is resolved, then please update the status to resolved.

—
Lorenzo