PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR: type modifier is not allowed for type "text" at character 310: CREATE TABLE {bible_context} ( vsid serial CHECK (vsid >= 0), bid bigint CHECK (bid >= 0) NOT NULL default 0, book varchar(3) NOT NULL default '', chapter bigint CHECK (chapter >= 0) NOT NULL default 0, verse bigint CHECK (verse >= 0) NOT NULL default 0, linemark varchar(1) NOT NULL default '', context text(500) NOT NULL, PRIMARY KEY (vsid) ); Array ( ) in db_create_table() (line 2686 of /home/lbc/drupal-7.8/includes/database/database.inc).

Comments

MikeLee_Birdy’s picture

Dear Sir:
Please help me do some experiment:
1. Open bible.install
2. Find line#99 : 'type' => 'text', 'length' => 500, 'not null' => TRUE,
3. Remove 'length' => 500,
4. And install again.

Please tell me if this work or not. Thanks.

MikeLee

MikeLee_Birdy’s picture

Status: Active » Needs review
ipsec’s picture

With #1 the install works fine.
I'm using the dev version.

  • berenddeboer committed 48db596 on 7.x-1.x
    Issue #1288784 by mikelee_birdy: PDOException on Module Install...
berenddeboer’s picture

Issue summary: View changes
Status: Needs review » Fixed

Fix committed.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.