timb111

In the templates, when I switch to the plain text editor then it removes all tags completely when I save the template. So this header template becomes blank as soon as it’s saved.
<select id="selectbox" name="">
And this main template gets turned into just the placeholder “#_STARTDATE”.
<option value="#_EVENTPAGEURL">#_STARTDATE</option>
Why is this happening and what can I do to fix this?

On the eme_filterform, I don’t see a date picker (like tours have on TripAdvisor) but it does give a dropdown list of months to filter the events list which is still helpful.

I found that the eme_calendar is more what I need as it looks and behaves more like what people would expect when booking tours. I think there might be a bug though. When I use the shortcode and restrict it by location ID, some date links go to the event page (which is what I want) but some date links go to the location page and show a list of all events in that location.

So on the calendar if I click on a date link, the URL is: https://mysite.co.uk/events/2020-09-02/?location_id=4 . On that date there is one event in location ID 4 and one event in location ID 2. The URL is clearly requesting the only event on 2nd September in location ID 4 and should go to the event page, but instead it just shows the location map and list of all events in location ID 4, exactly the same as displaying the shortcode [eme_location id=4] .

The calendar date links also behave in an inconsistent way when restricting the calendar by category_id, one date goes to the event page, another date goes to a list of all events on the selected date (ignoring category). Can you please check if these are bugs? Thanks

• This reply was modified 4 years, 6 months ago by timb111.

Thanks Franky, using what you suggested I’ve figured out how to make this work. I insert the events shortcode in a page and use templates:
[eme_events category=1 template_id=1 template_id_header=2 template_id_footer=3]

This outputs a dropdown selection list of available (event) dates:

<select id="selectbox" name="">
<option value="https://mysite.co.uk/events/test-event/">August 28, 2020</option>
<option value="https://mysite.co.uk/events/test-event-2/">August 29, 2020</option>
<option value="https://mysite.co.uk/events/test-event-3/">August 30, 2020</option>
<option value="https://mysite.co.uk/events/test-event-4/">August 31, 2020</option>
<option value="https://mysite.co.uk/events/test-event-5/">September 1, 2020</option>
<option value="https://mysite.co.uk/events/test-event-6/">September 2, 2020</option>
<input type="submit" onclick="javascript:location.href = this.value;">
</select>

It’s not a classic date picker but it’s still more user-friendly than a long list of event links. The only problem is that the generated HTML code is displayed literally and not treated as HTML because the tag characters are escaped:
& lt; select id=”selectbox” name=”” & gt;

(I’ve added spaces between & and lt; because this page keeps rendering it.)

Am I doing something wrong or is this a bug?

• This reply was modified 4 years, 6 months ago by timb111.
• This reply was modified 4 years, 6 months ago by timb111.
• This reply was modified 4 years, 6 months ago by timb111.

That’s great, so now I can link to a location page and it shows a list of events, one per day. The only issue is that I want to set up the daily tours to run from today until the end of the year, but it just shows a long list of events/dates. Is there some way to allow a visitor to select a date from a date picker and then take them to the event for that date to book?

I see that going to the URL https://mysite.co.uk/events/2020-08-29/ goes to a page that shows all events on that date. I’m wondering if I could use a JavaScript date picker that goes to the selected date by adjusting the URL. But is there a way to filter the list by location ID from the URL? Or by category ID, as I’m wondering if using categories for each tour might be better if I have 2 different tours in the same town.

• This reply was modified 4 years, 6 months ago by timb111.
• This reply was modified 4 years, 6 months ago by timb111.

Thanks Franky, I’ll look into this.

You’re right, I just found that the problem was with the .htaccess file and not EME. It’s all fixed now.

Sorry about that.

Hi Franky,

I found this happening on my other websites as well. On one website it happened just one time, on another website it happened a few times over a couple of days, and on another website it’s been happening around 2-3 times per day for several weeks now.

Regarding upgrading the EME plugin, I don’t normally like to upgrade my WordPress plugins continuously as I’ve had some website functionality break as a result of this, and I just want to create a working website one time and leave it like that. I hadn’t changed anything on these websites for several months, so nothing should have change to make this happen.

I have a Windows reseller hosting plan, and the websites are completely separate setups so one should not affect the others.

