Page is returning "undefined"

[itslevir]

Hi, I asked this over on Stack Overflow, it got removed by the mods to the surprise of absolutely nobody.
I'm working with vanilla express & pug. My code looks like this:

app.get('/w/', async (req: any, res: any) => {
    const uvid = req.query.s;
    const [results] = await sql.query(`SELECT * FROM vdata WHERE uvid='${uvid}'`);
    res.render('watch', { vurl: results[0].vurl, vtitle: results[0].vtitle, vauthor: results[0].vauthor });
});

If I go this page, it shows "undefined", and the browser console returns an HTTP 500. I see no errors in the console where express is running, and I have also tried removing all server data sent, so it looks just like res.render('watch');. This doesn't work either. All other pages work just fine. What is my issue? My SQL is fine, if I console.log(results) it returns exactly as expected. The URL looks like http://localhost:3000/w/?s=example.

Thanks in advance for any help

[dougwilson]

Hello, and sorry you are having trouble. Unfortunately nothing sticks out to me as wrong in the code you provided and there are too many missing pieces to reproduce the issue so we can help debug. If you can provide a complete reproduction and instructions for how to see the unexpected result, we can help debug to see what is going on.

[micalevisk]

@lerichardson removing all dynamic parts like this:

app.get('/w/', async (req: any, res: any) => {
    res.render('watch', { vurl: "X", vtitle: "X", vauthor: "X" });
});

do work as expected? (change those "X" to the value that you expected for each key). If doesn't, what it shows?