Jump to content


Photo

Getting error on Webtracker


  • Please log in to reply
3 replies to this topic

#1 chad1964

chad1964

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 10 December 2020 - 09:01 PM

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


#2 jack

jack

    Admin

  • Administrators
  • 66 posts

Posted 11 December 2020 - 02:15 PM

Can you please post line 358 in file protected/modules/marketing/models/Fingerprint.php and the function that contains the line.



#3 chad1964

chad1964

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 11 December 2020 - 05:51 PM

            /* 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 ();


#4 chad1964

chad1964

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 15 December 2020 - 05:38 PM

Okay so I've solved this by exporting the generated webtracker js file and then embedding its code into the footer so that its now working fine. 






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users