Sqlite Discord.js: Cannot Read Property 'run' Of Null

So I am trying to make a SQLite database for my Discord.js bot, but I keep getting this error (Cannot read property of 'run' of null) when I try to use SQLite. Non of my friends se

Solution 1:

You need to open connection with the database and then run the SQL query.

const sql = require("sqlite")
const db = sql.open('./database.sqlite', { Promise });

db.run("CREATE TABLE IF NOT EXISTS guild (guildId TEXT, language INTEGER, links INTEGER)");