JS Can't query MySQL database. ERROR: connection.query is not a function

Question

Trying to query my mySQL database but I can't because i get a TypeError: connection.query is not a function error. Does anyone have any idea why? I don't have any clue as to why this is happening.

database.js

const fs = require('fs'); // node.js file system module
require('dotenv').config(); // stores tokens, keys, passwords and other info
const Discord = require('discord.js'); // links discord.js api to file
const database = require('./database.js');

const client = new Discord.Client(); // creates bot user

let connection;
(async () => {
    connection = await require('./database.js');
    await client.login(process.env.TOKEN); // bot goes from offline to online
})();

client.once('ready', () => console.info(`[${date.toLocaleString()}] INFO | Ready, logged in as ${client.user.tag} (${client.user.id})\n------------------------`));

client.on('guildCreate', async guild => {
    try {
        await connection.query(`INSERT INTO guildInfo VALUES('${guild.id}', '${guild.ownerID}')`);
        await connection.query(`INSERT INTO guildConfig (guildID) VALUES('${guild.id}')`);
    } catch(err) {
        console.error(err);
    }
});

database.js

require('dotenv').config();
const mysql = require('mysql2/promise');

date = new Date();
mysql.createConnection({
    user: process.env.USER,
    password: process.env.PASSWORD,
    database: process.env.DATABASE
}).then(connection => console.info(`[${date.toLocaleString()}] INFO | Waiting for input/changes to code\n------------------------`)).catch(err => console.error(err));

Error

TypeError: connection.query is not a function
    at Client.<anonymous> (C:\Users\Patrick Lawrence\Desktop\Synth\index.js:43:20)
    at Client.emit (events.js:315:20)
    at Object.module.exports [as GUILD_CREATE] (C:\Users\Patrick Lawrence\Desktop\Synth\node_modules\discord.js\src\client\websocket\handlers\GUILD_CREATE.js:33:14)
    at WebSocketManager.handlePacket (C:\Users\Patrick Lawrence\Desktop\Synth\node_modules\discord.js\src\client\websocket\WebSocketManager.js:384:31)
    at WebSocketShard.onPacket (C:\Users\Patrick Lawrence\Desktop\Synth\node_modules\discord.js\src\client\websocket\WebSocketShard.js:444:22)
    at WebSocketShard.onMessage (C:\Users\Patrick Lawrence\Desktop\Synth\node_modules\discord.js\src\client\websocket\WebSocketShard.js:301:10)
    at WebSocket.onMessage (C:\Users\Patrick Lawrence\Desktop\Synth\node_modules\ws\lib\event-target.js:125:16)
    at WebSocket.emit (events.js:315:20)
    at Receiver.receiverOnMessage (C:\Users\Patrick Lawrence\Desktop\Synth\node_modules\ws\lib\websocket.js:797:20)
    at Receiver.emit (events.js:315:20)

database.js is not exporting anything, it seems.

Aioros
– Aioros

2020-09-01 22:29:33 +00:00
Commented Sep 1, 2020 at 22:29 — Aioros
– Aioros, Commented Sep 1, 2020 at 22:29
@aioros thanks! how would I export it?

pat-lawre
– pat-lawre

2020-09-01 22:33:35 +00:00
Commented Sep 1, 2020 at 22:33 — pat-lawre
– pat-lawre, Commented Sep 1, 2020 at 22:33

Pur2all · Accepted Answer · 2020-09-01 22:42:34Z

1

Simply you don't export the connection in database.js.

Once created connection, assign it to a variable like const connection and type at bottom of the file module.exports = connection.

answered Sep 1, 2020 at 22:42

Pur2all

462 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JS Can't query MySQL database. ERROR: connection.query is not a function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related