We are installed openproject on our server Debian 11 with latest patch and PostgreSQL 13.

2 weeks ago we upgrade our installation in 2 steps:

First

12.4.1 to 12.5.8

and next

12.5.8 to 13.0.7

Before this no problem happened. Suddenly, when we filter on Work Packages, it shows this error: "Your view is erroneous and could not be processed. An internal error has occurred. ", as in Begin of the insertionattachment.End of the insertion Begin of the deletion attachment. End of the deletion

Searching errors, increasing log level via additional\_environment.rb to debug e re-running configure doesn't produce any log.

So I search in the log of postgresql and I find this error occur when that search was runned

`**2023-11-06 13:45:25.576 CET [1376804] openproject@openproj ERROR:  column attachments.fulltext_tsv does not exist at character 4253**`
`2023-11-06 13:45:25.576 CET [1376804] openproject@openproj STATEMENT:  SELECT "work_packages"."id" FROM "work_packages" INNER JOIN "statuses" ON "statuses"."id" = "work_packages"."status_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "work_packages"."project_id" WHERE "work_packages"."project_id" IN (SELECT "projects"."id" FROM "projects" WHERE "projects"."id" IN (SELECT "projects"."id" FROM "projects" INNER JOIN "enabled_modules" ON "projects"."id" = "enabled_modules"."project_id" AND "enabled_modules"."name" IN ('work_package_tracking') AND "projects"."active" = TRUE WHERE "projects"."active" = TRUE)) AND ((statuses.is_closed=FALSE) AND (work_packages.subject ILIKE '%my%' AND work_packages.subject ILIKE '%test%' OR work_packages.description ILIKE '%my%' AND work_packages.description ILIKE '%test%' OR EXISTS (     SELECT 1 FROM journals`
          Begin of the insertion  `WHEREEnd of the insertion Begin of the deletion   `WHEREEnd of the deletion journals.journable_id = work_packages.id`
                Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion journals.journable_type = 'WorkPackage'`
          Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion journals.notes ILIKE '%my%' AND journals.notes ILIKE '%test%'`
       `) OR           work_packages.id IN`
                 `(SELECT work_packages.id`
                 `FROM work_packages`
                 `LEFT OUTER JOIN custom_values`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_values.customized_type = 'WorkPackage'`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.customized_id = work_packages.id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.custom_field_id = 1`
                    Begin of the insertion  `JOINEnd of the insertion Begin of the deletion   `JOINEnd of the deletion custom_fields_types`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_fields_types.type_id = work_packages.type_id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_fields_types.custom_field_id = 1`
                 `WHERE custom_values.value ILIKE '%my%' AND custom_values.value ILIKE '%test%')`
      Begin of the insertion  `OREnd of the insertion   Begin of the deletion `OREnd of the deletion         Begin of the deletion  End of the deletion work_packages.id IN`
                 `(SELECT work_packages.id`
                 `FROM work_packages`
                 `LEFT OUTER JOIN custom_values`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_values.customized_type = 'WorkPackage'`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.customized_id = work_packages.id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.custom_field_id = 3`
                    Begin of the insertion  `JOINEnd of the insertion Begin of the deletion   `JOINEnd of the deletion custom_fields_types`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_fields_types.type_id = work_packages.type_id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_fields_types.custom_field_id = 3`
                 `WHERE custom_values.value ILIKE '%my%' AND custom_values.value ILIKE '%test%')`
      Begin of the insertion  `OREnd of the insertion   Begin of the deletion `OREnd of the deletion         Begin of the deletion  End of the deletion work_packages.id IN`
                 `(SELECT work_packages.id`
                 `FROM work_packages`
                 `LEFT OUTER JOIN custom_values`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_values.customized_type = 'WorkPackage'`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.customized_id = work_packages.id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.custom_field_id = 12`
                    Begin of the insertion  `JOINEnd of the insertion Begin of the deletion   `JOINEnd of the deletion custom_fields_types`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_fields_types.type_id = work_packages.type_id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_fields_types.custom_field_id = 12 JOIN custom_fields_projects`
                          Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_fields_projects.project_id = work_packages.project_id`
                          Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_fields_projects.custom_field_id = 12`
                 `WHERE custom_values.value ILIKE '%my%' AND custom_values.value ILIKE '%test%')`
      Begin of the insertion  `OREnd of the insertion   Begin of the deletion `OREnd of the deletion         Begin of the deletion  End of the deletion work_packages.id IN`
                 `(SELECT work_packages.id`
                 `FROM work_packages`
                 `LEFT OUTER JOIN custom_values`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_values.customized_type = 'WorkPackage'`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.customized_id = work_packages.id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.custom_field_id = 20`
                    Begin of the insertion  `JOINEnd of the insertion Begin of the deletion   `JOINEnd of the deletion custom_fields_types`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_fields_types.type_id = work_packages.type_id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_fields_types.custom_field_id = 20`
                 `WHERE custom_values.value ILIKE '%my%' AND custom_values.value ILIKE '%test%')`
      Begin of the insertion  `OREnd of the insertion   Begin of the deletion `OREnd of the deletion         Begin of the deletion  End of the deletion work_packages.id IN`
                 `(SELECT work_packages.id`
                 `FROM work_packages`
                 `LEFT OUTER JOIN custom_values`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_values.customized_type = 'WorkPackage'`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.customized_id = work_packages.id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_values.custom_field_id = 30`
                    Begin of the insertion  `JOINEnd of the insertion Begin of the deletion   `JOINEnd of the deletion custom_fields_types`
                      Begin of the insertion  `ONEnd of the insertion Begin of the deletion   `ONEnd of the deletion custom_fields_types.type_id = work_packages.type_id`
                      Begin of the insertion  `ANDEnd of the insertion Begin of the deletion   `ANDEnd of the deletion custom_fields_types.custom_field_id = 30`
                 `WHERE custom_values.value ILIKE '%my%' AND custom_values.value ILIKE '%test%')`
      Begin of the insertion  `OREnd of the insertion Begin of the deletion   `OREnd of the deletion EXISTS (      SELECT 1 FROM attachments`
             `WHERE attachments.container_id = work_packages.id`
             `AND attachments.container_type = 'WorkPackage'`
             `AND "attachments"."fulltext_tsv" @@ to_tsquery('english', 'my & test')`
       `) OR EXISTS (      SELECT 1 FROM attachments`
             `WHERE attachments.container_id = work_packages.id`
             `AND attachments.container_type = 'WorkPackage'`
             `AND "attachments"."file_tsv" @@ to_tsquery('english', 'my & test')`
       `)) AND (projects.id IN (10))) ORDER BY work_packages.id LIMIT $1 OFFSET $2` Begin of the insertion

End of the insertion Begin of the deletion


End of the deletion Can you help me to solve the problem? I suppose are necessary some DB actions.. Begin of the insertion

End of the insertion Begin of the deletion


End of the deletion **OpenProject installation type**

* [ ] Hosted cloud edition
* [x] Packaged installation
* What distribution? Debian 11
* [ ] Docker All-in-one container
* [ ] Docker-compose installation
* [ ] Other (please specify)

**OpenProject version**

_13.0.7_

**Browser**

* [x] Chrome
* [x] Firefox
* [ ] Safari
* [ ] Mobile Safari
* [ ] Other (please specify)

**Language**

_Italian and English_