Created
January 10, 2024 16:31
-
-
Save chumkui/c7f3712047f95244b2f1e7562dbd86bb to your computer and use it in GitHub Desktop.
mysqli_real_escape_string error
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #0 /var/www/html/vendor/pear/db/DB/mysqli.php(872): mysqli_real_escape_string(Object(mysqli), Array) | |
| #1 /var/www/html/vendor/civicrm/civicrm-packages/DB/DataObject.php(1851): DB_mysqli->escapeSimple(Array) | |
| #2 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(2225): DB_DataObject->escape(Array) | |
| #3 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(2951): CRM_Core_DAO::escapeString(Array) | |
| #4 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Api3SelectQuery.php(99): CRM_Core_DAO::createSQLFilter('a.name', Array) | |
| #5 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/SelectQuery.php(114): Civi\API\Api3SelectQuery->buildWhereClause() | |
| #6 /var/www/html/vendor/civicrm/civicrm-core/api/v3/utils.php(1258): Civi\API\SelectQuery->run() | |
| #7 /var/www/html/vendor/civicrm/civicrm-core/api/v3/CaseType.php(47): _civicrm_api3_basic_get('CRM_Case_BAO_Ca...', Array) | |
| #8 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_case_type_get(Array) | |
| #9 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(156): Civi\API\Provider\MagicFunctionProvider->invoke(Array) | |
| #10 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(79): Civi\API\Kernel->runRequest(Array) | |
| #11 /var/www/html/vendor/civicrm/civicrm-core/api/api.php(28): Civi\API\Kernel->runSafe('CaseType', 'get', Array) | |
| #12 /var/www/html/vendor/civicrm/civicrm-core/api/v3/Generic.php(303): civicrm_api('CaseType', 'get', Array) | |
| #13 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Provider/MagicFunctionProvider.php(85): civicrm_api3_generic_getsingle(Array) | |
| #14 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(156): Civi\API\Provider\MagicFunctionProvider->invoke(Array) | |
| #15 /var/www/html/vendor/civicrm/civicrm-core/Civi/API/Kernel.php(79): Civi\API\Kernel->runRequest(Array) | |
| #16 /var/www/html/vendor/civicrm/civicrm-core/api/api.php(136): Civi\API\Kernel->runSafe('CaseType', 'getsingle', Array) | |
| #17 /var/www/html/vendor/civicrm/civicrm-core/CRM/Case/BAO/Case.php(2995): civicrm_api3('CaseType', 'getsingle', Array) | |
| #18 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Utils/FormattingUtil.php(306): CRM_Case_BAO_Case::buildOptions('status_id', 'validate', Array) | |
| #19 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Utils/FormattingUtil.php(116): Civi\Api4\Utils\FormattingUtil::getPseudoconstantList(Array, 'status_id:name', Array, 'get') | |
| #20 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Query/Api4SelectQuery.php(361): Civi\Api4\Utils\FormattingUtil::formatInputValue('Open', 'status_id:name', Array, Array, '=') | |
| #21 /var/www/html/vendor/civicrm/civicrm-core/Civi/Api4/Query/Api4SelectQuery.php(88): Civi\Api4\Query\Api4SelectQuery->getAclClause('a', 'Case', Array, Array) | |
| #22 /var/www/html/vendor/civicrm/civicrm-core/ext/search_kit/Civi/Search/Meta.php(37): Civi\Api4\Query\Api4SelectQuery->__construct(Object(Civi\Api4\Generic\DAOGetAction)) | |
| #23 /var/www/html/vendor/civicrm/civicrm-core/ext/search_kit/Civi/Search/AfformSearchMetadataInjector.php(74): Civi\Search\Meta::getCalcFields('Case', Array) | |
| #24 [internal function]: Civi\Search\AfformSearchMetadataInjector::Civi\Search\{closure}(Object(phpQueryObject), '~/afsearchFarmS...') | |
| #25 /var/www/html/vendor/civicrm/civicrm-core/Civi/Angular/ChangeSet.php(59): call_user_func(Object(Closure), Object(phpQueryObject), '~/afsearchFarmS...') | |
| #26 /var/www/html/vendor/civicrm/civicrm-core/Civi/Angular/ChangeSet.php(19): Civi\Angular\ChangeSet::applyHtmlFilters(Array, Array) | |
| #27 /var/www/html/vendor/civicrm/civicrm-core/Civi/Angular/Manager.php(266): Civi\Angular\ChangeSet::applyResourceFilters(Array, 'partials', Array) | |
| #28 /var/www/html/vendor/civicrm/civicrm-core/Civi/Angular/Page/Modules.php(161): Civi\Angular\Manager->getPartials('afsearchFarmSes...') | |
| #29 /var/www/html/vendor/civicrm/civicrm-core/Civi/Angular/Page/Modules.php(84): Civi\Angular\Page\Modules->getMetadata(Array, Object(Civi\Angular\Manager)) | |
| #30 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(220): Civi\Angular\Page\Modules::buildAngularModules(Object(Civi\Core\Event\GenericHookEvent), 'hook_civicrm_bu...', Object(Civi\Core\UnoptimizedEventDispatcher)) | |
| #31 /var/www/html/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners(Array, 'hook_civicrm_bu...', Object(Civi\Core\Event\GenericHookEvent)) | |
| #32 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(263): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Civi\Core\Event\GenericHookEvent), 'hook_civicrm_bu...') | |
| #33 /var/www/html/vendor/civicrm/civicrm-core/CRM/Utils/Hook.php(168): Civi\Core\CiviEventDispatcher->dispatch('hook_civicrm_bu...', Object(Civi\Core\Event\GenericHookEvent)) | |
| #34 /var/www/html/vendor/civicrm/civicrm-core/CRM/Utils/Hook.php(2784): CRM_Utils_Hook->invoke(Array, 'angular-modules...', Array, 'application/jso...', NULL, NULL, NULL, 'civicrm_buildAs...') | |
| #35 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/AssetBuilder.php(226): CRM_Utils_Hook::buildAsset('angular-modules...', Array, 'application/jso...', NULL) | |
| #36 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/AssetBuilder.php(198): Civi\Core\AssetBuilder->render('angular-modules...', Array) | |
| #37 /var/www/html/vendor/civicrm/civicrm-core/Civi/Core/AssetBuilder.php(136): Civi\Core\AssetBuilder->build('angular-modules...', Array) | |
| #38 /var/www/html/vendor/civicrm/civicrm-core/Civi/Angular/AngularLoader.php(169): Civi\Core\AssetBuilder->getUrl('angular-modules...', Array) | |
| #39 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/Resources/CollectionTrait.php(394): Civi\Angular\AngularLoader->Civi\Angular\{closure}() | |
| #40 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/Region.php(142): CRM_Core_Region->getSettings() | |
| #41 /var/www/html/vendor/civicrm/civicrm-core/CRM/Core/Region.php(157): CRM_Core_Region->{closure}(Array) | |
| #42 /var/www/html/web/modules/contrib/civicrm/civicrm.module(37): CRM_Core_Region->render('') | |
| #43 /var/www/html/web/core/lib/Drupal/Core/Render/MainContent/HtmlRenderer.php(311): civicrm_page_attachments(Array) | |
| #44 /var/www/html/web/core/lib/Drupal/Core/Extension/ModuleHandler.php(388): Drupal\Core\Render\MainContent\HtmlRenderer->Drupal\Core\Render\MainContent\{closure}(Object(Closure), 'civicrm') | |
| #45 /var/www/html/web/core/lib/Drupal/Core/Render/MainContent/HtmlRenderer.php(312): Drupal\Core\Extension\ModuleHandler->invokeAllWith('page_attachment...', Object(Closure)) | |
| #46 /var/www/html/web/core/lib/Drupal/Core/Render/MainContent/HtmlRenderer.php(285): Drupal\Core\Render\MainContent\HtmlRenderer->invokePageAttachmentHooks(Array) | |
| #47 /var/www/html/web/core/lib/Drupal/Core/Render/Renderer.php(627): Drupal\Core\Render\MainContent\HtmlRenderer->Drupal\Core\Render\MainContent\{closure}() | |
| #48 /var/www/html/web/core/lib/Drupal/Core/Render/MainContent/HtmlRenderer.php(286): Drupal\Core\Render\Renderer->executeInRenderContext(Object(Drupal\Core\Render\RenderContext), Object(Closure)) | |
| #49 /var/www/html/web/core/lib/Drupal/Core/Render/MainContent/HtmlRenderer.php(128): Drupal\Core\Render\MainContent\HtmlRenderer->prepare(Array, Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\Core\Routing\CurrentRouteMatch)) | |
| #50 /var/www/html/web/core/lib/Drupal/Core/EventSubscriber/MainContentViewSubscriber.php(90): Drupal\Core\Render\MainContent\HtmlRenderer->renderResponse(Array, Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\Core\Routing\CurrentRouteMatch)) | |
| #51 [internal function]: Drupal\Core\EventSubscriber\MainContentViewSubscriber->onViewRenderArray(Object(Symfony\Component\HttpKernel\Event\ViewEvent), 'kernel.view', Object(Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher)) | |
| #52 /var/www/html/web/core/lib/Drupal/Component/EventDispatcher/ContainerAwareEventDispatcher.php(111): call_user_func(Array, Object(Symfony\Component\HttpKernel\Event\ViewEvent), 'kernel.view', Object(Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher)) | |
| #53 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(186): Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch(Object(Symfony\Component\HttpKernel\Event\ViewEvent), 'kernel.view') | |
| #54 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) | |
| #55 /var/www/html/web/core/lib/Drupal/Core/StackMiddleware/Session.php(58): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #56 /var/www/html/web/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #57 /var/www/html/web/core/lib/Drupal/Core/StackMiddleware/ContentLength.php(28): Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #58 /var/www/html/web/core/modules/big_pipe/src/StackMiddleware/ContentLength.php(32): Drupal\Core\StackMiddleware\ContentLength->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #59 /var/www/html/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\big_pipe\StackMiddleware\ContentLength->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #60 /var/www/html/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #61 /var/www/html/web/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\page_cache\StackMiddleware\PageCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #62 /var/www/html/web/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #63 /var/www/html/web/core/lib/Drupal/Core/StackMiddleware/AjaxPageState.php(36): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #64 /var/www/html/web/core/lib/Drupal/Core/StackMiddleware/StackedHttpKernel.php(51): Drupal\Core\StackMiddleware\AjaxPageState->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #65 /var/www/html/web/core/lib/Drupal/Core/DrupalKernel.php(704): Drupal\Core\StackMiddleware\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) | |
| #66 /var/www/html/web/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request)) | |
| #67 {main} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment