Support

August 6, 2013 at 9:15 pm

Hi Greg,

I don’t believe so. My test calendar is outputting the CSS classes for categories. It’s running a stock version of the current calendar add-on.

http://is.gd/W6GaAT

There are two Calendar Settings that will affect this, so you might try checking them in Event Espresso>Calendar Settings. The first one is “Enable CSS for Categories”. This one needs to be set to Yes.

The second one is “Disable Categories”. This one needs to be set to No.

August 7, 2013 at 11:01 am

I do not. Can you let us know which version of the calendar add-on you are using? Also, what is the shortcode on the calendar page? For example are there any category parameters added to the shortcode?

One thing that may help in this case is you could try changing the two settings that configure the category options, then save, then change them back and save to be sure the settings are saved correctly.

August 7, 2013 at 7:41 pm

It might be limiting out on the # of queries (pulling from the category table for each event can make a difference) Right now it’s showing 1177 queries. If you try changing the shortcode to [ESPRESSO_CALENDAR show_expired=”false”] it will reduce the # of queries and you might get the category classes back.

August 7, 2013 at 8:00 pm

You could try downloading and installing a fresh copy of the Event Espresso Calendar add-on. That’s the code i’m running on my test sites and the category class names are working there.

August 9, 2013 at 5:23 am

Hi Greg,

I checked and the calendar is displaying from my end. I can imagine that if you go from the new calendar to the old calendar the reset settings box would need to be checked in order to restore the old calendar’s default settings in the database.

With the category colors not working: Has there been any new events or event categories added between now and the time the colors stopped working? You could troubleshoot this by creating a new page and use the event_category_id parameter in the [ESPRESSO_CALENDAR] shortcode to show events from one category. That might help narrow things down if there’s an issue with one of the categories.

August 12, 2013 at 8:25 am

It still seems like it’s hitting a query limit. What happens to the colors on the main calendar page if the event times, tooltips, and registration limit features are disabled?

August 12, 2013 at 3:35 pm

I can squeeze a little more efficiency out of it, if you would like to try it. In espresso-calendar.php starting at line 343:

$orig_attendee_limit = get_number_of_attendees_reg_limit($event->id, $type = 'num_attendees_slash_reg_limit');
			$parse_limits = explode( '/', $orig_attendee_limit, 2 );
			$num_completed = $parse_limits[0];
			$reg_limit = $parse_limits[1];

you can change it to:

$num_completed = 0;
				$a_sql = "SELECT SUM(quantity) quantity FROM " . EVENTS_ATTENDEE_TABLE . " WHERE event_id=%d AND (payment_status='Completed' OR payment_status='Pending' OR payment_status='Refund') ";
				$wpdb->get_results( $wpdb->prepare( $a_sql, $event_id ), ARRAY_A);
				if ($wpdb->num_rows > 0 && $wpdb->last_result[0]->quantity != NULL) {
					$num_completed = $wpdb->last_result[0]->quantity;
				}
$reg_limit = $event->reg_limit