Skip to content

Instantly share code, notes, and snippets.

@stoneboyindc
Created August 21, 2020 16:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stoneboyindc/77b1bcfaf0dc5b5cf77a68921dcfc20c to your computer and use it in GitHub Desktop.
Save stoneboyindc/77b1bcfaf0dc5b5cf77a68921dcfc20c to your computer and use it in GitHub Desktop.
C:\code\thinkful\tc\beccahudson\rebecca-virtual-desk-server>npm run migrate
> virtual-desk-server@1.0.0 migrate C:\code\thinkful\tc\beccahudson\rebecca-virtual-desk-server
> postgrator --config postgrator-config.js
Package pg version 8.x.x not tested
Please raise issue to support pg > 7.x.x
[12:25:18 PM] table schemaversion does not exist - creating it.
[12:25:18 PM] version of database is: 0
[12:25:18 PM] migrating up to 3
[12:25:18 PM] running 001.do.create_help_tickets.sql
[12:25:19 PM] running 002.do.create_users.sql
[12:25:19 PM] running 003.do.alter_ticket_state.sql
Error: syntax error at or near "NOT"
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! virtual-desk-server@1.0.0 migrate: `postgrator --config postgrator-config.js`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the virtual-desk-server@1.0.0 migrate script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\changc16\AppData\Roaming\npm-cache\_logs\2020-08-21T16_25_19_316Z-debug.log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment