Jump to content


chad1964

Member Since 25 Feb 2019
Offline Last Active Dec 15 2020 05:38 PM
-----

Topics I've Started

Getting 500 error for "Topics"

14 December 2020 - 05:14 AM

Below is the errors Stack Trace -
Note - I still haven't gotten the webtracker to work in the other thread http://community.x2c...-on-webtracker/

When I click on the "Topics" Menu link I get this error -
========================================

Error 500

It looks like the application ran into an unexpected error.

We apologize for the inconvenience and would like to do our best to fix this issue. If you would like to make a post on our forums we can actively interact with you in getting this resolved. If not, simply sending the error report helps us immensely and will only improve the quality of the software. Thanks!
Send Error Report
Here's a quick list of what will be included in the report:

Error Code: 500
Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'flhomesa_crm.t.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Stack Trace: [click to toggle display]
CDbException in /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php(543)
#0 /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php(433): CDbCommand->queryInternal('fetchColumn', 0, Array)
#1 /home/flhomesandcondos/public_html/crm/framework/db/ar/CActiveFinder.php(747): CDbCommand->queryScalar()
#2 /home/flhomesandcondos/public_html/crm/framework/db/ar/CActiveFinder.php(151): CJoinElement->count(Object(CDbCriteria))
#3 /home/flhomesandcondos/public_html/crm/framework/db/ar/CActiveRecord.php(1613): CActiveFinder->count(Object(CDbCriteria))
#4 /home/flhomesandcondos/public_html/crm/framework/web/CActiveDataProvider.php(228): CActiveRecord->count(Object(CDbCriteria))
#5 /home/flhomesandcondos/public_html/crm/framework/web/CDataProvider.php(224): CActiveDataProvider->calculateTotalItemCount()
#6 /home/flhomesandcondos/public_html/crm/framework/web/CActiveDataProvider.php(178): CDataProvider->getTotalItemCount()
#7 /home/flhomesandcondos/public_html/crm/framework/web/CDataProvider.php(168): CActiveDataProvider->fetchData()
#8 /home/flhomesandcondos/public_html/crm/framework/zii/widgets/CBaseListView.php(125): CDataProvider->getData()
#9 /home/flhomesandcondos/public_html/crm/framework/zii/widgets/CListView.php(211): CBaseListView->init()
#10 /home/flhomesandcondos/public_html/crm/framework/web/CBaseController.php(147): CListView->init()
#11 /home/flhomesandcondos/public_html/crm/protected/controllers/x2base.php(836): CBaseController->createWidget('zii.widgets.CLi...', Array)
#12 /home/flhomesandcondos/public_html/crm/protected/modules/topics/views/topics/index.php(72): x2base->widget('zii.widgets.CLi...', Array)
#13 /home/flhomesandcondos/public_html/crm/framework/web/CBaseController.php(126): require('/home/flhomesan...')
#14 /home/flhomesandcondos/public_html/crm/framework/web/CBaseController.php(95): CBaseController->renderInternal('/home/flhomesan...', Array, true)
#15 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(872): CBaseController->renderFile('/home/flhomesan...', Array, true)
#16 /home/flhomesandcondos/public_html/crm/protected/controllers/x2base.php(736): CController->renderPartial('index', Array, true)
#17 /home/flhomesandcondos/public_html/crm/protected/modules/topics/controllers/TopicsController.php(254): x2base->render('index', Array)
#18 [internal function]: TopicsController->actionIndex(NULL)
#19 /home/flhomesandcondos/public_html/crm/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(TopicsController), Array)
#20 /home/flhomesandcondos/public_html/crm/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(TopicsController), Object(ReflectionMethod), Array)
#21 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#22 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction))
#23 /home/flhomesandcondos/public_html/crm/protected/controllers/x2base.php(586): CFilterChain->run()
#24 /home/flhomesandcondos/public_html/crm/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#25 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#26 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#27 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#28 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#29 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#30 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(291): CFilterChain->run()
#31 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#32 /home/flhomesandcondos/public_html/crm/framework/web/CWebApplication.php(282): CController->run('index')
#33 /home/flhomesandcondos/public_html/crm/protected/components/X2WebApplication.php(65): CWebApplication->runController('topics/topics/i...')
#34 /home/flhomesandcondos/public_html/crm/framework/base/CApplication.php(185): X2WebApplication->processRequest()
#35 /home/flhomesandcondos/public_html/crm/index.php(67): CApplication->run()
#36 {main}
X2Engine Version: 8.0
PHP Version: 7.1.33

Getting error on Webtracker

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

Getting 500 error on saving docs.

10 December 2020 - 08:10 AM

Here is the output - Any insight would be appreciated as I have even done multiple re-installs using php7.0 up to php7.3 to test to see if it was just this install.
 

It looks like the application ran into an unexpected error.

We apologize for the inconvenience and would like to do our best to fix this issue. If you would like to make a post on our forums we can actively interact with you in getting this resolved. If not, simply sending the error report helps us immensely and will only improve the quality of the software. Thanks!
Send Error Report
Here's a quick list of what will be included in the report:

Error Code: 500
Error Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flhomesa_crm.x2_info_docs' doesn't exist
Stack Trace: [click to toggle display]
CDbException in /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php(543)
#0 /home/flhomesandcondos/public_html/crm/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /home/flhomesandcondos/public_html/crm/protected/modules/docs/models/Docs.php(118): CDbCommand->queryAll()
#2 /home/flhomesandcondos/public_html/crm/protected/modules/docs/models/Docs.php(109): Docs->infoDocCheck()
#3 /home/flhomesandcondos/public_html/crm/framework/db/ar/CActiveRecord.php(1132): Docs->afterSave()
#4 /home/flhomesandcondos/public_html/crm/protected/models/X2Model.php(904): CActiveRecord->update(NULL)
#5 /home/flhomesandcondos/public_html/crm/protected/modules/docs/controllers/DocsController.php(369): X2Model->save()
#6 [internal function]: DocsController->actionUpdate('53')
#7 /home/flhomesandcondos/public_html/crm/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(DocsController), Array)
#8 /home/flhomesandcondos/public_html/crm/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal(Object(DocsController), Object(ReflectionMethod), Array)
#9 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#10 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(134): CController->runAction(Object(CInlineAction))
#11 /home/flhomesandcondos/public_html/crm/protected/controllers/x2base.php(586): CFilterChain->run()
#12 /home/flhomesandcondos/public_html/crm/framework/web/filters/CInlineFilter.php(58): x2base->filterSetPortlets(Object(CFilterChain))
#13 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(Object(CFilterChain))
#14 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#15 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#16 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilter.php(40): CFilterChain->run()
#17 /home/flhomesandcondos/public_html/crm/framework/web/filters/CFilterChain.php(131): CFilter->filter(Object(CFilterChain))
#18 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(291): CFilterChain->run()
#19 /home/flhomesandcondos/public_html/crm/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#20 /home/flhomesandcondos/public_html/crm/framework/web/CWebApplication.php(282): CController->run('update')
#21 /home/flhomesandcondos/public_html/crm/protected/components/X2WebApplication.php(65): CWebApplication->runController('docs/docs/updat...')
#22 /home/flhomesandcondos/public_html/crm/framework/base/CApplication.php(185): X2WebApplication->processRequest()
#23 /home/flhomesandcondos/public_html/crm/index.php(67): CApplication->run()
#24 {main}
X2Engine Version: 8.0
PHP Version: 7.1.33