Events not visible in backend when created!

[Tonyp]

Hello,

Can you check the multi-category setting in JEvents, and change it from what it currently is an save, does this now resolve the issue?

[buttman]

I tried that already. After turning multi-category events on and later on trying to display events in the backend, I get this:

Code: Select all

Unknown column 'rpt.eventid' in 'on clause' SQL=SELECT ev.*, ev.state as evstate, detail.*, ev.created as created, max(detail.modified) as modified, a.title as _groupname , rr.rr_id, rr.freq,rr.rinterval FROM clc3j_jevents_vevent as ev LEFT JOIN clc3j_jevents_vevdetail as detail ON ev.detail_id=detail.evdet_id LEFT JOIN clc3j_jevents_rrule as rr ON rr.eventid = ev.ev_id LEFT JOIN clc3j_viewlevels AS a ON a.id = ev.access LEFT JOIN clc3j_jevents_catmap as catmap ON catmap.evid = rpt.eventid LEFT JOIN clc3j_categories AS catmapcat ON catmap.catid = catmapcat.id WHERE catmapcat.access IN (1,1,2,3) AND catmap.catid IN(-1,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41) AND 1 ORDER BY detail.dtstart asc LIMIT 0, 10


When I turn it off, 'Events' button works again, but still only one event is visible.

[Geraint]

I suspect you have created events with a LOT of repeats - and have gone over the 'large data set' threshold.

Can you edit the JEvents config and increase the large data set criteria to 200000 from the default 100000 at the bottom of the second tab.

Geraint

[buttman]

Spot on! This solved my problem. Thank you SO much!