3 replies to this topic

[chad1964]

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

HTTP_REFERER=https://flhomesandcondos.com/

[jack]

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

[chad1964]

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

[chad1964]

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.