Support

April 30, 2018 at 2:51 pm

Hi there,

I’m sorry I have very little information to know which way to advise. May I ask is the event published? Can you post a link to the event’s page so I can investigate further?

May 1, 2018 at 10:19 am

I’m afraid the screenshot doesn’t explain the inactive status. One thing you could try is making a few minor adjustments to the dates and times (for example change the end date it’s February 1 instead of January 31).

Also, you can try setting the event to Draft status, then click Update, the re-publish the event by clicking on Publish.

May 1, 2018 at 1:25 pm

Hi there,

So to confirm, you migrated the site over from EE3 and when checking the above event it shows inactive? No other changes were made to the event?

Are your other events working?

On the live site, can you take a screenshot of the ‘Event Date/Times’ section in the event editor for the ‘Capital Wine School Gift Certificate’ event, please?

This would be your EE3 site, not the event in EE4.

May 3, 2018 at 4:51 am

Ok, so the problem with that EE3 event is there’s no Event Date/Time time set on the event which has caused the migration to fail on that event.

The strange part is that if I setup a similar event in EE3 and migrate over I get the same setup and it shows the event as inactive, however, if I update the event EE recognises something is incorrect and fixes the datetimes for me (which in turn fixes the event).

The solution for this may be you need to reset and remigrate that event over (after setting and event date/time on the event in EE3 first) but I’d like to take a quick look at the database to see if I can spot the problem first, would that be ok?

If so you can send temporary login details using this form:

https://eventespresso.com/send-login-details/

Note to view the database I need to install a plugin and we don’t install plugins without FTP access so both are required unless you would like to provide a method to access the DB on the site, either is fine.

May 3, 2018 at 9:01 am

There’s quite likely a validation error preventing the form from submitting.

May 9, 2018 at 3:10 am

Ok, I had a look at the site and the reason the event would not change to published is the DateTime was marked as archived in the database, likely during the migration.

I’ve manually updated the datetime in the event and it now shows as Published with the tickets showing on the event itself, can you confirm if it’s working for you now, please?

May 10, 2018 at 5:45 am

Within the esp_datetime table the DTT_DELETED field was set to 1 for the datetime on that event, that indicates the datetime has been archived.

I changed that to 0.

If you click on the cog icon for the datetime in the event editor you can find the datetime ID, you then know which row to look for in the Database – http://take.ms/wc0MM