I have this error when I upload my GitHub proyect to Vercel:
Error: Please install mysql2 package manually
at ConnectionManager._loadDialectModule (/var/task/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:55:15)
at new ConnectionManager (/var/task/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:30:21)
at new MysqlDialect (/var/task/node_modules/sequelize/lib/dialects/mysql/index.js:13:30)
at new Sequelize (/var/task/node_modules/sequelize/lib/sequelize.js:194:20)
at Object. (/var/task/database/models/index.js:16:15)
at Module._compile (node:internal/modules/cjs/loader:1356:14)
at Module._extensions..js (node:internal/modules/cjs/loader:1414:10)
at Module.load (node:internal/modules/cjs/loader:1197:32)
at Module._load (node:internal/modules/cjs/loader:1013:12)
at exports.b (/var/task/___vc/__launcher/chunk-5UAC7W5H.js:1:1142)
INIT_REPORT Init Duration: 790.86 ms Phase: invoke Status: error Error Type: Runtime.ExitError
Error: Runtime exited with error: exit status 1
Runtime.ExitError
This is my index.js
// -------------------- REQUIREMENTS --------------------
const express = require("express")
const mainRouter = require("./src/routers/mainRouter")
const methodOverride = require("method-override");
const session = require ('express-session');
// ---------- MIDDLEWARES ----------
const error404Middleware = require("./src/middlewares/error404Middleware")
const sessionExists = require("./src/middlewares/sessionExists")
// -------------------- APP --------------------
const app = express()
// -------------------- CORS --------------------
const cors = require("cors");
app.use(
cors(
(corsOptions = {
origin: "*",
})
)
);
// -------------------- SETTINGS --------------------
app.set("view engine", "ejs")
app.set("views", __dirname + "/src/views")
// -------------------- USES --------------------
app.use(express.static(__dirname + "/public"))
app.use(methodOverride("_method"))
app.use(
session({
secret:"sessionGeneral",
resave:false,
saveUninitialized:false,
})
)
app.use(express.urlencoded({extended: false}))
app.use(sessionExists)
// -------------------- ROUTERS --------------------
app.use(mainRouter)
app.use(error404Middleware)
// -------------------- SERVER --------------------
const PORT = process.env.PORT || 3024
app.listen(PORT, () => console.log(`running server on port ${PORT}`))
I tried to reinstall mysql2 and exempt mysql2 folder from node_modules on .gitignore file but still I have the same error.
I expect to remove the error to upload this proyect to Vercel.