Friday, 04 November 2016
  1 Replies
  1.3K Visits
0
Votes
Undo
I got an error message "Unknown column 'jum.privateevent'" when I create/delete/modify event.


-----------------

An error has occurred while processing your request.

You may not be able to visit this page because of:

an out-of-date bookmark/favorite
a mistyped address
a search engine that has an out-of-date listing for this site
you have no access to this page
Go to the Home Page

Home Page

If difficulties persist, please contact the System Administrator of this site and report the error below.

1054 Unknown column 'jum.privateevent' in 'field list' SQL=SELECT ev.*, rpt.*, rr.*, det.* , CASE WHEN (jum.privateevent=3 AND jum.user_id!=585) THEN 'Private Event' ELSE summary END AS summary , CASE WHEN (jum.privateevent=3 AND jum.user_id!=585) THEN 'Details of this event are private' ELSE det.description END AS description , jum.privateevent , ev.state as state, ev.state as published , 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 (#__jevents_vevent as ev ) LEFT JOIN #__jevents_repetition as rpt ON rpt.eventid = ev.ev_id LEFT JOIN #__jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN #__jevents_rrule as rr ON rr.eventid = ev.ev_id LEFT JOIN #__jevents_icsfile as icsf ON icsf.ics_id=ev.icsid LEFT JOIN #__jev_attendance as atd ON ev.ev_id=atd.ev_id LEFT JOIN #__jev_invitees as inv ON inv.at_id=atd.id WHERE ev.catid IN(-1,18) AND ev.access IN (1,1,7,9,10) AND icsf.access IN (1,1,7,9,10) AND (atd.hidenoninvitees IS NULL OR ev.created_by=585 OR atd.hidenoninvitees=0 OR atd.invites=0 OR (atd.invites=1 AND atd.hidenoninvitees=1 AND inv.user_id=585 AND ((atd.allinvites=1 AND inv.rp_id=0) OR (atd.allinvites=0 AND inv.rp_id=rpt.rp_id)))) AND ev.ev_id = '12' GROUP BY rpt.rp_id LIMIT 1
Saturday, 05 November 2016 20:55
·
#178255
0
Votes
Undo
Please make sure your version of the User Specific Events plugin is up to date - there were some new releases in the last couple of days which should resolve this issue

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!

  • Page :
  • 1
There are no replies made for this post yet.