That would not be a correct primary key. The installation script already created a unique index. Perhaps it should have been a composite key, but unique key should work. In anycase, the unique key or composite primary key needs to be on eventid, ocdate, and userid. Otherwise, when you have a ranged or recurring event, the REPLACE INTO will overwrite any other RSVPs for that user on other days of the event.

The installation script makes this statement:

That should do it. Did your installation not have a unique key called uq_eventattendance__eventuser, as the one above?

No it didn't have that unique key. I checked your installation scripts with the product manager and I found the create-statement there. So that's really strange.
However, it works now, so everything's fine :-)
I'm using Mysql 4.0 and vBulletin 3.6.1, maybe that was the problem?!?

Thanks,
Toewalker

Does anyone know if I could incorporate this hack with the form hack here:

https://vborg.vbsupport.ru/showthread.php?t=126676

Instead of people being able to post whatever they wanted in the new event, I'd like to use a form instead so every event is uniform and allows people to search for certain characteristics within an event.

Chris

Ravencr,

No, the form hack will not create a new event, so it will not work with this hack. Have you considered using calendar fields? That would allow you to setup certain standard fields for the event poster to fill in.

Where do I find out more about Calendar Fields? Thanks so much for the help,

Chris

In AdminCP panel for this MOD the RSVP Expiration options reads:

"Do you want to prevent members from signing up for an event on or before the event date (specified at the time the event is created)?"

If this is toggled to NO, is there anyway to implement it after the event is posted, w/o having to re-create new events after toggling it to YES?

why cant i uninstall this hack?? i can disable it, but i want to uninstall it... it gives me an error every time

no worries... got it...

Where do I find out more about Calendar Fields? Thanks so much for the help,

Chris

When showing multiple events on the same day at the same time I'm getting count errors.
Compare 9AM Run vs. the 9AM run here. It's not a huge deal but I thought I'd point it out. We love this mod, and thank you for all of your hard work.

ravencr: AdminCP > Calendars > Edit a Calendar