For the past 10 days, I've been grappling with this issue. Despite trying everything I could find on Google, I still haven't found a suitable solution.
After initiating "npm start" on the server at night, I woke up to an error in the morning.
throw er; // Unhandled 'error' event
^
Error: Packets out of order. Got: 0 Expected: 244
at Parser.write (D:\people_hub\backend\node_modules\mysql\lib\protocol\Parser.js:42:19)
at Protocol.write (D:\people_hub\backend\node_modules\mysql\lib\protocol\Protocol.js:39:16)
...
My SQL connection file:
const Sequelize = require('sequelize')
const dotenv = require('dotenv');
dotenv.config();
...
My app.js file:
const express = require('express');
var cookieParser = require("cookie-parser");
const cors = require('cors');
...
My Final Connection File:
var app = require("../server");
var debug = require("debug")
const db = require("../database/db");
...
I modified the MySQL database with:
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
Despite exhausting all options from Google, I have hit a dead end. What should be my next step?