E
E
Elbakidze2021-06-16 21:30:38
MySQL
Elbakidze, 2021-06-16 21:30:38

How to fix db error?

Guys, can you please tell me step by step how to fix the error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'artist_id' in 'field list' (SQL: select `id`, `name`, `artist_id`, `updated_at` from `albums` where `fully_scraped` = 1 or `spotify_id` is null

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Page-Audit.ru, 2021-06-16
@Elbakidze

You can do this:
select `id`, `name`, `updated_at` from `albums` where `fully_scraped` = 1 or `spotify_id` is null
Although you need to understand what you meant by the phrase "fix the error" - fix the query or fix the table in the database.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question