TypeError: Cannot read properties of undefined (reading 'constructor'), How can I avoid getting this error?

[simanye-pav]

please help.

I'm making use of the node-mysql2 library

I have SQL queries and whenever a query is run and some variables are null in that query it triggers this error. This is usually when the session variables are null. AgentID=Null or DealerID=Null.

The error originates from the mysql2 connection.js file

C:\inetpub\wwwroot\pavstockallocatebot\node_modules\mysql2\lib\connection.js:538
    if (sql.constructor === Commands.Query) {
            ^
    TypeError: Cannot read properties of undefined (reading 'constructor')

Where it is triggered:

 query(sql, values, cb) {
    let cmdQuery;
    if (sql.constructor === Commands.Query) {
      cmdQuery = sql;
    } else {
      cmdQuery = Connection.createQuery(sql, values, cb, this.config);
    }
    this._resolveNamedPlaceholders(cmdQuery);
    const rawSql = this.format(cmdQuery.sql, cmdQuery.values !== undefined ? cmdQuery.values : []);
    cmdQuery.sql = rawSql;
    return this.addCommand(cmdQuery);
  }

It freezes my whole app/telegram bot. and doesn't allow me to restart the app.
How can I add an error handler that will check if the variables are undefined or null to avoid ever getting this error. When I do get this error to handle it appropriately.