search

canove / whaticket-community

A very simple Ticket System based on WhatsApp messages, that allow multi-users in same WhatsApp account.
MIT License
1.57k stars 800 forks source link

Migrate Error #471

Closed mdestafadilah closed 1 year ago

mdestafadilah commented 1 year ago 
siapdok@siapdok-srv:~$ cd /www/wwwroot/whaticket/backend
siapdok@siapdok-srvsudo npx sequelize db:migrate
sudo: unable to resolve host siapdok-srv.localdomain: Name or service not known
[sudo] password for siapdok: 
npm WARN config init.module Use `--init-module` instead.

Sequelize CLI [Node: 16.16.0, CLI: 5.5.1, ORM: 5.22.5]

Loaded configuration file "dist/config/database.js".
== 20200717145643-create-tickets: migrating =======

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, `updatedAt` DATETIME(6) NOT NULL, PRIMARY KEY (`id`), FOREIGN KEY ' at line 1

Spesification: MySQL 5.5.62 or PostgreSQL 14.2

stale[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.