LOG.error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'field list'

[rajamid]

After migrating to new snipe it 17.1.15 and db restore has this error.

LOG.error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'field list' (Connection: mysql, SQL: select id, created_by, created_at, updated_at, name, category_type, use_default_eula, eula_text, require_acceptance, checkin_email, image, (select count() from accessories where categories.id = accessories.category_id and accessories.deleted_at is null) as accessories_count, (select count() from consumables where categories.id = consumables.category_id and consumables.deleted_at is null) as consumables_count, (select count() from components where categories.id = components.category_id and components.deleted_at is null) as components_count, (select count() from licenses where categories.id = licenses.category_id and licenses.deleted_at is null) as licenses_count, (select count(*) from assets inner join models on models.id = assets.model_id where categories.id = models.category_id and exists (select * from status_labels where assets.status_id = status_labels.id and archived = 0 and status_labels.deleted_at is null) and assets.deleted_at is null and models.deleted_at is null) as assets_count from categories where categories.deleted_at is null order by assets_count desc limit 20 offset 0) {
"userId": 1,
"exception": {
"errorInfo": [
"42S22",
1054,
"Unknown column 'created_by' in 'field list'"
],
"connectionName": "mysql"
}

[snipe]

Did you run migrations?

[rajamid]

Yes MIgration gives table exists error.

…

On Thu, 16 Jan 2025, 16:23 snipe, ***@***.***> wrote: Did you run migrations? — Reply to this email directly, view it on GitHub <#16086 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ANUIUNB44MJHMCQA5PPGIKT2K6XGFAVCNFSM6AAAAABVJTQK22VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKOJVGY3DGNRQHA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[snipe]

We'd need a little more information than that. What's the specific error when you try to run migrations?