But one thing that was happening over the past year was that the hosting company was taking backups every night and it was making the websites non-responsive for around a half hour. I asked them if they could do this in a way that didn’t affect my websites but they were unable to change this. I wonder if this is connected to EME adding the sample events? Perhaps it was unable to read the tables and so created the events? If this is the case then I think that EME shouldn’t respond like that because my website visitors will see a number of strange duplicate events. I wonder if it would be better for EME to create sample events as drafts rather than live events, or for EME to ask the admin in the admin panel if they want to create sample events? That way it won’t affect live sites.

I’m now switching to a Linux hosting plan, just to see if things work any better, and I’m installing fresh instances of WordPress and EME, so let’s see if this issue comes up again.

The EME DB version is showing as 257. So does this mean that EME can detect the installed version, and if so then why is it creating the sample events and locations?

This was happening when I had a live event, before the Coronavirus lockdown. And even with a live event, EME was still creating additional sample events.

Is there some way to prevent the sample events being created? It’s creating 4 copies of each sample event and location every day, so again today I had to delete 8 copies of everything, and these sample events are being shown via an RSS feed onto another web site which is confusing people. Thanks

EDIT: about the SQL call, I’m not sure how to do that but I’ll ask for help to test it.

• This reply was modified 4 years, 9 months ago by timb111.
• This reply was modified 4 years, 9 months ago by timb111.

Ok, I haven’t changed or upgraded anything in the past 3 months or so. Where can I find the WordPress option? Is this in EME settings or in the database? And how can I fix this problem?

Ok yes, I’ve been told that by a friend as well ??

I spoke with my hosting company and they checked the database and said that EME should have full rights to the database and it should work fine. They said that I should try uninstalling EME and reinstalling it. So that’s what I’ll do.

Should I just uninstall EME from the WordPress plugins page? And will it also delete the tables and settings stored in the database? Is there any easy way to backup the EME settings or do I need to go through each tab manually and store each custom format that I’ve added?

Thanks

• This reply was modified 5 years, 3 months ago by timb111.

Thanks Franky, I’ll speak with my hosting company about this.

Yes the database user has full data and structure access, including Create.

I tried again to reset the EME DB version to 246 and checked the php_error.log and saw errors like this for every table:

[17-Nov-2019 00:22:21 UTC] WordPress database error Table 'mydb_eme_events' already exists for query CREATE TABLE mydb_eme_events (.....

If there was a permissions issue then would there be a different error, like unable to create column? But there were only the table already exists errors.

And this morning some people wanted to book for an event and the payment page was broken. I checked the log again and it showed these errors:

[17-Nov-2019 12:18:58 UTC] PHP Warning:  require_once(payment_gateways/stripe/stripe-php-7.3.1/init.php): failed to open stream: No such file or directory in D:\Inetpub\vhosts\mysite.co.uk\httpdocs\wp-content\plugins\events-made-easy\eme_payments.php on line 1353
[17-Nov-2019 12:18:58 UTC] PHP Fatal error:  require_once(): Failed opening required 'payment_gateways/stripe/stripe-php-7.3.1/init.php' (include_path='.;.\includes;.\pear') in D:\Inetpub\vhosts\mysite.co.uk\httpdocs\wp-content\plugins\events-made-easy\eme_payments.php on line 1353

Just for the payment page to be fixed again I changed back to version 2.1.47 and now the payments are working again.

What do you recommend? Thanks

Yes that’s right, I got the error in the older version, then tried updating to 2.1.49 this morning but still got the error.

I changed the EME DB version to 246 and clicked “Save” and then tried putting the anchor link in, but it gave the same error.

Then I updated to the latest version 2.1.51, and changed the EME DB version to 246 again and clicked “Save” and put the link in again, but still the error. After saving it shows the EME DB version as 257.

I spoke with my hosting company to check the permissions, and they guided me to the Plesk control panel where there’s just one database. I clicked on the only database user which is “wordpress_1” and it shows it has “Read and Write” permission. Below that, all of the checkboxes for structure access (select, insert, update, etc) are all ticked. So they said that WordPress and the plugins should all have full access to the database.

Is there something else that I can do to fix this?

Thanks

Yes sure, I’ll ask them.

Thank you

I was using an older version, and I’ve just updated to the newest version 2.1.47, and this has fixed it. The categories are now gone from the Event Info column.

Fyi in response to your other point, when I hover the cursor over the side of column titles it changes to a resize cursor but dragging doesn’t actually resize the width of the columns.

Thanks Franky!

Thanks Franky, it would look a lot better as here in the UK it’s normally first name then last name.

Have a nice evening!