NodeJs. Problem with module.export; it is not a function error

Question

I have written this piece of code:

function newExercise(data){
    pool.query('INSERT INTO Exercises VALUES(?, ?)', [data, data], function(error, results, field){
        if(error) console.log(error);
    })
}

module.exports = {
    newExercise: newExercise,
}

But when I call the function from here:

Promise.all([exname, exdesc])
    .then( values => {
        router.get('/', function(req, res, next){
            var socket = req.app.get('socket');
            io = req.app.get('socketio');
            io.sockets.on('connection', function(socket){
                socket.on('message', function(message){
                    console.log("Ricevuto");
                    database.newExcercise(message);
                })
            })
            res.render('exercises', {title: 'Exercises', ex: values[0]});
        })
    })
    .catch(error => console.error(error));

I get "TypeError: database.newExcercise is not a function", but I don't understand why

Caleb H. · Accepted Answer · 2019-07-09 19:57:01Z

2

In the above code snippet, you defined the function as: newExercise, and in the second snippet, you're calling it as newExcercise.

It's a simple typo.

answered Jul 9, 2019 at 19:57

Caleb H.

1,7151 gold badge12 silver badges32 bronze badges

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

Comments

Ruan Kruger · Accepted Answer · 2021-03-04 15:44:41Z

2

For me the solution was removing a circular reference.

answered Mar 4, 2021 at 15:44

Ruan Kruger

828 bronze badges

Comments

João Santana · Accepted Answer · 2019-07-09 19:56:52Z

1

Try the following: module.exports.newExercise = newExercise;

answered Jul 9, 2019 at 19:56

João Santana

131 silver badge5 bronze badges

Comments

Marcello B. · Accepted Answer · 2021-04-06 04:49:13Z

0

file name NewExercise.js

module.exports = function newExercise(data){
   pool.query('INSERT INTO Exercises VALUES(?, ?)', [data, data], function(error, results, field){
      if(error) console.log(error);
   })
}

in another file where you are calling this function you just var newExercise= require('./NewExercise.js'); and you just call it newExercise(message)

edited Apr 6, 2021 at 4:49

Marcello B.

4,47011 gold badges48 silver badges72 bronze badges

answered Jul 9, 2019 at 20:07

Sanaullah

3746 silver badges11 bronze badges

Collectives™ on Stack Overflow

NodeJs. Problem with module.export; it is not a function error

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related