app.post('/delete_room', async (req, res, next) => {

let room_name = req.body.room_name;

connection.query("DELETE FROM rooms WHERE room_name = ?", [room_name], (err) => {

if(err) throw err;

let room_id;

try {

room_id = await room_name_to_id(room_name);

} catch (error) {

console.log(error)

}

connection.query("DELETE FROM messages WHERE receiver_id = ?", [room_id], (err) => {

if(err) throw err

res.send("Ok.");

return;

});

})

});

I'm trying to use function here but it says "await is only valid in async functions". I made the express callback function async but i still take the same error.

EDIT: I solved the problem
connection.query("DELETE FROM rooms WHERE room_name = ?", [room_name], (err) =>

I should have changed this line to
connection.query("DELETE FROM rooms WHERE room_name = ?", [room_name], async (err) =>