I m getting this TypeError: Cannot read properties of undefined (reading ‘$variable’)
I have written a snippet of code to update the prices of coins in my database, but it gives this error after working for a certain period of time.
Err:
^
TypeError: Cannot read properties of undefined (reading 'MIRUSDT')
at c:xamppxshtdocs1patron.js:58:36
at Request._callback (c:xamppxshtdocs1node_modulesnode-binance-apinode-binance-api.js:3263:37)
My code:
const priceup = async () => {
connection.query("SELECT * FROM pricetracker WHERE price_coinstatus='0'", function (err, rows, fields) {
if (err){priceup()};
rows.forEach(function(row) {
let symbol = row.price_coin;
let id = row.price_coinid;
let entryprice = row.price_coinentryprice;
var day=dateFormat (new Date (), "%Y-%m-%d %H:%M:%S", true);
const tt = binance.prices(symbol, (error, ticker) => {
if (error){priceup()};
var hede = ("price", ticker);
var hededegisken = hede[symbol];
if(typeof hededegisken === 'undefined' || hededegisken === null) {
priceup()
}
var percent = (hededegisken - entryprice) * 100 / hede[symbol];
var percent = Number(percent).toFixed(4)
if (percent > 2){
var percent = '<span class="bg-success p-1">+<i class="mdi mdi-arrow-up-bold"></i>'+percent+'%</span>';
}else if (percent >= 0){
var percent = '<span class="bg-warning p-1">+<i class="mdi mdi-arrow-up-bold"></i>'+percent+'%</span>';
}else if (percent >= -2){
var percent = '<span class="bg-danger p-1"><i class="mdi mdi-arrow-down-bold"></i>'+percent+'%</span>';
}else if (percent >= -4){
var percent = '<span class="bg-danger p-1"><img src="../images/patience.png" height="18" title="Warning!"> <i class="mdi mdi-arrow-down-bold"></i>'+percent+'%</span>';
}else if (percent >= -6){
var percent = '<span class="bg-danger p-1"><img src="../images/patience.png" height="18" title="Warning!"><i class="mdi mdi-arrow-down-bold"></i>'+percent+'%</span>';
}else if (percent >= -8){
var percent = '<span class="bg-danger p-1"><img src="../images/patience.png" height="18" title="Warning!"><i class="mdi mdi-arrow-down-bold"></i>'+percent+'%</span>';
}else if (percent >= -10){
var percent = '<span class="bg-danger p-1"><img src="../images/patience.png" height="18" title="Warning!"><i class="mdi mdi-arrow-down-bold"></i>'+percent+'%</span>';
}else{
var percent = '<span class="bg-danger p-1"><img src="../images/patience.png" height="18" title="Warning!"><i class="mdi mdi-arrow-down-bold"></i>'+percent+'%</span>';
}
// console.log(percent);
connection.connect(function(err){
var sql = "UPDATE pricetracker SET price_coin='"+symbol+"',price_lastprice='"+hededegisken+"',price_percent='"+percent+"',price_uptime='"+day+"' WHERE price_coinid='"+id+"'";
connection.query(sql,function(err,result){
console.log(symbol+' Update! '+day)
});
});
if (err){
priceup()
}
});
});
});
};
How can I solve this?