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
Comment #1
MikeLee_Birdy commentedDear 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
Comment #2
MikeLee_Birdy commentedComment #3
ipsec commentedWith #1 the install works fine.
I'm using the dev version.
Comment #5
berenddeboer commentedFix committed.