Jump to content
X2Community Forums

Getting error on Webtracker


Recommended Posts

Trying to get the web-tracker working again. Below is the error log stack on the issue - Note (I recently moved this from a sub.domain to sub/directory.)
 

2020/12/10 23:47:34 [error] [exception.CDbException] CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'flhomesa_crm.x2_anon_contact.lastUpdated' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php:543
Stack trace:
#0 /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /home/flhomesandcondos/public_html/crm/protected/modules/marketing/models/Fingerprint.php(358): CDbCommand->queryAll()
#2 /home/flhomesandcondos/public_html/crm/protected/modules/marketing/models/Fingerprint.php(225): Fingerprint::partialMatch(Array)
#3 /home/flhomesandcondos/public_html/crm/protected/components/WebListenerAction.php(233): Fingerprint::track('543370320', Array)
#4 /home/flhomesandcondos/public_html/crm/protected/components/WebListenerAction.php(139): WebListenerAction::trackGeneric('lz3UXrhB7AhjONI...', 'https://flhomes...'false, '543370320', Array)
#5 /home/flhomesandcondos/public_html/crm/protected/components/WebListenerAction.php(57): WebListenerAction::track()
#6 /home/flhomesandcondos/public_html/crm/framework/web/actions/CAction.php(76): WebListenerAction->run()
#7 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(308): CAction->runWithParams(Array)
#8 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(WebListenerAction))
#9 /home/flhomesandcondos/public_html/crm/protected/controllers/ApiController.php(769): CFilterChain->run()
#10 /home/flhomesandcondos/public_html/crm/framework/web/filters/CInlineFilter.php(58): ApiController->filterAvailable(Object(CFilterChain))
#11 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#12 /home/flhomesandcondos/public_html/crm/protected/controllers/ApiController.php(799): CFilterChain->run()
#13 /home/flhomesandcondos/public_html/crm/framework/web/filters/CInlineFilter.php(58): ApiController->filterNoSession(Object(CFilterChain))
#14 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#15 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(291): CFilterChain->run()
#16 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(265): CController->runActionWithFilters(Object(WebListenerAction), Array)
#17 /home/flhomesandcondos/public_html/crm/framework/web/CWebApplication.php(282): CController->run('webListener')
#18 /home/flhomesandcondos/public_html/crm/protected/components/X2WebApplication.php(65): CWebApplication->runController('api/webListener')
#19 /home/flhomesandcondos/public_html/crm/framework/base/CApplication.php(185): X2WebApplication->processRequest()
#20 /home/flhomesandcondos/public_html/crm/index.php(67): CApplication->run()
#21 {main}
REQUEST_URI=/crm/index.php/api/webListener?url=https%3A%2F%2Fflhomesandcondos.com%2F&fingerprint=543370320&geoCoords=undefined&plugins=4226553844&userAgent=Mozilla%2F5.0%20(X11%3B%20Linux%20x86_64)%20AppleWebKit%2F537.36%20(KHTML%2C%20like%20Gecko)%20Chrome%2F86.0.4240.193%20Safari%2F537.36&language=en-US&screenRes=863x1367x24&timezone=480&cookiesEnabled=1&indexedDB=1&addBehavior=0&javaEnabled=1&canvasFingerprint=1763624112&localStorage=1&sessionStorage=1&fonts=2504911533
Link to post
Share on other sites

            /* Order by best matches first, then by contacts first, then by last updated first */
            ORDER BY sum DESC, anonymous ASC, lastUpdated DESC
        ')->bindValues ($params)
          ->queryAll ();

        $contact = null;

Line-358 =        ->queryAll ();

 

And the function =       

 

    public static function partialMatch($attributes = array()) {
        $checkAttrs = self::getFingerprintAttributeNames ();
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...