Event limit and Event Dates issue
Permalink Browser Info Environment
Hi,
I'm struggling a bit with three issues.
1. When I add Event Dates using Attributes, I often get a blank date drop-down. I can then click in the box and the calendar displays, but when I select a date and time and save it, the entry isn't saved. I also can't type a date into the box like one normally can. The only way I've been getting around it is to delete that entry again, save the page and then go back into Attributes. Once it happens, I can't get out of it without doing the aforementioned. It is intermittent and I can't pick up a "pattern".
2. My Event page Created Time always defaults to 1/1/1970 no matter how many times I update this and save it. Any idea why this might be happening or where to check the code for this? My concrete5 date is correct.
3. The biggest issue however is that I can't save more than 9 Event Dates against any event. I can add them using the Event Dates Attribute but as soon as I save, it is removed. Any idea where I can update this number or why this is happening? I've looked in all the file but can't find any reference to 8 or 9 events/array.
Your help is greatly appreciated!
Thanks,
Choppie
I'm struggling a bit with three issues.
1. When I add Event Dates using Attributes, I often get a blank date drop-down. I can then click in the box and the calendar displays, but when I select a date and time and save it, the entry isn't saved. I also can't type a date into the box like one normally can. The only way I've been getting around it is to delete that entry again, save the page and then go back into Attributes. Once it happens, I can't get out of it without doing the aforementioned. It is intermittent and I can't pick up a "pattern".
2. My Event page Created Time always defaults to 1/1/1970 no matter how many times I update this and save it. Any idea why this might be happening or where to check the code for this? My concrete5 date is correct.
3. The biggest issue however is that I can't save more than 9 Event Dates against any event. I can add them using the Event Dates Attribute but as soon as I save, it is removed. Any idea where I can update this number or why this is happening? I've looked in all the file but can't find any reference to 8 or 9 events/array.
Your help is greatly appreciated!
Thanks,
Choppie
Type: | Discussion |
---|---|
Status: | In Progress |
I was finally able to track down the issue with the limitation on the number of dates per event. In your database you'll find the "atDateTimeTime" table which is where ProEvents is storing dates for each event. This table is created with the "value" column as a VARCHAR(256). 9 dates stored as a string in this column equals out to 256 characters exactly so the database is unable to hold any more dates for an event.
To resolve the issue run the following in MySQL to convert the "value" column into a TEXT type rather than a VARCHAR. You will not lose any data in the "value" column when making this ALTER query:
Once you have the database updated you can store more than 9 dates per event. Hope that's helpful to someone else.
To resolve the issue run the following in MySQL to convert the "value" column into a TEXT type rather than a VARCHAR. You will not lose any data in the "value" column when making this ALTER query:
ALTER TABLE atDateTimeTime MODIFY value TEXT;
Once you have the database updated you can store more than 9 dates per event. Hope that's helpful to someone else.
@jaushman
Thank you so much for not only taking the time to look into this issue but also through careful investigation, finding the solution! I really appreciate the help!
You are a legend!
Cheers,
Choppie
Thank you so much for not only taking the time to look into this issue but also through careful investigation, finding the solution! I really appreciate the help!
You are a legend!
Cheers,
Choppie
In terms of the limit of the number of dates for an event I mentioned previously (no 3.), I noticed in the btProEventDates table in my DB, that there is a field called "grouped" which is set to int(11).
Would this be where I increase the number of dates + times my event can have? I'm quite nervous about changing things when I don't know what it is used for!
Thanks,
Choppie