Conflict with Commerce module

The website encountered an unexpected error. Please try again later.Drupal\Core\Entity\EntityStorageException: SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('default_dbo'@'%') does not exist: INSERT INTO {entity_log} (uuid, langcode, user_id, entity_logged_id__target_id, entity_logged_id__target_type, label, old_value, new_value, name, log_type, hostname, status, created, changed) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13); Array ( [:db_insert_placeholder_0] => 567f3bc5-145b-4261-b33b-f4d19fcfb76d [:db_insert_placeholder_1] => en [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 595 [:db_insert_placeholder_4] => commerce_order [:db_insert_placeholder_5] => Order items [:db_insert_placeholder_6] => 584,696,574,568 [:db_insert_placeholder_7] => 584,696,574,568,539 [:db_insert_placeholder_8] => order_items [:db_insert_placeholder_9] => commerce_order [:db_insert_placeholder_10] => 127.0.0.1 [:db_insert_placeholder_11] => 1 [:db_insert_placeholder_12] => 1560402015 [:db_insert_placeholder_13] => 1560402015 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 783 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php). <pre class="backtrace">Drupal\Core\Database\Statement->execute(Array, Array) (Line: 625) Drupal\Core\Database\Connection->query('INSERT INTO {entity_log} (uuid, langcode, user_id, entity_logged_id__target_id, entity_logged_id__target_type, label, old_value, new_value, name, log_type, hostname, status, created, changed) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13)', Array, Array) (Line: 358) Drupal\Core\Database\Driver\mysql\Connection->query('INSERT INTO {entity_log} (uuid, langcode, user_id, entity_logged_id__target_id, entity_logged_id__target_type, label, old_value, new_value, name, log_type, hostname, status, created, changed) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13)', Array, Array) (Line: 32) Drupal\Core\Database\Driver\mysql\Insert->execute() (Line: 864) Drupal\Core\Entity\Sql\SqlContentEntityStorage->doSaveFieldItems(Object) (Line: 595) Drupal\Core\Entity\ContentEntityStorageBase->doSave(NULL, Object) (Line: 429) Drupal\Core\Entity\EntityStorageBase->save(Object) (Line: 774) Drupal\Core\Entity\Sql\SqlContentEntityStorage->save(Object) (Line: 390) Drupal\Core\Entity\Entity->save() (Line: 120) Drupal\entity_log\EntityLogService->logFields(Object, Array) (Line: 44) entity_log_entity_update(Object) call_user_func_array('entity_log_entity_update', Array) (Line: 403) Drupal\Core\Extension\ModuleHandler->invokeAll('entity_update', Array) (Line: 206) Drupal\Core\Entity\EntityStorageBase->invokeHook('update', Object) (Line: 773) Drupal\Core\Entity\ContentEntityStorageBase->invokeHook('update', Object) (Line: 92) Drupal\commerce\CommerceContentEntityStorage->invokeHook('update', Object) (Line: 103) Drupal\commerce_order\OrderStorage->invokeHook('update', Object) (Line: 507) Drupal\Core\Entity\EntityStorageBase->doPostSave(Object, 1) (Line: 658) Drupal\Core\Entity\ContentEntityStorageBase->doPostSave(Object, 1) (Line: 432) Drupal\Core\Entity\EntityStorageBase->save(Object) (Line: 774) Drupal\Core\Entity\Sql\SqlContentEntityStorage->save(Object) (Line: 390) Drupal\Core\Entity\Entity->save() (Line: 317) Drupal\commerce_order\Entity\OrderItem->postSave(Object, 1) (Line: 506) Drupal\Core\Entity\EntityStorageBase->doPostSave(Object, 1) (Line: 658) Drupal\Core\Entity\ContentEntityStorageBase->doPostSave(Object, 1) (Line: 432) Drupal\Core\Entity\EntityStorageBase->save(Object) (Line: 774) Drupal\Core\Entity\Sql\SqlContentEntityStorage->save(Object) (Line: 390) Drupal\Core\Entity\Entity->save() (Line: 117) Drupal\commerce_cart\CartManager->addOrderItem(Object, Object, ) (Line: 125) Drupal\commerce_combine_carts\CartUnifier->combineCarts(Object, Object, 1) (Line: 98) Drupal\commerce_combine_carts\CartUnifier->combineUserCarts(Object) (Line: 25) commerce_combine_carts_user_login(Object) call_user_func_array('commerce_combine_carts_user_login', Array) (Line: 403) Drupal\Core\Extension\ModuleHandler->invokeAll('user_login', Array) (Line: 566) user_login_finalize(Object) (Line: 230) Drupal\user\Controller\UserController->resetPassLogin('1', '1560402003', '7DJgtpl4QaRreZQPb1CXr68Rs3x6Ek2WAEqgLFM07iY') call_user_func_array(Array, Array) (Line: 123) Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 582) Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 124) Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext(Array, Array) (Line: 97) Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 151) Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 68) Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 67) Drupal\simple_oauth\HttpMiddleware\BasicAuthSwap->handle(Object, 1, 1) (Line: 57) Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 47) Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 184) Drupal\page_cache\StackMiddleware\PageCache->fetch(Object, 1, 1) (Line: 121) Drupal\page_cache\StackMiddleware\PageCache->lookup(Object, 1, 1) (Line: 75) Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 84) Drupal\shield\ShieldMiddleware->handle(Object, 1, 1) (Line: 47) Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 52) Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23) Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 693) Drupal\Core\DrupalKernel->handle(Object) (Line: 19) </pre>

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment 9 months ago →
🇩🇪Germany Anybody Porta Westfalica
I think in general, entity_log has to be able to also deal with deleted entities of any kind and may not be too strict about it. That would also be helpful for ✨ Allow logging Create & Delete events Active
Status changed to Closed: works as designed 5 months ago9:17am 23 April 2024
Comment 5 months ago →
🇭🇷Croatia MilosR Croatia, Montenegro
Hi @levmyshkin

The Entity log is used for tracking field changes on entities.

It's not used for deleting, so it seems like your custom integration for logging entity deletions caused an issue.

I tried the case you described, but I did not encounter any issues because the module does not log any deletions.