We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

Migration SQL error

  • Phalcon 3.2.2
  • Phalcon Devtools 3.2.3
  • PostgreSQL 9.5
  • Ubuntu 16.04

Hello!

I've created a migration using devtools and now i'm trying to run it on a clean database.

I'm using a cli interface:

phalcon migration --action=run

After that I have an exception output:

1507010432.9594: CREATE TABLE "printtime"."rbac" ( DEFAULT true"id" SERIAL NOT NULL, "code" CHARACTER VARYING(20) NOT NULL, "description" CHARACTER VARYING(255) NOT NULL, "is_role" BOOLEAN NOT NULL, "children" CHARACTER VARYING(1), CONSTRAINT "rbac_pkey" PRIMARY ("id") );ERROR: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "DEFAULT" LINE 2: DEFAULT true"id" SERIAL NOT NULL,

You see, there's a wrong sql command DEFAULT true"id" SERIAL NOT NULL, there's no backspace and presents an unneeded command DEFAULT true.

Here's the morph part of my migration: https://pastebin.com/4c9enRQw

What's going wrong?

@Urvin Could you please open a new issue at GitHub repo?

edited Apr '18

It was fixed in 3.3.x phalcon branch (https://github.com/phalcon/cphalcon/pull/13165)