Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

252
Views
sqlMessage: "Unknown column 'c.created' in 'field list'"

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.id\n' +
    '    FROM comments c\n' +
    '    JOIN users u\n' +
    '    on u.id=fk_authorid\n' +
    "    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!

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!