List by Category issues

Hello,

1. Where did you include this load module text?

2. Can you enable debug mod and see the query?

Many thanks
Tony

Hi,
1. I included it in jEvents Category description. The content is only

{loadmodule mod_custom,Onslow Village Hall}

Having some text first makes no difference.

2. I have enabled debug mode on our development server but there are 28 logged queries and I have no idea which one you are after.

Working fine here, please make sure you have set the module applies to all pages or the menu items you want it applying too.

Many thanks
Tony

The module is only displayed on some pages as it was in a visible position used for a different menu item. However, having the module available on all pages does not seem to help.

I have added menu items for the sub-category. I have created a new module which is available on all pages. I have added this module to the category description. This module still doesn't display properly.

{loadmodule mod_custom,Onslow Village Hall v2}

This used to be OK but has only recently changed.

The other issue is that when you click the link to the category in the event description it now shows no event. This can be seen for our coach trips. Looking at 'Events' there's a list of all the different categories of events. Scroll down to 'Other' 'Coach Trips' there are two events listed. Click on one of them. Then click on the lick to the category 'Coach Trip' at the bottom and there are now no events showing. You can also see that the plugin for google maps is not rendered.

Hello,

Nothing has changed in JEvents for this to stop working. I just tested and created custom module and used the title {loadmodule mod_custom,Onslow Village Hall v2} and it's included as you would expect. Given it is working in our systems it looks to be an issues caused by something on your site. Unfortunately we only provide on site testing for non-core issues for our Silver members.


This is what I see when clicking the category at the bottom of the page:
https://www.dropbox.com/s/nerqz3pe5999puj/Screenshot%202018-04-19%2008.49.48.png?dl=0

Many thanks
Tony

That shows the problem with the module not being rendered.

It only works if you go direct to the event via the link 'Events' -> 'Talks' -> 'Talks at Onslow Village Hall', and the click the Category link. It does not work if you go to the detail page using the link from the 'Events'-> 'Talks'
http://group.rspbguildford.org.uk/events/talks

When you click the link on the events details page now, the link generated is different as you can see from the screenshot included.

This is the normal way to get to the details and the extra menu item was only added for testing.

I don't know why adding a module to a category description no longer works. I used to work OK, I have no idea where else to look.
Loding a module seems to work OK within the description of an event.

Is there an option for a semo login to the admin area of the demo so I can see how you have added a module to the description of a Category?

Hello,

Which would indicate you have not applied the module to that link. We render both event details through the same mechanism.

So are you saying if you add a module into the category description and render the category description in the event details it's not shown even though the module is set to show on all pages?

There isn't admin logins I am afraid. What page is it on?

Many thanks
Tony

I don't understand what more information you want.

There are two issues

1. Module included in category description renders as text and doesn't load the module
   
2. When click a link to category on an events details page when reached that page from a parent category it says no events found.
   

1. Module not loading in category description

Yes I have a module included in the category description.

This page should show all events for the category with the category description above.
http://group.rspbguildford.org.uk/events/talks/talks-at-onslow-village-hall


It shows that the module is not included in the category description but rather the code for the module is shown instead.

Lodaing a module here



{loadmodule mod_custom,Onslow Village Hall v2}

2. No events found

There is also an issue when I click on the link to the category on an event details page when I have got to that event details page from a higher level category list of events. It doesn't find the events for the category.

Eg talks have 2 subcategories and the menu item shows all talks.
http://group.rspbguildford.org.uk/events/talks

If I click on one of the talks in the list (only 1 at the moment) I get to this page
http://group.rspbguildford.org.uk/events/talks/eventdetail/86/-/undiscovered-norfolk

If I then click on the category link (this shows the category of the event which is a subcategory of the page showing the list initially) at the bottom of this page I get this page

http://group.rspbguildford.org.uk/events/talks/eventsbycategory/30
This now says no events.

I hope this makes it clear what my problem is.

Open: //components/com_jevents/views/flat/cat/tmpl/listevents_body.php

change:

            echo "<div class='jev_catdesc'>" . $data ['catdesc'] . "</div>";

to:

            echo "<div class='jev_catdesc'>" . JHtml::_('content.prepare', $data ['catdesc']) . "</div>";

How's that work for you now?

