# Bug OP-8053 - Renamed column updated_on is still referenced for settings

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-8053

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | High |
| Module |  |
| Target versions | 11.1.1 |
| Observed in versions | 11.1.0 |
| Sprint | 11.1.1 |
| Backlog bucket |  |
| Bug found in version (deprecated) | 11.1.x |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### **Environment**:

Your OpenProject Version: 11.1

### **Logs**

``` text
web_1     | I, [2020-12-18T16:28:25.852244 #32]  INFO -- : method=GET path=/ format=html controller=HomescreenController action=index status=500 duration=117.84 view=14.78 db=8.15 user=2
web_1     | I, [2020-12-18T16:28:27.678923 #32]  INFO -- : method=PATCH path=/user_settings format=html controller=OnboardingController action=user_settings status=302 duration=18.42 view=0.00 db=5.16 location=http://localhost:8080/ user=2
web_1     | E, [2020-12-18T16:28:27.759850 #32] ERROR -- : [current_user=OpenProject Admin] PG::UndefinedColumn: ERROR:  column "updated_on" of relation "settings" does not exist
web_1     | LINE 1: UPDATE "settings" SET "value" = $1, "updated_on" = $2 WHERE ...
web_1     |                                             ^
web_1     | : PG::UndefinedColumn: ERROR:  column "updated_on" of relation "settings" does not exist
web_1     | LINE 1: UPDATE "settings" SET "value" = $1, "updated_on" = $2 WHERE ...
web_1     |                                             ^
web_1     |
web_1     | I, [2020-12-18T16:28:27.772141 #32]  INFO -- : method=GET path=/ format=html controller=HomescreenController action=index status=500 duration=60.70 view=10.27 db=9.07 user=2
```

<https://github.com/opf/openproject-deploy/issues/4>

This seems to highlight a critical issue where some parts of the code still try to access the `update_on` column, which was renamed to `updated_at` for 11.1

### **Steps to reproduce:**

1.  Clone the deploy repo
2.  docker-compose pull
3.  docker-compose up
4.  Access the page, try to update some part of the settings

### **Actual Behavior**

The above should work.

### **Expected Behavior**

It throws a 500 error