User Messages Inbox Error 500

[Benjamin_D (Benjamin Decotte)]

@v.stephan

Or do we have to delete them?

According to Jay :

@pfaffman

It will delete any private messages that were not created by a system user or discobot. It will still delete any other private messages, including those from admins.

It’s not tested. I’m not saying that it’s a good idea. I won’t promise that it won’t do something bad.

cd /var/discourse
discourse backup
./launcher enter app
rails s
Topic.where(archetype: 'private_message').where("user_id > 0").destroy_all
exit
discourse enable_restore
discourse restore

If something bad does not happen, you can omit the last two steps. If something bad does happen, you’ll want to copy/paste the most recent backup printed by the discourse restore command to restore the backup.

I’d try to replace the condition where("user_id > 0") by something like where("user_id = the-id-of-your-user")

About the why this is happening? my bet would be something localized, I myself sometime have trouble with quotation marks, accents, etc…