Node.JS MySQL query not executing with no error

Question

Despite having correct server credentials this segment of code being called from a function never reaches the alert at the bottom of the snippet nor does it provide any error message despite the inclusion of a throw err statement. It reaches the alert saying "PING" but never even executes the "PONG" alert. What is wrong here? In MySQL Workbench the credentials seem to be correct and I've inserted data into columns using that environment just fine.

    alert("PING");
    //Begin SQL query
    var mysql      = require('mysql');
    var connection = mysql.createConnection({
      host     : '127.0.0.1',
      user     : 'root',
      password : 'password',
      port: 3306,
      database : 'db'
    });
    connection.connect();
    connection.query('SELECT * FROM test', function(err, rows, fields) 
    {
      if (err) throw err;
      console.log(rows[0]);
    });
    connection.end();
    alert("PONG");

There's no alert() function in node? Are you running this in a browser? If so, you'll get an error message for using require. Node JavaScript and browser JavaScript are not the same. Requiring modules like that and accessing a DB directly is only possible with node. — user5734311
– user5734311, Commented Jun 7, 2021 at 22:26
How long did wait for an output before killing the process? it maybe that the mysql server for some reason is not send data back and your nodejs process just wait for it — Molkan
– Molkan, Commented Jun 7, 2021 at 22:27
@ChrisG Yes there is the first alert executes fine. The second alert never displays and there is no error provided in console. — oilrefiner946
– oilrefiner946, Commented Jun 7, 2021 at 22:28
The code works fine for me if I remove the alert statements and run this from the command line using node test.js. If you see an alert displayed, you're running this as <script> in a browser. However mysql is a node module, i.e. backend. — user5734311
– user5734311, Commented Jun 7, 2021 at 22:30
how are you calling alert() and require(mysql)? Could you tell us a little more on how are you running this script? — Ignacio Acuña Frías
– Ignacio Acuña Frías, Commented Jun 7, 2021 at 22:30

Matt · Accepted Answer · 2021-06-07 22:28:48Z

1

Pass your .query() section as an argument of the .connect() function like this:

connection.connect(function(err) {
  if err throw err;
  connection.query('SELECT * FROM test', function(err, rows, fields) {
    if (err) throw err;
    console.log(result);
    });
})

That should work better.

answered Jun 7, 2021 at 22:28

Matt

112 bronze badges

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

2 Comments

user5734311 Over a year ago

Removing the alert commands makes OP's code run fine.

oilrefiner946 Over a year ago

@ChrisG I just removed all of the alerts and it still doesn't work and it doesn't throw any errors. I am working in a React environment and I'm confused as to what is wrong...

Collectives™ on Stack Overflow

Node.JS MySQL query not executing with no error

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related