Im getting this error which I’m not completely sure how to solve.
CommentModel.getCommentsForPost = (postId) => {
let baseSQL = `SELECT u.username, c.comment, c.created, c.id
FROM comments c
JOIN users u
on u.id=fk_authorid
WHERE c.fk_postid=?
ORDER BY c.created DESC`;
return db.query(baseSQL, [postId])
.then(([results, fields]) => {
return Promise.resolve(results);
}).catch(err => Promise.reject(err));
};
Error:
code: 'ER_BAD_FIELD_ERROR',
errno: 1054,
sql: 'SELECT u.username, c.comment, c.created, c.idn' +
' FROM comments cn' +
' JOIN users un' +
' on u.id=fk_authoridn' +
" WHERE c.fk_postid='''1'''n" +
' ORDER BY c.created DESC',
sqlState: '42S22',
sqlMessage: "Unknown column 'c.created' in 'field list'"
}
Any help would be appreciated!