Many thanks
Tony

Thanks, Thanks just what was needed. That solved my first issue about component not being rendered in a category description. I assume you will add this fix the the next update and include it for all the other calendars too.

My second issue (No events found when there are events) still remains as you can see from these links.

1. https://rspbguildford.org.uk/events/talks

Click to see details of talk.
2. https://rspbguildford.org.uk/events/talks/eventdetail/72/-/annual-general-meeting

Then click the category link (Talk at Onslow Village Hall) at the bottom left
3. https://rspbguildford.org.uk/events/talks/eventsbycategory/30

This is a problem when you have a menu item to show a list of events in a category and all it's subcategories. When you go to one of the events listen the link back to the category is based on the top level category and not the category the event belongs to (as can be seen by looking at the url for the link).

Hello,

No problem I have included that for the next JEvents Release.

that is strange, can you enable debug mode and find the events query and paste it here from the one which doesn't show events.

Many thanks
Tony

I have enabled the debug mode again on our development site.

Here is a link to the page

http://group.rspbguildford.org.uk/events/talks/eventsbycategory/30

The catoegory ID of 30 is correct and it shows the correct category description.

There are a lot of queries and I don't know which one you want to see. Here is the one that use the number in the link

SELECT c.id

  FROM jos_categories AS c

  WHERE c.access   IN (1,1,5) 

  AND c.published = 1 

  AND c.language in ('en-GB','*')

  AND c.extension = 'com_jevents'

  AND ((c.lft>=61 

  AND c.rgt<=66 ))

  ORDER BY c.lft asc

In case this is not the query you are looking for I have provided the link (above) to the page that shows no events so you can check the other queries.

If I go straight to the event list from the menu
http://group.rspbguildford.org.uk/events/talks/talks-at-onslow-village-hall

the query is

SELECT c.id

  FROM jos_categories AS c

  WHERE c.access   IN (1,1,5)

  AND c.published = 1

  AND c.language in ('en-GB','*')

  AND c.extension = 'com_jevents'

  AND ((c.lft>=62 

  AND c.rgt<=63 ))

  ORDER BY c.lft asc

And this shows that there is an event.

Ok so it finds the master event:

SELECT count(DISTINCT rpt.rp_id) as cnt

 

  FROM jos_jevents_vevent as ev 

 

  LEFT JOIN jos_jevents_icsfile as icsf 

  ON icsf.ics_id=ev.icsid

 

  LEFT JOIN jos_jevents_repetition as rpt 

  ON rpt.eventid = ev.ev_id

 

  LEFT JOIN jos_jevents_rrule as rr 

  ON rr.eventid = ev.ev_id

 

  LEFT JOIN jos_jevents_vevdetail as det 

  ON det.evdet_id = rpt.eventdetail_id

 

  WHERE ev.catid IN(-1)

 

  AND icsf.state=1 

  AND rpt.endrepeat >=  '2018-05-01 00:00:00' 

  AND ev.state=1

But then doesn't find the repeats

SELECT ev.*, rpt.*, rr.*, det.* 

 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup

 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn

 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup

 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn

 

  FROM jos_jevents_vevent as ev

 

  INNER JOIN jos_jevents_icsfile as icsf 

  ON icsf.ics_id=ev.icsid

 

  INNER JOIN jos_jevents_repetition as rpt 

  ON rpt.eventid = ev.ev_id

 

  LEFT JOIN jos_jevents_rrule as rr 

  ON rr.eventid = ev.ev_id

 

  INNER JOIN jos_jevents_vevdetail as det 

  ON det.evdet_id = rpt.eventdetail_id

 

  WHERE ev.catid IN(-1) 

  AND rpt.endrepeat >=  '2018-05-01 00:00:00' 

  AND ev.state=1

  

  AND icsf.state=1

 

  AND ev.access IN (1,1,5)

 

  GROUP BY rpt.rp_id 

  ORDER BY rpt.startrepeat asc, rpt.endrepeat ASC, det.summary ASC

because it's looking in catid -1. Which doesn't make any sense.

Can you provide FTP and super user logins to your site and I'll take a look.

Many thanks
Tony

Thanks I have provided access

geraint can you take a look at this please? It's down to the multi-category support and parent categories.