# Bug OP-11351 - Migration to 12.3.1 fails with Key columns "user_id" and "id" are of incompatible types: numeric and bigint.

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

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | High |
| Module |  |
| Target versions | 12.3.2 |
| Observed in versions | 12.3.0 |
| Sprint | 12.3.2 |
| Backlog bucket |  |
| Bug found in version (deprecated) | 12.3.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 | Markus Kahl |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

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

## Costs

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

## Description

For MySQL-migrated databases, the migration to 12.3.1 might fail as the `user_id` column of the `tokens` table has a `numeric` or  `integer` data type, but we expect it to match the `users#id` type, which most often is bigint.