disgo icon indicating copy to clipboard operation
disgo copied to clipboard

Table creation fails on Postgres

Open BonkaBonka opened this issue 10 years ago • 1 comments

2014-08-27 14:54:00 GMT LOG:  connection received: host=10.148.42.215 port=44910
2014-08-27 14:54:00 GMT LOG:  connection authorized: user=disgouser database=disgo
2014-08-27 14:54:00 GMT ERROR:  syntax error at or near "(" at character 59
2014-08-27 14:54:00 GMT STATEMENT:
        CREATE TABLE IF NOT EXISTS comments (
          Id bigint(20) NOT NULL AUTO_INCREMENT,
          Created bigint(20) DEFAULT NULL,
          Email varchar(255) DEFAULT NULL,
          Name varchar(255) DEFAULT NULL,
          Body text,
          Url varchar(255) DEFAULT NULL,
          ClientIp varchar(255) DEFAULT NULL,
          Approved tinyint(1) DEFAULT NULL,
          PRIMARY KEY (Id)
        ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

BonkaBonka avatar Aug 27 '14 15:08 BonkaBonka

Thanks for reporting! It's time to move to migrations that automatically handle MySQL and Postgres. I created issue #8 to tackle that.

pascalj avatar Aug 28 '14 09:08 pascalj