PDOException : SQLSTATE[HY000]: General error: 1 table "biblio_contributor_data" has more than one primary key: CREATE TABLE {biblio_contributor_data} ( cid INTEGER PRIMARY KEY AUTOINCREMENT CHECK (cid>= 0), aka INTEGER NOT NULL CHECK (aka>= 0) DEFAULT 0, drupal_uid INTEGER NULL CHECK (drupal_uid>= 0) DEFAULT NULL, name VARCHAR(255) NOT NULL DEFAULT '', lastname VARCHAR(128) NOT NULL DEFAULT '', firstname VARCHAR(128) NULL DEFAULT '', prefix VARCHAR(128) NULL DEFAULT '', suffix VARCHAR(128) NULL DEFAULT '', initials VARCHAR(10) NULL DEFAULT '', affiliation VARCHAR(255) NULL DEFAULT '', literal INTEGER NOT NULL CHECK (literal>= 0) DEFAULT 0, md5 VARCHAR(32) NULL DEFAULT NULL, PRIMARY KEY (aka) ); ; Array ( ) dans db_create_table() (ligne 2657 dans /home/user/newsites.org/includes/database/database.inc).
Comments
Comment #1
rjerome commentedWhich database engine are you using? (MySQL, PostgreSQL,...)
Comment #2
csp commentedI'm using SQLite on this site.
Comment #3
rjerome commentedBiblio has NOT been tested at all with SQLite. And I would suspect (given how recently SQLite has entered the mix) that the rest of the Drupal ecosphere has only been lightly tested (if at all).
Ron
Comment #4
ar-jan commented#1206612: Unable to create biblio tables when using sqlite has an explanaton of the problem and a workaround/fix.