# Migration-Fehler: \`ActiveRecord::NotNullViolation: PG::NotNullViolation: FEHLER: Spalte „private\_message“ enthält Nullwerte\`

**URL:** <https://meta.discourse.org/t/migration-error-activerecord-pg-error-column-private-message-contains-null-values/161304>\
**Category:** Product Support\
**Created:** [18. August 2020 um 18:52 UTC](https://meta.discourse.org/t/migration-error-activerecord-pg-error-column-private-message-contains-null-values/161304 "2020-08-18T18:52:32Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![tgxworld](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tgxworld/32/106117_2.png) [@tgxworld](https://meta.discourse.org/u/tgxworld)\
**Post date:** [19. August 2020 um 00:09 UTC](https://meta.discourse.org/t/migration-error-activerecord-pg-error-column-private-message-contains-null-values/161304/2 "2020-08-19T00:09:21Z")

</div>

Hmm, das ist seltsam… kannst du die folgenden Abfragen für mich in der Rails-Konsole ausführen und mir die Ergebnisse mitteilen?

```ruby
DB.query_single(<<~SQL)
SELECT COUNT(*) FROM post_search_data
SQL

DB.query_single(<<~SQL)
SELECT COUNT(*)
FROM post_search_data
LEFT JOIN posts ON posts.id = post_search_data.post_id
LEFT JOIN topics ON topics.id = posts.topic_id 
WHERE topics.id IS NULL
SQL

DB.query_single(<<~SQL)
SELECT COUNT(*)
FROM post_search_data
LEFT JOIN posts ON posts.id = post_search_data.post_id
WHERE posts.id IS NULL
SQL

DB.query_single(<<~SQL)
SELECT COUNT(*)
FROM post_search_data
INNER JOIN posts ON posts.id = post_search_data.post_id
INNER JOIN topics ON topics.id = posts.topic_id
SQL

```

---

_[View the full topic](https://meta.discourse.org/t/migration-error-activerecord-pg-error-column-private-message-contains-null-values/161304)._
