SyntaxError: Unexpected token 'catch' in C:\xampp\htdocs\mysite.local\views\index.ejs while compiling ejs
If the above error is not helpful, you may want to try EJS-Lint:
https://github.com/RyanZim/EJS-Lint
Or, if you meant to create an async function, pass `async: true` as an option.
at new Function (<anonymous>)
at Template.compile (C:\xampp\htdocs\mysite.local\node_modules\ejs\lib \ejs.js:661:12)
at Object.compile (C:\xampp\htdocs\mysite.local\node_modules\ejs\lib \ejs.js:396:16)
at handleCache (C:\xampp\htdocs\mysite.local\node_modules\ejs\lib \ejs.js:233:18)
at tryHandleCache (C:\xampp\htdocs\mysite.local\node_modules\ejs\lib \ejs.js:272:16)
at View.exports.renderFile [as engine] (C:\xampp\htdocs\mysite.local\node_modules\ejs\lib \ejs.js:489:10)
at View.render (C:\xampp\htdocs\mysite.local\node_modules\express \lib\view.js:135:8)
at tryRender (C:\xampp\htdocs\mysite.local\node_modules\express \lib\application.js:640:10)
at Function.render (C:\xampp\htdocs\mysite.local\node_modules\express \lib\application.js:592:3)
at ServerResponse.render (C:\xampp\htdocs\mysite.local\node_modules\express \lib\response.js:1012:7)
app.get('/smart', function(req, res) {
var order;
var side;
var prmin;
var prmax;
if(!order){order='name';}
if(!side){side='ASC';}
if(order=='price'){
side=req.cookies.sideprice;
}else if(order=='popularity'){
side=req.cookies.sidepopularity;
}else if(order=='tsale'){
side=req.cookies.side.sidesale;
}
var query;
var smartphopneList=[];
// Connect to MySQL database.
var connection = getMySQLConnection();
// Do the query to get data.
connection.connect();
quer='SELECT `id`,`prod`,`name`,`description`,`photo`,`price`,`popularity`,`sale`,(`price` -`price` / 100 * `sale`) AS `tsale` FROM `smartphone` ORDER BY `tsale` ASC';
connection.query(quer, function(err, rowes, fields) {
// Loop check on each row
prmin=rowes[0].tsale;
prmax=rowes[(rowes.length-1)].tsale;
// Render index.pug page using array
});
if(req.cookies.prmin){
prmin=req.cookies.prmin;
}
if(req.cookies.prmax){
prmax=req.cookies.prmax;
}
if(!prmin){prmin=7000;}
if(!prmax){prmax=20000;}
var otherwhere='';
if(req.cookies.vprodaj=='checked'){
otherwhere=otherwhere+' AND WHERE count>0 ';
}
if(req.cookies.soskidkoi=='checked'){
otherwhere=otherwhere+' AND WHERE (`price` -`price` / 100 * `sale`) >0 ';
}
if(req.cookies.dbesplat=='checked'){
otherwhere=otherwhere+' AND WHERE `dbesplat`=1 ';
}
if(req.cookies.promokodi=='checked'){
otherwhere=otherwhere+' AND WHERE `promokodi`=1 ';
}
if(req.cookies.presents=='checked'){
otherwhere=otherwhere+' AND WHERE `presents`=1 ';
}
if(req.cookies.newtov=='checked' ){
otherwhere=otherwhere+' AND WHERE `newtov`=1 ';
}
if(req.cookies.uctov=='checked'){
otherwhere=otherwhere+' AND WHERE `uctov`=1 ';
}
if(req.cookies.garantprod=='checked'){
otherwhere=otherwhere+' AND WHERE `soskidkoi`>0 ';
}
if(req.cookies.oswin=='checked'){
otherwhere=otherwhere+' AND WHERE `oswin`=1 ';
}
if(req.cookies.osios=='checked'){
otherwhere=otherwhere+' AND WHERE `osios`=1 ';
}
if(req.cookies.osandrod=='checked'){
otherwhere=otherwhere+' AND WHERE `checked`=1 ';
}
if(!otherwhere){
var where='WHERE (`price` -`price` / 100 * `sale`) >= '+prmin+' AND (`price` -`price` / 100 * `sale`) <= '+prmax;
}else{
var where='WHERE (`price` -`price` / 100 * `sale`) >= '+prmin+' AND (`price` -`price` / 100 * `sale`) <= '+prmax +otherwhere;
}
query='SELECT `id`,`prod`,`name`,`description`,`photo`,`price`,`popularity`,`sale`,`dbesplat`,`promokodi`,`presents`,`newtov`,`garantprod`,(`price` -`price` / 100 * `sale`) AS `tsale` FROM `smartphone` '+where+' ORDER BY '+order +' '+side;
connection.query(query, function(err, rows, fields) {
if (err) {
res.status(500).json({"status_code": 500,"status_message": "internal server error"});
console.log(err);
} else {
// Loop check on each row
var rowlenght=rows.length+1;
for (var i = 0; i < rows.length; i++) {
// Create an object to save current row's data
var smartphopne = {
'id':rows[i].id,
'prod':rows[i].prod,
'name':rows[i].name,
'photo':rows[i].photo,
'description':rows[i].description,
'price':rows[i].price,
'sale':rows[i].sale,
'len':rowlenght,
'tsale':rows[i].tsale,
'prmin':prmin,
'prmax':prmax,
'cprmin':req.cookies.prmin,
'cprmax':req.cookies.prmax,
'vprodaj':req.cookies.vprodaj,
'soskidkoi':req.cookies.soskidkoi,
'dbesplat':req.cookies.dbesplat,
'promokodi':req.cookies.promokodi,
'presents':req.cookies.presents,
'newtov':req.cookies.newtov,
'uctov':req.cookies.uctov,
'garantprod':req.cookies.garantprod,
'oswin':req.cookies.oswin,
'osios':req.cookies.osios,
'osandrod':req.cookies.osandrod,
};
// Add object into array
smartphopneList.push(smartphopne);
}
// Render index.pug page using array
res.render('index', {"smartphopneList": smartphopneList});
}
});
// Close the MySQL connection
connection.end();
});
