[Lee]

Glad that worked for you!

I was getting some strange things happening when I tried, but I may have done something stupid! I’ll go back through and check the code, see if I can get it working too 🙂

[Lee]

Actually Ruanna, there’s a fix dtailed in another thread

Glad that worked Thomas, I’ve also got a patched copy of the widget file here: http://cl.ly/code/2g3x3R0c0z1s

Just replace the code in the file or the file itself in /wp-content/plugins/events-calendar-pro/views/events-advanced-list-load-widget-display.php

– Jonah

However…when I try to replace the entire file with this I get strange references in the widget where the start date usually is…

events-advanced-list-load-widget-display.php Direct link
Starts: September 23, 2012

See it in action here: http://awesomescreenshot.com/0a1gxd3ac

I’ve also tried to replace the code as Jonah suggested manually, but it just seems to remove the time, not the dates. Am I doing something wrong here?

Cheers
Lee
Edible Garden – Harvest Festival

[Lee]

+1 here on http://www.skootkidz.com, see the footer area, right-side where I’ve put the Advanced Upcoming Events widget.

Widget settings seem to work on/off for the other items, like showing venues etc, but it always shows the start AND finish time, regardless, which looks untidy.

[Lee]

No longer required.
I’ve moved the site to a dedicated VPS and everything is working as intended. Must’ve been a memory issue perhaps…1077 events records is the current number, so that must’ve pushed the query beyond the memory limits, certainly at the backend (WP Debug was reporting a 55MB memory usage on the query), and probably at the front-end too, because that seems to be working as intended now too, with the recurring events being shown from today, not two months ago.

[Lee]

Hi Joyce
1) yes siree, v3.4.1
2) Yes
3) I did, and it still didn’t work
4) Tried changing the theme, yes, and it still did the same.
5) Permalinks are already on postname
6) I tried this and made no difference
7) I’m on a shared host and the max they allow is 128MB, with a default of 64MB. I’ve increased it, but again, made no difference. It looks like the default settings are set to not allow large queries (over 1024 I presume). I’ve tried to set this default to 1 in the shared server config, but it hasn’t solved the problem. I’ve read that perhaps you can force the query to run a large query in the PHP of the plugin, but I’d need some help with that.

[Lee]

Checked with the host and this is what their support says:

MySQL will refuse to execute select statements that process a very large number of rows. You should either adjust your select statement to make it more efficient, or set SQL_BIG_SELECTS=1 in the session before executing the large select statement. Use something like this to do that ..

$db->sql_query(“SET OPTION SQL_BIG_SELECTS=1”);

Where would I alter this in the plugin code? I don’t think I can change this in the host config.

[Lee]

Ok so after some digging it seems there are two issues at play here, and one quality of life issue:
1) Recurring events are still showing in sequence i the calendar and the event list from the start of their recurrence through to the end, even when some events have passed. For example, a recurring event that started on the 9th June, repeating daily until 18th August, is today showing every event since the 9th June, even though the calendar is showing as August.
2) There seems to be a limit, I’m guessing of around 1000, to the number of events it is able to display in the editor screen. We’re currently sitting on 1064 published events, and it’s showing as blank, so I can’t see or edit the events from the back end. The only way I can get into them is through the “EDIT” link at the bottom of the actual front-end event page when I’m logged in.
3) A different problem, but I’m finding it annoying in this troubleshooting exercise…when you have just TEC enabled you can see the usual links for All, Published, Draft at the top of the editor. This lets me see the draft posts, for example, as I’ve only got 100 of those.
When I enable TECPro those links are replaced by the filter box, which can’t filter by draft, so I’m locked out of those, and due to the nature of this other issue, can’t see anything.
Is there a way to increase the number of records that it can query and show in the back end? Is that a function of TECPRo or is that the host SQL or PHP. I’ve got plenty of memory available…Debug bar is showing at 51MB for the query error.

[Lee]

OK debug bar installed…
this is the back-end problem
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
It looks like there’s a cap on number of records shown in the editor, right? Would this also be affecting the front end?
Thanks
Lee

[Lee]

Sorry…website is http://www.skootkidz.com/whats-on/
Might help1 🙂

[Lee]

Just a bit of help debugging why it always gives me the 20th March 2012 using the code…

tribe_get_day_link($year-$month-$day)

even though $day should be 17 or 18…

Which bit of code can I use to give me the correct URL format returned? The one you sent through originally was for a single event page, but it seemed to pick up the latest post I’d entered into WordPress, which wasn’t an event.

I tried using this one above instead, but the $day doesn’t seem to be calculating properly, it always gives me a 20, even though the dates I’m clicking on are the 17th March and 18th March

http://79.170.44.93/skootkidz.com/edinburgh/

Any ideas why it’s doing that please?

Cheers
Lee

[Lee]

Hi Jonah,

Updates for you! I’ve been looking through the documentation and found this piece of code

tribe_get_day_link(string $date)

I’ve put this one into the line instead of the tribe_get_event_list($post) part and it seems to be on the right lines, however I can’t seem to get it to generate the correct date.

What Iv’e done is this…

If I put this piece of code in

tribe_get_day_link($date)

it always returns the url /whats-on/1970-01-01/

If I put this piece of code in

tribe_get_day_link($year-$month-$day)

it always generates the url /whats-on/2012-03-20/ even though it’s not the 20th today and the dates I’m clicking on are the 17th and 18th. Both return the 20th.

We’re close!! i’m just not that much of a PHP guru to know what to use instead of $year-$month-$day to get it generate the correct URL, which should be

/whats-on/the date i’ve clicked on in year-month-day format/

Am I on the right lines?

Cheers again
Lee

[Lee]

Sorry…the links in the code have been applied to $day above…

[Lee]

Hi Jonah,

Thanks for the reply. I’m having issues with it however.

Here’s what I’ve done:
1) copied table-mini.php into a separate events folder (I presume as a backup, right?)
2) opened the original in TextWrangler on the Mac
3) my Line 90 is this one

$return .= “”;

However when I changed that I got all sorts of weird stuff happening. the popup tooltips were now in the calendar date boxes and the date numbers were all 1254, 1055 and so on.

So, I looked again…line 89 seems to be the one I think I need to change

$return .= ( count($monthView[$day]) ) ? “$day” : $day;

4) changed line 89 to the one in your github link

$return .= ( count($monthView[$day]) ) ? “$day” : $day;

5) this now has the effect of making the number clickable, but it always seems to generate the same URL, that of what looks like the latest post that I’ve entered into WordPress, so doesn’t take me to the date view.

6) I thought it might be because I’ve got All in One SEO rewriting canonical URLs so have disabled that plugin…still the same issue.

I’m not sure what it’s doing…it’s like this bit <a href='". tribe_get_event_link($post) ."' is returning the incorrect value.

You can try it on the link below if you like, it's a WIP development site for a client of mine. I'm using a child theme for a WooThemes design, Delicious Magazine. This site is part of a WPMU installation.

http://79.170.44.93/skootkidz.com/edinburgh/

Have a look at 17th and 18th March on the sidebar calendar.

Any ideas what is it doing?

Thanks in advance
Lee

[Author]

Posts