SequelizeDatabaseError because of array?

Hello 👋 So I am trying to make a database This code works just fine

const Sequelize = require("sequelize");
const sequelize = require("../utils/database");

const Guild = sequelize.define("guild", {
  id: {
    type: Sequelize.STRING,
    primaryKey: true,
  },
  applicantChannelId: {
    type: Sequelize.STRING,
    allowNull: true,
  },
});

module.exports = Guild;

const Sequelize = require("sequelize");
const sequelize = require("../utils/database");

const Guild = sequelize.define("guild", {
  id: {
    type: Sequelize.STRING,
    primaryKey: true,
  },
  applicantChannelId: {
    type: Sequelize.STRING,
    allowNull: true,
  },
});

module.exports = Guild;

But once I try to do this but with an array I get an arror

const Sequelize = require("sequelize");
const sequelize = require("../utils/database");

const Guild = sequelize.define("guild", {
  id: {
    type: Sequelize.STRING,
    primaryKey: true,
  },
  applicantChannelId: {
    type: Sequelize.STRING,
    allowNull: true,
  },
  applicationQuestions: {
    type: Sequelize.ARRAY(Sequelize.STRING),
    allowNull: true,
  },
});

module.exports = Guild;

const Sequelize = require("sequelize");
const sequelize = require("../utils/database");

const Guild = sequelize.define("guild", {
  id: {
    type: Sequelize.STRING,
    primaryKey: true,
  },
  applicantChannelId: {
    type: Sequelize.STRING,
    allowNull: true,
  },
  applicationQuestions: {
    type: Sequelize.ARRAY(Sequelize.STRING),
    allowNull: true,
  },
});

module.exports = Guild;

ERROR:

  name: 'SequelizeDatabaseError',
  parent: [Error: SQLITE_ERROR: near "[]": syntax error] {
    errno: 1,
    code: 'SQLITE_ERROR',
    sql: 'ALTER TABLE `guilds` ADD `applicationQuestions` VARCHAR(255)[];'
  },
  original: [Error: SQLITE_ERROR: near "[]": syntax error] {
    errno: 1,
    code: 'SQLITE_ERROR',
    sql: 'ALTER TABLE `guilds` ADD `applicationQuestions` VARCHAR(255)[];'
  },
  sql: 'ALTER TABLE `guilds` ADD `applicationQuestions` VARCHAR(255)[];',
  parameters: {}
}

  name: 'SequelizeDatabaseError',
  parent: [Error: SQLITE_ERROR: near "[]": syntax error] {
    errno: 1,
    code: 'SQLITE_ERROR',
    sql: 'ALTER TABLE `guilds` ADD `applicationQuestions` VARCHAR(255)[];'
  },
  original: [Error: SQLITE_ERROR: near "[]": syntax error] {
    errno: 1,
    code: 'SQLITE_ERROR',
    sql: 'ALTER TABLE `guilds` ADD `applicationQuestions` VARCHAR(255)[];'
  },
  sql: 'ALTER TABLE `guilds` ADD `applicationQuestions` VARCHAR(255)[];',
  parameters: {}
}

I'd appreciate some help ;D

4 Replies

d.js toolkit•2y ago

• What's your exact discord.js npm list discord.js and node node -v version? • Post the full error stack trace, not just the top part! • Show your code! • Explain what exactly your issue is. • Not a discord.js issue? Check out #useful-servers.

PandaOP•2y ago

[email protected] & node v18.12.1 bump?

treble/luna•2y ago

Not djs related, #other-js-ts

PandaOP•2y ago

Ah my bad, ill repost there

Gaming

Programming

SequelizeDatabaseError because of array?

Did you find this page helpful?