SqliteError: no such table: main.old_profiles

[TheGP]

I got an error:

\node_modules\better-sqlite3\lib\methods\wrappers.js:5
        return this[cppdb].prepare(sql, this, false);
                           ^
SqliteError: no such table: main.old_profiles
    at Database.prepare (\node_modules\better-sqlite3\lib\methods\wrappers.js:5:21)
    at parsePhotos (file:///photo-filler/app.js:401:27)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async file:///app.js:91:13 {
  code: 'SQLITE_ERROR'
}

The SQL for the error on line 401:

const insert = db.prepare('INSERT INTO photos (profileId, href, img, description) VALUES (@profileId, @href, @img, @description)');

[neoxpert]

SqliteError: no such table: main.old_profiles is an error caused by SQlite itself, not this library. I doubt that only this line is to blame for this error, as something tries to use the mentioned table. Also be aware, that the line number may be off if some transpiling / bundeling is happening.

[TheGP]

It was a foreign key reference error.