All ProEvent tables in the DB start with btProEvent

Thanks I have cleaned up all the generated events.

I still seem to have almost a thousand events that were not part of that clean up.

Looking into it it seems that they are pages. Is there an automated job that can be used to clean up expired pages?

Thanks

You could go to the sitemap and go to the Page Search part. There you can filter by page types and date added. That should allow you to list most of them. Make sure you customize your search to show you more than 10 results. Once listed, you can batch delete them.

I never thought of doing it this way thanks.

Is there a way to change search terms from equals a date to less than or between 2 dates?

Currently when I select the event dates from the drop down I only see a single text box for filtering. How would I change the search to make it like when you search for date added and you get multiple search conditions?

It seems that the proevents Event Dates is an attribute multi_date and the other dates that allow for searching in date ranges are of type date_time. I'm thinking that if I can find the code for the page search I can maybe make a change there to allow for the same searching.

he way you can filter by an attribute type is built in the attribute itself. If what you want was not added by the developer then it's not possible.

Maybe you could use the page's date_added field instead. I'd say filter by the latest event date you know you want to remove and check on which date that page was added.
Then you might be able to assume safely that any page added before that date is for older events.

Obviously only an assumption which really depends on how the system was used.

Getting the following error when I try and add the event date to the results

Class 'Concrete\Package\Proevents\Attribute\MultiDate\TimeHelper' not found

Any Ideas?

you're going to have to edit a file in the package. Open packages\proevents\attributes\multi_date\controller.php
Around line 58 remove this line

IT'S WORKING!

1000 thank yous and blessings be upon you mustache.

Well almost now I'm getting weird stuff coming out as the value of the event date
example:

WedPMESTE_PM-05:00-05:00_WedPMESTE_-05:000CKER 19:00 pm

That I must admit doesn't mean anything to me as well. Does it stop you from deleting the pages you need to delete?

Yes I can still delete. I also run a script before doing the select to change the attributes of the event_dates to allow for searching

UPDATE *databasename*.attributekeys
SET atID = 4 ,
pkgID = 0
WHERE akID = 33;

Then switch it back after to avoid any issues.