Trying to upload a csv file. The file has only the required columns: projectId, registryOfOrigin, program, projectName, projectLink, projectDeveloper, sector, projectType, coveredByNDC, ndcInformation, projectStatus, projectStatusDate, unitMetric, methodology
Error
at Database. (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\dialects\sqlite\query.js:179:27)
at C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\dialects\sqlite\query.js:177:50
at new Promise ()
at Query.run (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\dialects\sqlite\query.js:177:12)
at C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\sequelize.js:313:28
at runMicrotasks ()
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at async SQLiteQueryInterface.bulkInsert (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\dialects\abstract\query-interface.js:335:21)
at async recursiveBulkCreate (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\model.js:1648:25)
at async Function.bulkCreate (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\model.js:1737:12)
at async Converter. (file:///C:/Chia/climate-warehouse/src/utils/csv-utils.js:116:11) {
name: 'SequelizeDatabaseError',
parent: [Error: SQLITE_ERROR: near ";": syntax error] {
errno: 1,
code: 'SQLITE_ERROR',
sql: 'INSERT INTO staging
Trying to upload a csv file. The file has only the required columns: projectId, registryOfOrigin, program, projectName, projectLink, projectDeveloper, sector, projectType, coveredByNDC, ndcInformation, projectStatus, projectStatusDate, unitMetric, methodology
Error at Database. (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\dialects\sqlite\query.js:179:27)
at C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\dialects\sqlite\query.js:177:50
at new Promise ()
at Query.run (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\dialects\sqlite\query.js:177:12)
at C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\sequelize.js:313:28
at runMicrotasks ()
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at async SQLiteQueryInterface.bulkInsert (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\dialects\abstract\query-interface.js:335:21)
at async recursiveBulkCreate (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\model.js:1648:25)
at async Function.bulkCreate (C:\Chia\climate-warehouse\node_modules\sequelize\dist\lib\model.js:1737:12)
at async Converter. (file:///C:/Chia/climate-warehouse/src/utils/csv-utils.js:116:11) {
name: 'SequelizeDatabaseError',
parent: [Error: SQLITE_ERROR: near ";": syntax error] {
errno: 1,
code: 'SQLITE_ERROR',
sql: 'INSERT INTO
staging