PHP error when viewing users listing
We keep receiving these errors as soon as a users listing is called from the back end.
Mind to tell us what to correct ? (this is a migration from acy 5 to acy 6)
Thanks
`A PHP Exception occurred on your site. Here you can find the stack trace:
Exception Type: JDatabaseExceptionExecuting
File: /var/www/html/libraries/joomla/database/driver/mysqli.php
Line: 665
Message: Unknown column 'null.null' in 'field list'
#0 /var/www/html/libraries/joomla/database/driver.php(1701): JDatabaseDriverMysqli->execute()
#1 /var/www/html/administrator/components/com_acym/libraries/joomla.php(499): JDatabaseDriver->loadObjectList('')
#2 /var/www/html/administrator/components/com_acym/classes/list.php(99): acym_loadObjectList('SELECT list.col...', '', 500, 500)
#3 /var/www/html/administrator/components/com_acym/controllers/entitySelect.php(53): AcyMailing\Classes\ListClass->getMatchingElements(Array)
#4 /var/www/html/administrator/components/com_acym/controllers/entitySelect.php(30): AcyMailing\Controllers\EntitySelectController->loadEntityBack('list', 500, 500, '', Array)
#5 /var/www/html/administrator/components/com_acym/libraries/controller.php(79): AcyMailing\Controllers\EntitySelectController->loadEntityFront()
#6 /var/www/html/administrator/components/com_acym/acym.php(55): AcyMailing\Libraries\acymController->call('loadEntityFront')
#7 /var/www/html/libraries/src/Component/ComponentHelper.php(402): require_once('/var/www/html/a...')
#8 /var/www/html/libraries/src/Component/ComponentHelper.php(377): Joomla\CMS\Component\ComponentHelper::executeComponent('/var/www/html/a...')
#9 /var/www/html/libraries/src/Application/AdministratorApplication.php(101): Joomla\CMS\Component\ComponentHelper::renderComponent('com_acym')
#10 /var/www/html/libraries/src/Application/AdministratorApplication.php(159): Joomla\CMS\Application\AdministratorApplication->dispatch()
#11 /var/www/html/libraries/src/Application/CMSApplication.php(196): Joomla\CMS\Application\AdministratorApplication->doExecute()
#12 /var/www/html/administrator/index.php(51): Joomla\CMS\Application\CMSApplication->execute()
#13 {main}
Request information
GET variables
Array
(
[option] => com_acym
[tmpl] => component
[a5e809bee0809bb773019879ec1b0a43] => 1
[ctrl] => entitySelect
[task] => loadEntityFront
[offset] => 500
[perCalls] => 500
[entity] => list
[join] =>
[columns] => color,name,id
[join_table] => null.null
)
POST variables
Array
(
)
COOKIE variables
Array
(
[cs_geolocation] => YTo1OntzOjEwOiJzdGF0dXNDb2RlIjtzOjI6Ik9LIjtzOjk6ImlwQWRkcmVzcyI7czoxNDoiODYuMjAyLjEwNC4xNjkiO3M6MTE6ImNvdW50cnlDb2RlIjtzOjI6IkZSIjtzOjEwOiJyZWdpb25OYW1lIjtzOjIwOiJBdXZlcmduZS1SaG9uZS1BbHBlcyI7czo4OiJjaXR5TmFtZSI7czo0OiJMeW9uIjt9
[cpnb_cookiesSettings] => {"required-cookies":1,"analytical-cookies":1,"social-media-cookies":1}
[fbp] => fb.1.1589442649311.703096347
[cookiesDirective] => 1
[ga_4F2ZWNSJ78] => GS1.1.1593195487.49.1.1593195526.0
[ga] => GA1.2.121997199.1589442647
[rl_modals] => 26
[__atuvc] => 1|28,0|29,0|30,1|31,3|32
[LaVisitorId] => pv0rbpe9en6uggmnkao4fe6i69qzk
[cbtabsinstallfrom] => cbtabnavinstallfrom2
[cbtabscpayintegrations] => cbtabnavcpayintegrations7
[cbtabscpayeditplan] => cbtabnavcpayeditplan2
[gid] => GA1.2.1619467072.1601309349
[LaSID] => 1dabeb5p8jj91lh85v5vrh6jyn7xi
[7e775bfdd7b804dee157f8f35267cdc0] => u51vm1ajkjln7m35pn2dsu9c0c
[cbtabsCB] => cbtabnav11
)
REQUEST variables
Array
(
[option] => com_acym
[tmpl] => component
[a5e809bee0809bb773019879ec1b0a43] => 1
[ctrl] => entitySelect
[task] => loadEntityFront
[offset] => 500
[perCalls] => 500
[entity] => list
[join] =>
[columns] => color,name,id
[join_table] => null.null
)
SERVER variables
Array
(
[USER] => apache
[HOME] => /usr/share/httpd
[SCRIPT_NAME] => /administrator/index.php
[REQUEST_URI] => /administrator/index.php?option=com_acym&tmpl=component&a5e809bee0809bb773019879ec1b0a43=1&ctrl=entitySelect&task=loadEntityFront&offset=500&perCalls=500&entity=list&join=&columns=color,name,id&join_table=null.null
[QUERY_STRING] => option=com_acym&tmpl=component&a5e809bee0809bb773019879ec1b0a43=1&ctrl=entitySelect&task=loadEntityFront&offset=500&perCalls=500&entity=list&join=&columns=color,name,id&join_table=null.null
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.0
[GATEWAY_INTERFACE] => CGI/1.1
[REMOTE_PORT] => 49050
[SCRIPT_FILENAME] => /var/www/html/administrator/index.php
[SERVER_ADMIN] => admin@activ-ha.com
[CONTEXT_DOCUMENT_ROOT] => /var/www/html
[CONTEXT_PREFIX] =>
[REQUEST_SCHEME] => https
[DOCUMENT_ROOT] => /var/www/html
[REMOTE_ADDR] => 86.202.104.169
[SERVER_PORT] => 443
[SERVER_ADDR] => 127.0.0.1
[SERVER_NAME] => activ-ha.com
[SERVER_SOFTWARE] => Apache
[SERVER_SIGNATURE] =>
[PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
[HTTP_COOKIE] => cs_geolocation=YTo1OntzOjEwOiJzdGF0dXNDb2RlIjtzOjI6Ik9LIjtzOjk6ImlwQWRkcmVzcyI7czoxNDoiODYuMjAyLjEwNC4xNjkiO3M6MTE6ImNvdW50cnlDb2RlIjtzOjI6IkZSIjtzOjEwOiJyZWdpb25OYW1lIjtzOjIwOiJBdXZlcmduZS1SaG9uZS1BbHBlcyI7czo4OiJjaXR5TmFtZSI7czo0OiJMeW9uIjt9; cpnb_cookiesSettings=%7B%22required-cookies%22%3A1%2C%22analytical-cookies%22%3A1%2C%22social-media-cookies%22%3A1%7D; _fbp=fb.1.1589442649311.703096347; cookiesDirective=1; _ga_4F2ZWNSJ78=GS1.1.1593195487.49.1.1593195526.0; _ga=GA1.2.121997199.1589442647; rl_modals=26; __atuvc=1%7C28%2C0%7C29%2C0%7C30%2C1%7C31%2C3%7C32; LaVisitorId=pv0rbpe9en6uggmnkao4fe6i69qzk; cbtabsinstallfrom=cbtabnavinstallfrom2; cbtabscpayintegrations=cbtabnavcpayintegrations7; cbtabscpayeditplan=cbtabnavcpayeditplan2; cs_geolocation=YTo1OntzOjEwOiJzdGF0dXNDb2RlIjtzOjI6Ik9LIjtzOjk6ImlwQWRkcmVzcyI7czoxNDoiODYuMjAyLjEwNC4xNjkiO3M6MTE6ImNvdW50cnlDb2RlIjtzOjI6IkZSIjtzOjEwOiJyZWdpb25OYW1lIjtzOjIwOiJBdXZlcmduZS1SaG9uZS1BbHBlcyI7czo4OiJjaXR5TmFtZSI7czo0OiJMeW9uIjt9; _gid=GA1.2.1619467072.1601309349; LaSID=1dabeb5p8jj91lh85v5vrh6jyn7xi; 7e775bfdd7b804dee157f8f35267cdc0=u51vm1ajkjln7m35pn2dsu9c0c; cbtabsCB=cbtabnav11
[HTTP_ACCEPT_LANGUAGE] => fr,en-US;q=0.9,en;q=0.8,fr-FR;q=0.7
[HTTP_ACCEPT_ENCODING] => gzip, deflate, br
[HTTP_REFERER] => https://activ-ha.com/administrator/index.php?option=com_acym&ctrl=users
[HTTP_SEC_FETCH_DEST] => empty
[HTTP_SEC_FETCH_MODE] => cors
[HTTP_SEC_FETCH_SITE] => same-origin
[HTTP_X_REQUESTED_WITH] => XMLHttpRequest
[HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.121 Safari/537.36
[HTTP_ACCEPT] => /
[HTTP_CONNECTION] => close
[HTTP_X_ORIGINATING_IP] => 86.202.104.169
[HTTP_X_FORWARDED_FOR] => 86.202.104.169
[HTTP_HOST] => activ-ha.com
[proxy-nokeepalive] => 1
[HTTPS] => on
[HTTP_AUTHORIZATION] =>
[UNIQUE_ID] => X3IeSnCuNIwma3cQ5hqvLgAAAAE
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /administrator/index.php
[REQUEST_TIME_FLOAT] => 1601314378.2562
[REQUEST_TIME] => 1601314378
)`
