Problems with ProEvents/ProBlog?

Permalink Browser Info Environment
I am having an issue whenever I try to use ProEvents. I get this error whenever I try to search something after installing ProEvents.
concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 An exception occurred while executing 'SELECT p.cID FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID and cvIsApproved = 1 WHERE ((psi.cName LIKE ?) OR (psi.cDescription LIKE ?) OR (psi.content LIKE ?) OR (ak_meta_title LIKE ?) OR (ak_meta_description LIKE ?) OR (ak_meta_keywords LIKE ?) OR (ak_header_extra_content LIKE ?) OR (ak_exclude_sitemapxml LIKE ?) OR (ak_exclude_nav LIKE ?) OR (ak_exclude_page_list LIKE ?) OR (ak_exclude_search_index LIKE ?) OR (ak_event_multidate LIKE ?) OR (ak_event_exclude LIKE ?) OR (ak_event_section LIKE ?) OR (ak_event_tag LIKE ?) OR (ak_event_thru LIKE ?) OR (ak_event_recur LIKE ?) OR (ak_tags LIKE ?)) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (p.cIsActive = ?) AND (p.cIsSystemPage = ?) LIMIT 1000' with params ["%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", "%results%", true, false]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_event_multidate' in 'where clause' (0)

I know you know of a problem/issue with ProBlog so is this somewhat related?


Type: Discussion
Status: In Progress
View Replies:
MichaelG replied on at Permalink Reply
While we use ProEvents/Blog, you should open a ticket with the add-on creator.
dag182 replied on at Permalink Reply
I'm having the same issue and couldn't find anything over in the ProEvents support section about it - did you ever get it resolved?
jmnino replied on at Permalink Reply
I have an open ticket right now with Chad the developer of ProBlogs and he is looking into the issue. Look for my username in the ProBlog to stay up to date. I am hoping for a resolution soon since we want to launch our site.
dag182 replied on at Permalink Reply

Sent from my iPhone

> On Jan 19, 2015, at 9:25 PM, concrete5 Community <[email protected]> wrote:
wavemedia replied on at Permalink Reply
While I dont have a hard code solution. I did manage to fix my problem.

I went directly into the database/ table
CollectionSearchIndexAttributes and added
ak_event_exclude (this one kicks an error after you fix the ak_event_multidate column)
the field contents are the same as ak_event_allday.

This will solve your search issue.

To the developer, those 2 rows didnt make it in.

concrete5 Environment Information

# concrete5 Version

# concrete5 Packages
Call to Action (0.9.1), Editor Comment (7.0), Fruitful (1.1.1), Likes This! (2.0.1), List files from set (1.0.7), Login Block (0.9.3), ProEvents (2.0.3), Quick Tabs (0.9.3), Sermon Series (1.0), Spacer (0.9.0), Zoomer (1.0).

# concrete5 Overrides
languages/el_GR, languages/fr_FR, languages/fi_FI, languages/it_IT, languages/nl_NL, languages/ja_JP, languages/sv_SE, languages/de_DE, languages/tr_TR, languages/sl_SI, languages/da_DK, languages/ru_RU

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

# Server Software

# Server API

# PHP Version

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, exif, filter, ftp, gd, gettext, hash, htscanner, iconv, imap, intl, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, Reflection, session, SimpleXML, soap, sockets, SPL, SQLite, sqlite3, standard, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend Guard Loader, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 512M
post_max_size - 128M
safe_mode - Off
safe_mode_exec_dir - <i>no value</i>
safe_mode_gid - Off
safe_mode_include_dir - <i>no value</i>
sql.safe_mode - Off
upload_max_filesize - 128M
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
safe_mode_allowed_env_vars - PHP_
safe_mode_protected_env_vars - LD_LIBRARY_PATH

Browser User-Agent String

Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 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

Click below to request a refund for License #7674813. Assigned to Yosemite Lakes Owners Association.
Created on Nov 25 2014 at 5:48 pm