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

Type: Discussion
Status: In Progress
Choppie
View Replies:
Choppie replied on at Permalink Reply
Choppie
Hi,

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
jaushman replied on at Permalink Reply
jaushman
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:
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.
Choppie replied on at Permalink Reply
Choppie
@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

concrete5 Environment Information

# concrete5 Version
Core Version - 5.7.5.6
Version Installed - 5.7.5.6
Database Version - 20151221000000

# concrete5 Packages
Block Designer (1.3.9), Equinox (1.0.3), Login Page Background (0.9), ProEvents (2.8.5), Quick Tabs (1.0).

# concrete5 Overrides
blocks/movie_poster_and_share_page/icon.png, blocks/movie_poster_and_share_page/form.php, blocks/movie_poster_and_share_page/config.json, blocks/movie_poster_and_share_page/db.xml, blocks/movie_poster_and_share_page/view.php, blocks/movie_poster_and_share_page/add.php, blocks/movie_poster_and_share_page/controller.php, blocks/movie_poster_and_share_page/edit.php, blocks/movie_poster_and_share_page/composer.php, blocks/movie_poster_and_share_page, blocks/censorship_ratings_info/icon.png, blocks/censorship_ratings_info/form.php, blocks/censorship_ratings_info/config.json, blocks/censorship_ratings_info/db.xml, blocks/censorship_ratings_info/view.php, blocks/censorship_ratings_info/add.php, blocks/censorship_ratings_info/controller.php, blocks/censorship_ratings_info/edit.php, blocks/censorship_ratings_info/composer.php, blocks/censorship_ratings_info, blocks/movieinformation/icon.png, blocks/movieinformation/form.php, blocks/movieinformation/config.json, blocks/movieinformation/db.xml, blocks/movieinformation/view.php, blocks/movieinformation/add.php, blocks/movieinformation/controller.php, blocks/movieinformation/edit.php, blocks/movieinformation/composer.php, blocks/movieinformation, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/nb_NO/LC_MESSAGES/messages.mo, languages/nb_NO/LC_MESSAGES, languages/nb_NO, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/pl_PL/LC_MESSAGES/messages.mo, languages/pl_PL/LC_MESSAGES, languages/pl_PL, blocks/movie_poster_and_share_page/icon.png, blocks/movie_poster_and_share_page/form.php, blocks/movie_poster_and_share_page/config.json, blocks/movie_poster_and_share_page/db.xml, blocks/movie_poster_and_share_page/view.php, blocks/movie_poster_and_share_page/add.php, blocks/movie_poster_and_share_page/controller.php, blocks/movie_poster_and_share_page/edit.php, blocks/movie_poster_and_share_page/composer.php, blocks/movie_poster_and_share_page, blocks/censorship_ratings_info/icon.png, blocks/censorship_ratings_info/form.php, blocks/censorship_ratings_info/config.json, blocks/censorship_ratings_info/db.xml, blocks/censorship_ratings_info/view.php, blocks/censorship_ratings_info/add.php, blocks/censorship_ratings_info/controller.php, blocks/censorship_ratings_info/edit.php, blocks/censorship_ratings_info/composer.php, blocks/censorship_ratings_info, blocks/movieinformation/icon.png, blocks/movieinformation/form.php, blocks/movieinformation/config.json, blocks/movieinformation/db.xml, blocks/movieinformation/view.php, blocks/movieinformation/add.php, blocks/movieinformation/controller.php, blocks/movieinformation/edit.php, blocks/movieinformation/composer.php, blocks/movieinformation, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/nb_NO/LC_MESSAGES/messages.mo, languages/nb_NO/LC_MESSAGES, languages/nb_NO, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/pl_PL/LC_MESSAGES/messages.mo, languages/pl_PL/LC_MESSAGES, languages/pl_PL

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.7 (Ubuntu)

# Server API
apache2handler

# PHP Version
5.5.9-1ubuntu4.17

# PHP Extensions
apache2handler, bcmath, bz2, calendar, Core, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, ldap, libxml, mbstring, mcrypt, mhash, mysql, mysqli, openssl, pcre, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, readline, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, Zend OPcache, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 50
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 64M
sql.safe_mode - Off
upload_max_filesize - 100M
ldap.max_links - Unlimited
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 1440
soap.wsdl_cache_limit - 5
opcache.max_accelerated_files - 2000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.