Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

error: relation "heads" does not exist #1

Open
eduardg7 opened this issue May 2, 2019 · 0 comments
Open

error: relation "heads" does not exist #1

eduardg7 opened this issue May 2, 2019 · 0 comments

Comments

@eduardg7
Copy link

eduardg7 commented May 2, 2019

I installed the postgreSql database, I did run npm install inside every subfolder and I wanted to run the index.js from the flashscore folder.

Here is the console. I have to say it's my first time working with postgreSql so I am not sure if it's an error caused by my configuration.
original: { error: relation "heads" does not exist at Connection.parseE (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/pg/lib/connection.js:601:11) at Connection.parseMessage (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/pg/lib/connection.js:398:19) at Socket.<anonymous> (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/pg/lib/connection.js:120:22) at Socket.emit (events.js:189:13) at addChunk (_stream_readable.js:284:12) at readableAddChunk (_stream_readable.js:265:11) at Socket.Readable.push (_stream_readable.js:220:10) at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17) name: 'error', length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '303', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '1180', routine: 'parserOpenTable', sql: 'SELECT "id", "flashscoreId", "stateFlashscore", "atpWorldTourId", "stateAtpWorldTour", "weatherId", "stateWeather", "bookmakerId", "stateBookmaker", "homeId", "stateHome", "awayId", "stateAway", "csvDataId", "stateCsvData", "injuriesId", "stateInjuries", "option", "log", "createdAt", "updatedAt" FROM "heads" AS "head" WHERE "head"."flashscoreId" = \'E5joJ3PS\' LIMIT 1;' }, sql: 'SELECT "id", "flashscoreId", "stateFlashscore", "atpWorldTourId", "stateAtpWorldTour", "weatherId", "stateWeather", "bookmakerId", "stateBookmaker", "homeId", "stateHome", "awayId", "stateAway", "csvDataId", "stateCsvData", "injuriesId", "stateInjuries", "option", "log", "createdAt", "updatedAt" FROM "heads" AS "head" WHERE "head"."flashscoreId" = \'E5joJ3PS\' LIMIT 1;' } ERROR tour.js { SequelizeDatabaseError: relation "heads" does not exist at Query.formatError (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/sequelize/lib/dialects/postgres/query.js:363:16) at query.catch.err (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/sequelize/lib/dialects/postgres/query.js:86:18) at tryCatcher (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/bluebird/js/release/promise.js:512:31) at Promise._settlePromise (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/bluebird/js/release/promise.js:569:18) at Promise._settlePromise0 (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/bluebird/js/release/promise.js:614:10) at Promise._settlePromises (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/bluebird/js/release/promise.js:690:18) at _drainQueueStep (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/bluebird/js/release/async.js:138:12) at _drainQueue (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/bluebird/js/release/async.js:131:9) at Async._drainQueues (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/bluebird/js/release/async.js:147:5) at Immediate.Async.drainQueues [as _onImmediate] (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/bluebird/js/release/async.js:17:14) at runCallback (timers.js:705:18) at tryOnImmediate (timers.js:676:5) at processImmediate (timers.js:658:5) name: 'SequelizeDatabaseError', parent: { error: relation "heads" does not exist at Connection.parseE (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/pg/lib/connection.js:601:11) at Connection.parseMessage (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/pg/lib/connection.js:398:19) at Socket.<anonymous> (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/pg/lib/connection.js:120:22) at Socket.emit (events.js:189:13) at addChunk (_stream_readable.js:284:12) at readableAddChunk (_stream_readable.js:265:11) at Socket.Readable.push (_stream_readable.js:220:10) at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17) name: 'error', length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '303', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '1180', routine: 'parserOpenTable', sql: 'SELECT "id", "flashscoreId", "stateFlashscore", "atpWorldTourId", "stateAtpWorldTour", "weatherId", "stateWeather", "bookmakerId", "stateBookmaker", "homeId", "stateHome", "awayId", "stateAway", "csvDataId", "stateCsvData", "injuriesId", "stateInjuries", "option", "log", "createdAt", "updatedAt" FROM "heads" AS "head" WHERE "head"."flashscoreId" = \'8M0fUmFt\' LIMIT 1;' }, original: { error: relation "heads" does not exist at Connection.parseE (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/pg/lib/connection.js:601:11) at Connection.parseMessage (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/pg/lib/connection.js:398:19) at Socket.<anonymous> (/Users/eduardgridan/Desktop/tennis-dataset/app/flashscore/node_modules/pg/lib/connection.js:120:22) at Socket.emit (events.js:189:13) at addChunk (_stream_readable.js:284:12) at readableAddChunk (_stream_readable.js:265:11) at Socket.Readable.push (_stream_readable.js:220:10) at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17) name: 'error', length: 105, severity: 'ERROR', code: '42P01', detail: undefined, hint: undefined, position: '303', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '1180', routine: 'parserOpenTable', sql: 'SELECT "id", "flashscoreId", "stateFlashscore", "atpWorldTourId", "stateAtpWorldTour", "weatherId", "stateWeather", "bookmakerId", "stateBookmaker", "homeId", "stateHome", "awayId", "stateAway", "csvDataId", "stateCsvData", "injuriesId", "stateInjuries", "option", "log", "createdAt", "updatedAt" FROM "heads" AS "head" WHERE "head"."flashscoreId" = \'8M0fUmFt\' LIMIT 1;' }, sql: 'SELECT "id", "flashscoreId", "stateFlashscore", "atpWorldTourId", "stateAtpWorldTour", "weatherId", "stateWeather", "bookmakerId", "stateBookmaker", "homeId", "stateHome", "awayId", "stateAway", "csvDataId", "stateCsvData", "injuriesId", "stateInjuries", "option", "log", "createdAt", "updatedAt" FROM "heads" AS "head" WHERE "head"."flashscoreId" = \'8M0fUmFt\' LIMIT 1;' }

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant