Cannot delete past calendars/events

Hello,

Sorry the logins are not working.

Did you empty the trash? If so, go into the configuration and click save and also check the the category events again.

Many thanks
Tony

Brilliant idea, and I'd love to, but I've not been able to find a trash can! Every post says to do this but none says where it is :-(

I've added different login details but they are mine so you might find I'm already logged in.

Hi I am really stuck now, cannot delete anything, All I get is the error in the attached png (error 807)

In a previous message you said to empty the trash. The only Trash I've been able to find is the one in Trashcan.png, attached . I can find no way to empty this so I assume I've not found the right thing. As a result I have Events, Calendars and Categories that I can't delete and I can't sensibly import a new CSV file.

I'm something of a newbie here so probably need more hand holding that most :-( I'm trying this on our Dev site prior to doing it to the Live site.

Hello,

Can I get phpmyadmin access please I am seeing an issue with the data and suspect an RRULE may have not been created which is causing this.

Many thanks
Tony

I access this via our hosting cPanel so I 'm not sure how I can give you access. I have some mySQL experience so perhaps I can do it if you talk me through it. We could Zoom and I could share my screen. Kirsten

Basically can you run:

SELECT ev.*, rpt.*, rr.*, det.* , 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 INNER JOIN #__jevents_repetition as rpt ON rpt.eventid = ev.ev_id INNER JOIN #__jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN #__jevents_rrule as rr ON rr.eventid = ev.ev_id INNER JOIN #__jevents_icsfile as icsf ON icsf.ics_id=ev.icsid WHERE ev.catid IN(-1,14,15,116,119,122,123,124,125,126,117,118,121,179,160,177,115) AND ev.access IN (1,2,3,5,6,8,9) AND icsf.access IN (1,2,3,5,6,8,9) AND ev.ev_id = '775' GROUP BY rpt.rp_id LIMIT 1

replacing: #_ with your database prefix?

and see what you get? Then try it without the repeat rule and what do you get?

I got an empty result-set : MySQL returned an empty result set (i.e. zero rows). (Query took 0.0007 seconds.)

Can you sen me the query without the repeat rule and I will try that.

I don't think there is an ev_id of 775. I have run the following

SELECT ev.* 

FROM jos_jevents_vevent as ev 

INNER JOIN jos_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid 

WHERE ev.catid IN(-1,14,15,116,119,122,123,124,125,126,117,118,121,179,160,177,115) AND ev.access IN (1,2,3,5,6,8,9) AND icsf.access IN (1,2,3,5,6,8,9) AND ev.ev_id <= '775' 

ORDER BY ev.ev_id DESC LIMIT 10 

and the highest event id seems to be 156

Using your query I have managed to find the names of the various jEvents tables (they do not show up in the list of tables in phpMyAdmin) so I have been able to see what's left in them and delete the orphaned data that way. The tables I have deleted all the data from are:

X_jevents_vevent, X_jevents_repetition, X_jevents_vevdetail & X_jevents_rrule. This now left a calendar that could be deleted within Joomla.

How come we ended up with a situation where we could not delete events within the jEvent component in Joomla?

Hello,

So we get the event to check if you are authorised to delete them and if not all maps etc exist then we fail to get the event.

It looks like on importing events you have had a corruption for it to be created like that. i.e. a badly formatted date.

Many thanks
Tony

Alas, this is not a question of corrupt data. I created an event from scratch and then tried to delete it again but I just get a screen full of output the start of which is shown below. Looking at the query I can see what is wrong, however. It does not use our database table prefix. eg #__jevents_vevent rather than jos_jevents_vevent.

ID: 1359string(988) "SELECT ev.*, rpt.*, rr.*, det.* , 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 INNER JOIN #__jevents_repetition as rpt ON rpt.eventid = ev.ev_id INNER JOIN #__jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN #__jevents_rrule as rr ON rr.eventid = ev.ev_id INNER JOIN #__jevents_icsfile as icsf ON icsf.ics_id=ev.icsid WHERE ev.catid IN(-1,14,15,116,119,122,123,124,125,126,117,118,121,179,160,177,115,180) AND ev.access IN (1,2,3,5,6,8,9) AND icsf.access IN (1,2,3,5,6,8,9) AND ev.ev_id = '1359' GROUP BY rpt.rp_id LIMIT 1" 

Could this be related to some of the extra components we have? I noticed this is not an issue on a second development site where we only have the free version of jEvents ie no Locations or custom fields.

This is getting quite urgent now as we need to upload the new program.