Yes it returns a message with id 789.
Not sure there is any easy way to reproduce this. Most of the messages seem to work with no error. So maybe you have to send hundreds of messages to get one error.
And yesterday I got a different PHP exception mail. Could this be because there is a smiley in the username? (It shows a questionmark here when I paste it as code)
Code:
A PHP Exception occurred on your site. Here you can find the stack trace:
Exception Type: JDatabaseExceptionExecuting
File: public_html/libraries/joomla/database/driver/mysqli.php
Line: 665
Message: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
#0 public_html/libraries/joomla/database/driver.php(1740): JDatabaseDriverMysqli->execute()
#1 public_html/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php(345): JDatabaseDriver->loadResult()
#2 public_html/components/com_comprofiler/plugin/user/plug_cbcore/cb.core.php(609): CBLib\Database\Driver\CmsDatabaseDriver->loadResult()
#3 public_html/components/com_comprofiler/plugin/user/plug_cbcore/cb.core.php(777): CBfield_predefined->checkAliasExists('John')
#4 public_html/components/com_comprofiler/plugin/user/plug_cbcore/cb.core.php(634): CBfield_predefined->validate(Object(CB\Database\Table\FieldTable), Object(CB\Database\Table\UserTable), 'username', 'John', Array, 'register')
#5 public_html/libraries/CBLib/CB/Legacy/cbPluginHandler.php(885): CBfield_predefined->prepareFieldDataSave(Object(CB\Database\Table\FieldTable), Object(CB\Database\Table\UserTable), Array, 'register')
#6 public_html/libraries/CBLib/CB/Legacy/cbPluginHandler.php(1081): cbPluginHandler->call(1, 'prepareFieldDat...', 'CBfield_predefi...', Array)
#7 public_html/libraries/CBLib/CB/Legacy/cbTabs.php(1177): cbPluginHandler->callField('predefined', 'prepareFieldDat...', Array, Object(CB\Database\Table\FieldTable))
#8 public_html/libraries/CBLib/CB/Database/Table/UserTable.php(452): cbTabs->saveTabsContents(Object(CB\Database\Table\UserTable), Array, 'register')
#9 public_html/libraries/CBLib/CB/Database/Table/UserTable.php(879): CB\Database\Table\UserTable->bindSafely(Array, 1, 'register', Object(CB\Database\Table\UserTable))
#10 public_html/components/com_comprofiler/comprofiler.php(1041): CB\Database\Table\UserTable->saveSafely(Array, 1, 'register')
#11 public_html/components/com_comprofiler/comprofiler.php(132): saveRegistration('com_comprofiler')
#12 public_html/libraries/src/Component/ComponentHelper.php(402): require_once('/home/u196...')
#13 public_html/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent('/home/u196...')
#14 public_html/libraries/src/Application/SiteApplication.php(194): Joomla\CMS\Component\ComponentHelper::renderComponent('com_comprofiler')
#15 public_html/libraries/src/Application/SiteApplication.php(233): Joomla\CMS\Application\SiteApplication->dispatch()
#16 public_html/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\SiteApplication->doExecute()
#17 public_html/index.php(49): Joomla\CMS\Application\CMSApplication->execute()
#18 {main}
Request information
GET variables
Array
(
[Itemid] => 186
[option] => com_comprofiler
[view] => saveregisters
[task] => saveregisters
)
POST variables
Array
(
[id] => 0
[gid] => 0
[emailpass] => 0
[cbsecuritym3] => cbm_33829bb2
[cbrasitway] => cbrv1_e2ad9c7e
[name] => Tony
[cb_age] => 26-30
[cb_country] => United States
[username] => John?
[email] => xxx@outlook.com
[password] => xxx
)
COOKIE variables
Array
(
[_ga] => GA1.1.1950194638.16177116
[_ga_9QSB3ZGZM0] => GS1.1.16177116.1.1.16177223.0
[99547323dbb5efb391105420017e7] => 60009b729262c44a9df827ea477e9
[reDimCookieHint] => 1
[__cfduid] => d3bc77a1d7ed66116e5e51bd1b2ea11617730092
)
REQUEST variables
Array
(
[Itemid] => 186
[id] => 0
[gid] => 0
[emailpass] => 0
[cbsecuritym3] => cbm_33829bb2_582bf149_768be387484603200f
[cbrasitway] => cbrv1_e2ad9c7eea2ff76392a673dbd5ce_ZWXHfqg
[name] => Tony
[cb_age] => 26-30
[cb_country] => United States
[username] => John?
[email] => xxx@outlook.com
[password] => xxx
[_ga] => GA1.1.1950194638.1617730
[_ga_9QSB3ZGZM0] => GS1.1.1617730116.1.1.1617730.0
[99547323dbb5efb391412420017e7] => 60009bff7262c44a9df8277e9
[reDimCookieHint] => 1
[__cfduid] => d3bc77a1d7ed6611bdbd411617730092
[option] => com_comprofiler
[view] => saveregisters
[task] => saveregisters
)
SERVER variables
Array
(
[LSPHP_ProcessGroup] => on
[PATH] => /usr/local/bin:/bin:/usr/bin
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[HTTP_ACCEPT_ENCODING] => gzip
[HTTP_ACCEPT_LANGUAGE] => en-gb
[HTTP_CONNECTION] => Keep-Alive
[CONTENT_TYPE] => multipart/form-data; boundary=----WebKitFormBoundaryxHPLTjFUMGqq81ni
[CONTENT_LENGTH] => 1381
[HTTP_COOKIE] => _ga=GA1.1.1954638.1610116; _ga_9QSB3ZGZM0=GS1.1.1617730116.1.1.1617730223.0; 99547323dbb5efb11054420017e7=60b729ff7262c44af827ea477e9; reDimCookieHint=1; __cfduid=d3bc77a7ed66116e5e51bdbd41b2ea11617730092
[HTTP_HOST] => www.site.com
[HTTP_REFERER] => /signup
[HTTP_USER_AGENT] => Mozilla/5.0 (iPhone; CPU iPhone OS 14_4_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.3 Mobile/15E148 Safari/604.1
[HTTP_X_FORWARDED_FOR] => 2a02:c7f:bb1b:d400:74f0:87be:48bc:66ef
[HTTP_CF_IPCOUNTRY] => GB
[HTTP_CF_RAY] => 63bcc4862beb38d2-ATH
[HTTP_X_FORWARDED_PROTO] => https
[HTTP_CF_VISITOR] => {"scheme":"https"}
[HTTP_ORIGIN] =>
[HTTP_CF_CONNECTING_IP] => 2a02:c7f:bb1b:d400:74f0:87be:48bc:66ef
[HTTP_CDN_LOOP] => cloudflare
[HTTP_CF_REQUEST_ID] => 0949d27db0038d0c8ac0000001
[DOCUMENT_ROOT] => public_html
[REMOTE_ADDR] => 2a02:c7f:bb1b:d00:74f0:87be:48bc:66ef
[REMOTE_PORT] => 61068
[SERVER_ADDR] => 15.24.18.13
[SERVER_NAME] => www.site.com
[SERVER_ADMIN] =>
[SERVER_PORT] => 443
[REQUEST_SCHEME] => https
[REQUEST_URI] => /component/comprofiler/saveregisters?Itemid=186
[REDIRECT_URL] => /component/comprofiler/saveregisters
[REDIRECT_QUERY_STRING] => Itemid=186
[PROXY_REMOTE_ADDR] => 17.68.62.19
[HTTPS] => on
[HTTP_AUTHORIZATION] =>
[REDIRECT_STATUS] => 200
[SSL_PROTOCOL] => TLSv1.3
[SSL_CIPHER] => TLS_AES_128_GCM_SHA256
[SSL_CIPHER_USEKEYSIZE] => 128
[SSL_CIPHER_ALGKEYSIZE] => 128
[SCRIPT_FILENAME] => public_html/index.php
[QUERY_STRING] => Itemid=186
[SCRIPT_URI] => /component/comprofiler/saveregisters
[SCRIPT_URL] => /component/comprofiler/saveregisters
[SCRIPT_NAME] => /index.php
[SERVER_PROTOCOL] => HTTP/1.1
[SERVER_SOFTWARE] => LiteSpeed
[REQUEST_METHOD] => POST
[X-LSCACHE] => on
[PHP_SELF] => /index.php
[REQUEST_TIME_FLOAT] => 1617730474.1178
[REQUEST_TIME] => 1617730474
)
krileon
