errno 139

[till]

Running:

./symfony doctrine:build --all

Error:

 SQLSTATE[HY000]: General error: 1005 Can't create table './db/a_page.frm' (errno: 139). Failing Query: "CREATE TABLE a_page (id INT AUTO_INCREMENT, slug TEXT, template VARCHAR(100), view_is_secure TINYINT(1), archived TINYINT(1), admin TINYINT(1) DEFAULT '0', author_id INT, deleter_id INT, engine VARCHAR(255), created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, lft INT, rgt INT, level SMALLINT, INDEX slugindex_idx (slug(1000)), INDEX engineindex_idx (engine), INDEX author_id_idx (author_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = INNODB". Failing Query: CREATE TABLE a_page (id INT AUTO_INCREMENT, slug TEXT, template VARCHAR(100), view_is_secure TINYINT(1), archived TINYINT(1), admin TINYINT(1) DEFAULT '0', author_id INT, deleter_id INT, engine VARCHAR(255), created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, lft INT, rgt INT, level SMALLINT, INDEX slugindex_idx (slug(1000)), INDEX engineindex_idx (engine), INDEX author_id_idx (author_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = INNODB

MySQL: mysql-server-4.1.22

... looks like errno 139 is a byte character limit, but I don't see where I hit that.

[johnnyoffline]

Is this a 1.3 vs trunk issue?

[boutell]

We increased the length of the slug field to accommodate long URLs, and of course URLs must be quick to access, thus INDEX slugindex_idx (slug(1000)) and a later ALTER to make it unique as well. MySQL 5 has no trouble with this. Possibly it's a MySQL 4 limitation. till, can you try this with MySQL 5 or better?

[rickybanister]

Tom, is this an ongoing issue? Can you update this ticket with any new information? Otherwise you can close it.

[johnnyoffline]

Closing this ticket because we have not been able to reproduce is using MySQL 5