# Impossible de supprimer tous les messages d'un utilisateur en raison d'une erreur 500 du serveur

**URL:** https://meta.discourse.org/t/unable-to-delete-all-of-a-users-posts-500-server-error/255279
**Category:** Support
**Created:** [Février 15, 2023, 6:05 UTC](https://meta.discourse.org/t/unable-to-delete-all-of-a-users-posts-500-server-error/255279 "2023-02-15T18:05:08Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Headless](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/headless/32/183495_2.png) [@Headless](https://meta.discourse.org/u/Headless)
#### Post date: [Février 15, 2023, 6:05 UTC](https://meta.discourse.org/t/unable-to-delete-all-of-a-users-posts-500-server-error/255279/1 "2023-02-15T18:05:08Z")

</div>

Lorsque j’essaie de supprimer tous les messages d’un utilisateur (car c’est ce qu’il voulait), il a environ 9000 messages à supprimer. Je comprends que ce n’est pas ce que je devrais faire et que je devrais anonymiser l’utilisateur. Cependant, dans mon scénario, je dois supprimer le compte de cet utilisateur, mais avant cela, je dois supprimer ses messages. J’ai essayé de trouver un SQL pour simplement supprimer les messages avec l’explorateur de données, mais je n’ai rien trouvé à ce sujet.

Lorsque je regarde dans les journaux lorsque j’essaie de supprimer, j’obtiens l’erreur suivante, il semble s’agir d’un problème avec le plugin de notation. Toute aide serait formidable.

```plaintext
plugins/discourse-ratings/plugin.rb:147:in `block (2 levels) in activate!'
lib/plugin/instance.rb:297:in `public_send'
lib/plugin/instance.rb:297:in `block (2 levels) in add_to_class'
plugins/discourse-ratings/plugin.rb:61:in `block in activate!'
lib/plugin/instance.rb:491:in `block in on'
lib/discourse_event.rb:12:in `block in trigger'
/usr/local/lib/ruby/3.1.0/set.rb:511:in `each_key'
/usr/local/lib/ruby/3.1.0/set.rb:511:in `each'
lib/discourse_event.rb:12:in `trigger'
lib/post_destroyer.rb:84:in `destroy'
app/models/user.rb:1233:in `block in delete_posts_in_batches'
activerecord (7.0.4.1) lib/active_record/relation/delegation.rb:88:in `each'
activerecord (7.0.4.1) lib/active_record/relation/delegation.rb:88:in `each'
app/models/user.rb:1233:in `delete_posts_in_batches'
app/controllers/admin/users_controller.rb:60:in `delete_posts_batch'
actionpack (7.0.4.1) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'
actionpack (7.0.4.1) lib/abstract_controller/base.rb:215:in `process_action'
actionpack (7.0.4.1) lib/action_controller/metal/rendering.rb:53:in `process_action'
actionpack (7.0.4.1) lib/abstract_controller/callbacks.rb:234:in `block in process_action'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:118:in `block in run_callbacks'
app/controllers/application_controller.rb:414:in `block in with_resolved_locale'
i18n (1.12.0) lib/i18n.rb:322:in `with_locale'
app/controllers/application_controller.rb:414:in `with_resolved_locale'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:127:in `block in run_callbacks'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:138:in `run_callbacks'
actionpack (7.0.4.1) lib/abstract_controller/callbacks.rb:233:in `process_action'
actionpack (7.0.4.1) lib/action_controller/metal/rescue.rb:22:in `process_action'
actionpack (7.0.4.1) lib/action_controller/metal/instrumentation.rb:67:in `block in process_action'
activesupport (7.0.4.1) lib/active_support/notifications.rb:206:in `block in instrument'
activesupport (7.0.4.1) lib/active_support/notifications/instrumenter.rb:24:in `instrument'
activesupport (7.0.4.1) lib/active_support/notifications.rb:206:in `instrument'
actionpack (7.0.4.1) lib/action_controller/metal/instrumentation.rb:66:in `process_action'
actionpack (7.0.4.1) lib/action_controller/metal/params_wrapper.rb:259:in `process_action'
activerecord (7.0.4.1) lib/active_record/railties/controller_runtime.rb:27:in `process_action'
actionpack (7.0.4.1) lib/abstract_controller/base.rb:151:in `process'
actionview (7.0.4.1) lib/action_view/rendering.rb:39:in `process'
rack-mini-profiler (3.0.0) lib/mini_profiler/profiling_methods.rb:111:in `block in profile_method'
actionpack (7.0.4.1) lib/action_controller/metal.rb:188:in `dispatch'
actionpack (7.0.4.1) lib/action_controller/metal.rb:251:in `dispatch'
actionpack (7.0.4.1) lib/action_dispatch/routing/route_set.rb:49:in `dispatch'
actionpack (7.0.4.1) lib/action_dispatch/routing/route_set.rb:32:in `serve'
actionpack (7.0.4.1) lib/action_dispatch/routing/mapper.rb:18:in `block in <class:Constraints>'
actionpack (7.0.4.1) lib/action_dispatch/routing/mapper.rb:48:in `serve'
actionpack (7.0.4.1) lib/action_dispatch/journey/router.rb:50:in `block in serve'
actionpack (7.0.4.1) lib/action_dispatch/journey/router.rb:32:in `each'
actionpack (7.0.4.1) lib/action_dispatch/journey/router.rb:32:in `serve'
actionpack (7.0.4.1) lib/action_dispatch/routing/route_set.rb:852:in `call'
lib/middleware/omniauth_bypass_middleware.rb:74:in `call'
rack (2.2.6.2) lib/rack/tempfile_reaper.rb:15:in `call'
rack (2.2.6.2) lib/rack/conditional_get.rb:40:in `call'
rack (2.2.6.2) lib/rack/head.rb:12:in `call'
actionpack (7.0.4.1) lib/action_dispatch/http/permissions_policy.rb:38:in `call'
lib/content_security_policy/middleware.rb:12:in `call'
lib/middleware/anonymous_cache.rb:369:in `call'
rack (2.2.6.2) lib/rack/session/abstract/id.rb:266:in `context'
rack (2.2.6.2) lib/rack/session/abstract/id.rb:260:in `call'
actionpack (7.0.4.1) lib/action_dispatch/middleware/cookies.rb:704:in `call'
actionpack (7.0.4.1) lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'
activesupport (7.0.4.1) lib/active_support/callbacks.rb:99:in `run_callbacks'
actionpack (7.0.4.1) lib/action_dispatch/middleware/callbacks.rb:26:in `call'
actionpack (7.0.4.1) lib/action_dispatch/middleware/debug_exceptions.rb:28:in `call'
actionpack (7.0.4.1) lib/action_dispatch/middleware/show_exceptions.rb:26:in `call'
logster (2.11.4) lib/logster/middleware/reporter.rb:43:in `call'
railties (7.0.4.1) lib/rails/rack/logger.rb:40:in `call_app'
railties (7.0.4.1) lib/rails/rack/logger.rb:27:in `call'
config/initializers/100-quiet_logger.rb:20:in `call'
config/initializers/100-silence_logger.rb:29:in `call'
actionpack (7.0.4.1) lib/action_dispatch/middleware/remote_ip.rb:93:in `call'
actionpack (7.0.4.1) lib/action_dispatch/middleware/request_id.rb:26:in `call'
lib/middleware/enforce_hostname.rb:24:in `call'
rack (2.2.6.2) lib/rack/method_override.rb:24:in `call'
actionpack (7.0.4.1) lib/action_dispatch/middleware/executor.rb:14:in `call'
rack (2.2.6.2) lib/rack/sendfile.rb:110:in `call'
actionpack (7.0.4.1) lib/action_dispatch/middleware/host_authorization.rb:131:in `call'
rack-mini-profiler (3.0.0) lib/mini_profiler/profiler.rb:393:in `call'
message_bus (4.3.2) lib/message_bus/rack/middleware.rb:60:in `call'
lib/middleware/request_tracker.rb:228:in `call'
railties (7.0.4.1) lib/rails/engine.rb:530:in `call'
railties (7.0.4.1) lib/rails/railtie.rb:226:in `public_send'
railties (7.0.4.1) lib/rails/railtie.rb:226:in `method_missing'
rack (2.2.6.2) lib/rack/urlmap.rb:74:in `block in call'
rack (2.2.6.2) lib/rack/urlmap.rb:58:in `each'
rack (2.2.6.2) lib/rack/urlmap.rb:58:in `call'
unicorn (6.1.0) lib/unicorn/http_server.rb:634:in `process_client'
unicorn (6.1.0) lib/unicorn/http_server.rb:739:in `worker_loop'
unicorn (6.1.0) lib/unicorn/http_server.rb:547:in `spawn_missing_workers'
unicorn (6.1.0) lib/unicorn/http_server.rb:143:in `start'
unicorn (6.1.0) bin/unicorn:128:in `<top (required)>'
vendor/bundle/ruby/3.1.0/bin/unicorn:25:in `load'
vendor/bundle/ruby/3.1.0/bin/unicorn:25:in `<main>'

```

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [Février 15, 2023, 6:10 UTC](https://meta.discourse.org/t/unable-to-delete-all-of-a-users-posts-500-server-error/255279/2 "2023-02-15T18:10:05Z")

</div>

> [@Headless](#):
>
> `plugins/discourse-ratings/plugin.rb:147:in `block (2 levels) in activate!'`

Supprimez le plugin de app.yml, reconstruisez et réessayez.

---

<div class="post-metadata">

### Author: ![Headless](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/headless/32/183495_2.png) [@Headless](https://meta.discourse.org/u/Headless)
#### Post date: [Février 15, 2023, 6:20 UTC](https://meta.discourse.org/t/unable-to-delete-all-of-a-users-posts-500-server-error/255279/3 "2023-02-15T18:20:05Z")

</div>

Le plugin est-il simplement cassé ? Nous utilisons toujours le plugin, vous dites que je dois supprimer le plugin, reconstruire, supprimer les publications, le rajouter et reconstruire à nouveau ?

---

<div class="post-metadata">

### Author: ![jericson](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jericson/32/116215_2.png) [@jericson](https://meta.discourse.org/u/jericson)
#### Post date: [Septembre 10, 2024, 3:22 UTC](https://meta.discourse.org/t/unable-to-delete-all-of-a-users-posts-500-server-error/255279/4 "2024-09-10T15:22:31Z")

</div>

> [@Headless](#):
>
> Le plugin est-il simplement cassé ?

Ayant échoué à supprimer [un utilisateur spammeur](https://beta.buildcivitas.com/t/using-posthog-to-observe-spam-as-it-happens/211), je peux confirmer que le plugin est toujours cassé.

> [@Headless](#):
>
> Nous utilisons toujours le plugin, vous dites que je dois supprimer le plugin, reconstruire, supprimer les messages, le rajouter et reconstruire à nouveau ?

Ce n’est pas vraiment une solution. ☹ J’ai soumis [un problème](https://github.com/paviliondev/discourse-ratings/issues/70) sur le dépôt GitHub.