I encountered an unusual error:
Unhandled error in GET /managers:
500 Error: ER_BAD_FIELD_ERROR: Unknown column 'role_id' in 'field list'
at Query.Sequence._packetToError
(/Users/xxxx/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
To address this, I added a new field called role_id which is linked to a table named role.
Here are the steps I have tried so far:
- Dropping all tables and recreating them (utilizing Liquibase)
- Dropping the current database
- Creating a database with a different name
Despite these attempts, I am still unsure of what to do next.
The details of my Datasource configuration are as follows:
{
"name": "db",
"connector": "mysql",
"url": "",
"host": "localhost",
"port": 3306,
"user": "root",
"password": "xxx",
"database": "xxx.dev"
}
Below is the model implementation:
import {Entity, model, property, belongsTo} from '@loopback/repository'; import {Role} from './role.model';
@model({
name: 'role',
settings: {strict: false},
})
export class Manager extends Entity {
@property({
type: 'number',
id: true,
required: true,
})
id: number;
@belongsTo(() => Role, {
name: 'role',
})
role_id: number;
@property({
type: 'string',
required: true,
})
first_name: string;
@property({
type: 'string',
required: true,
})
last_name: string;
[props: string]: any;
constructor(data?: Partial<Manager>) {
super(data);
}
}