Getting an error on Form Reply Mails

Permalink Browser Info Environment
An unexpected error occurred.
An exception occurred while executing 'SELECT * FROM btForm GROUP BY questionSetId DESC': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'novaporta.btForm.bID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

I get this error when I try to click on Form Reply Mails in the Dashboard. I've tried reinstalling the packages but that didn't solve it.

Type: Discussion
Status: On Hold
View Replies:
abcitweb replied on at Permalink Reply
abcitweb
This problem occurs on some (older) versions of mysql . I can't reproduce this error.

Please try following fix:

Open abc_formext/controllers/single_page/dashboard/conversations/form_auto_reply.php
Find
$forms = $db->fetchAll('SELECT * FROM btForm GROUP BY questionSetId DESC');

and replace it by
$forms = $db->fetchAll('SELECT * FROM btForm b GROUP BY b.questionSetId, b.bID DESC');


If this fixes your issue, please tell me. (I will update the package if this works.)

concrete5 Environment Information

# concrete5 Version
Core Version - 5.7.5.9
Version Installed - 5.7.5.9
Database Version - 20160615000000

# concrete5 Packages
ABC Auto Reply forms (1.0.2), ExchangeCore reCAPTCHA (1.1.1), Styled Maps (1.2.3).

# concrete5 Overrides
languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, themes/novaporta_theme/contact.php, themes/novaporta_theme/css/bootstrap.css, themes/novaporta_theme/css/font-options.css, themes/novaporta_theme/css/font-options.less, themes/novaporta_theme/css/main.css, themes/novaporta_theme/css/main.less, themes/novaporta_theme/css, themes/novaporta_theme/default.php, themes/novaporta_theme/description.txt, themes/novaporta_theme/elements/fat_footer.php, themes/novaporta_theme/elements/footer.php, themes/novaporta_theme/elements/header.php, themes/novaporta_theme/elements/right_sidebar.php, themes/novaporta_theme/elements, themes/novaporta_theme/fonts/glyphicons-halflings-regular.eot, themes/novaporta_theme/fonts/glyphicons-halflings-regular.svg, themes/novaporta_theme/fonts/glyphicons-halflings-regular.ttf, themes/novaporta_theme/fonts/glyphicons-halflings-regular.woff, themes/novaporta_theme/fonts/glyphicons-halflings-regular.woff2, themes/novaporta_theme/fonts, themes/novaporta_theme/img/+.png, themes/novaporta_theme/img/briefing.png, themes/novaporta_theme/img/do-it-yourself-icon.png, themes/novaporta_theme/img/IMG_95141.jpg, themes/novaporta_theme/img/IMG_95162.jpg, themes/novaporta_theme/img/IMG_95193.jpg, themes/novaporta_theme/img/IMG_95244.jpg, themes/novaporta_theme/img/IMG_95295.jpg, themes/novaporta_theme/img/IMG_95326.jpg, themes/novaporta_theme/img/IMG_95377.jpg, themes/novaporta_theme/img/IMG_95438.jpg, themes/novaporta_theme/img/IMG_9549-bewerkt9.jpg, themes/novaporta_theme/img/IMG_958210.jpg, themes/novaporta_theme/img/IMG_9584-bewerkt11.jpg, themes/novaporta_theme/img/IMG_9587-bewerkt12.jpg, themes/novaporta_theme/img/logo-black.png, themes/novaporta_theme/img/logo-white.png, themes/novaporta_theme/img/montage icon.png, themes/novaporta_theme/img/montage.jpg, themes/novaporta_theme/img/najaars-aanbieding-icon.png, themes/novaporta_theme/img/Ovaal 1.png, themes/novaporta_theme/img/phoneicoin.png, themes/novaporta_theme/img/plusicon.png, themes/novaporta_theme/img/Untitled-1.png, themes/novaporta_theme/img/whatsapp.png, themes/novaporta_theme/img, themes/novaporta_theme/js/main.js, themes/novaporta_theme/js, themes/novaporta_theme/subpage.php, themes/novaporta_theme/thumbnail.png, themes/novaporta_theme, languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, themes/novaporta_theme/contact.php, themes/novaporta_theme/css/bootstrap.css, themes/novaporta_theme/css/font-options.css, themes/novaporta_theme/css/font-options.less, themes/novaporta_theme/css/main.css, themes/novaporta_theme/css/main.less, themes/novaporta_theme/css, themes/novaporta_theme/default.php, themes/novaporta_theme/description.txt, themes/novaporta_theme/elements/fat_footer.php, themes/novaporta_theme/elements/footer.php, themes/novaporta_theme/elements/header.php, themes/novaporta_theme/elements/right_sidebar.php, themes/novaporta_theme/elements, themes/novaporta_theme/fonts/glyphicons-halflings-regular.eot, themes/novaporta_theme/fonts/glyphicons-halflings-regular.svg, themes/novaporta_theme/fonts/glyphicons-halflings-regular.ttf, themes/novaporta_theme/fonts/glyphicons-halflings-regular.woff, themes/novaporta_theme/fonts/glyphicons-halflings-regular.woff2, themes/novaporta_theme/fonts, themes/novaporta_theme/img/+.png, themes/novaporta_theme/img/briefing.png, themes/novaporta_theme/img/do-it-yourself-icon.png, themes/novaporta_theme/img/IMG_95141.jpg, themes/novaporta_theme/img/IMG_95162.jpg, themes/novaporta_theme/img/IMG_95193.jpg, themes/novaporta_theme/img/IMG_95244.jpg, themes/novaporta_theme/img/IMG_95295.jpg, themes/novaporta_theme/img/IMG_95326.jpg, themes/novaporta_theme/img/IMG_95377.jpg, themes/novaporta_theme/img/IMG_95438.jpg, themes/novaporta_theme/img/IMG_9549-bewerkt9.jpg, themes/novaporta_theme/img/IMG_958210.jpg, themes/novaporta_theme/img/IMG_9584-bewerkt11.jpg, themes/novaporta_theme/img/IMG_9587-bewerkt12.jpg, themes/novaporta_theme/img/logo-black.png, themes/novaporta_theme/img/logo-white.png, themes/novaporta_theme/img/montage icon.png, themes/novaporta_theme/img/montage.jpg, themes/novaporta_theme/img/najaars-aanbieding-icon.png, themes/novaporta_theme/img/Ovaal 1.png, themes/novaporta_theme/img/phoneicoin.png, themes/novaporta_theme/img/plusicon.png, themes/novaporta_theme/img/Untitled-1.png, themes/novaporta_theme/img/whatsapp.png, themes/novaporta_theme/img, themes/novaporta_theme/js/main.js, themes/novaporta_theme/js, themes/novaporta_theme/subpage.php, themes/novaporta_theme/thumbnail.png, themes/novaporta_theme

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

# Server Software
Apache/2.4.23 (Win64) PHP/5.6.25

# Server API
apache2handler

# PHP Version
5.6.25

# PHP Extensions
apache2handler, bcmath, bz2, calendar, com_dotnet, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mcrypt, mhash, mysql, mysqli, mysqlnd, odbc, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, tokenizer, wddx, xdebug, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend OPcache, zip, zlib.

# PHP Settings
max_execution_time - 120
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 2500
memory_limit - 128M
post_max_size - 8M
sql.safe_mode - Off
upload_max_filesize - 2M
ldap.max_links - Unlimited
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 1440
soap.wsdl_cache_limit - 5
xdebug.max_nesting_level - 256
xdebug.max_stack_frames - -1
xdebug.var_display_max_children - 128
xdebug.var_display_max_data - 512
xdebug.var_display_max_depth - 3
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; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143 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 #7981328. Assigned to Novaporta.
Created on Nov 02 2016 at 12:43 pm
.