Error FieldError Value
TypeDB_Error
Code-2
MessageDB Error: syntax error
Mode16
UserInfoSELECT g.* from civicrm_uf_group g WHERE g.id IN ( ) AND g.is_active = 1 AND g.id IN ( 10,13,11,1,6,4,5,9,3,23,8,7,2,22,24 ) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND g.is_active = 1 AND g.id IN ( 10,13,11,1,6,4,5,9,3,23,8,7,2,22,24 )' at line 1]
DebugInfoSELECT g.* from civicrm_uf_group g WHERE g.id IN ( ) AND g.is_active = 1 AND g.id IN ( 10,13,11,1,6,4,5,9,3,23,8,7,2,22,24 ) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND g.is_active = 1 AND g.id IN ( 10,13,11,1,6,4,5,9,3,23,8,7,2,22,24 )' at line 1]
Civi\Core\Exception\DBQueryException: DB Error: syntax error in /Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 945
- DB_Error: DB Error: syntax error in unknown on line unknown
Exception trace
#FunctionLocation
0CRM_Core_Error::exceptionHandler(Object(DB_Error))/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:945
1PEAR_Error->__construct('DB Error: syntax…', -2, 16, Array, 'SELECT g.* from …')/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/vendor/pear/db/DB.php:1001
2DB_Error->__construct(-2, 16, Array, 'SELECT g.* from …')/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:575
3PEAR::_raiseError(Object(DB_mysqli), null, -2, 16, Array, 'SELECT g.* from …', 'DB_Error', true)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php:223
4PEAR->__call('raiseError', Array)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/vendor/pear/db/DB/common.php:1951
5DB_common->raiseError(-2, null, null, 'SELECT g.* from …', '1064 ** You have…')/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/vendor/pear/db/DB/mysqli.php:964
6DB_mysqli->mysqliRaiseError()/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/vendor/pear/db/DB/mysqli.php:413
7DB_mysqli->simpleQuery('SELECT g.* from …')/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/vendor/pear/db/DB/common.php:1241
8DB_common->query('SELECT g.* from …')/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php:2696
9DB_DataObject->_query('SELECT g.* from …')/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php:1829
10DB_DataObject->query('SELECT g.* from …')/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php:507
11CRM_Core_DAO->query('SELECT g.* from …', true)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php:1764
12CRM_Core_DAO::executeQuery('SELECT g.* from …', Array)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/UFGroup.php:326
13CRM_Core_BAO_UFGroup::getFields(Array, false, 4, 5, null, false, null, false, null, 5)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/UFGroup.php:196
14CRM_Core_BAO_UFGroup::getListingFields(4, 5, false, Array)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Profile/Selector/Listings.php:157
15CRM_Profile_Selector_Listings->__construct(Array, Array, null, 0, false, 0)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Profile/Page/Listings.php:370
16CRM_Profile_Page_Listings->run()/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Profile/Page/Router.php:107
17CRM_Profile_Page_Router->run(Array, null)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:323
18CRM_Core_Invoke::runItem(Array)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:69
19CRM_Core_Invoke::_invoke(Array)/Users/frank/Documents/AESOP-YA/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:36
20CRM_Core_Invoke::invoke(Array)/Users/frank/Documents/AESOP-YA/components/com_civicrm/civicrm.php:84
21civicrm_invoke()/Users/frank/Documents/AESOP-YA/components/com_civicrm/civicrm.php:11
22require_once('/Users/frank/Doc…')/Users/frank/Documents/AESOP-YA/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
23Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}('/Users/frank/Doc…')/Users/frank/Documents/AESOP-YA/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
24Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()/Users/frank/Documents/AESOP-YA/libraries/src/Component/ComponentHelper.php:361
25Joomla\CMS\Component\ComponentHelper::renderComponent('com_civicrm')/Users/frank/Documents/AESOP-YA/libraries/src/Application/SiteApplication.php:208
26Joomla\CMS\Application\SiteApplication->dispatch()/Users/frank/Documents/AESOP-YA/libraries/src/Application/SiteApplication.php:249
27Joomla\CMS\Application\SiteApplication->doExecute()/Users/frank/Documents/AESOP-YA/libraries/src/Application/CMSApplication.php:293
28Joomla\CMS\Application\CMSApplication->execute()/Users/frank/Documents/AESOP-YA/includes/app.php:61
29require_once('/Users/frank/Doc…')/Users/frank/Documents/AESOP-YA/index.php:32
30{main} 
Error
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: syntax error

Return to home page.