I'm just installed drupal by CVS and I received this error when I import database.pqsql in my Postgres Database :

psql:database.pgsql:702: ERREUR: La colonne «changed» n'existe pas

And this when I tri to acces to drupal :

Warning: pg_query() [function.pg-query]: Query failed: ERREUR: syntax error sur ou près de «cache» at character 13 in /var/www/drupal/includes/database.pgsql.inc on line 45

Fatal error: ERREUR: syntax error sur ou près de «cache» at character 13 query: LOCK TABLES cache WRITE in /var/www/drupal/includes/database.pgsql.inc on line 62

Comments

Cvbge’s picture

Using english would help.

kinai’s picture

Error Translation :

fr : psql:database.pgsql:702: ERREUR: La colonne «changed» n'existe pas
us : psql:database.pgsql:702: ERROR: The column "changed" does not exist

fr : Warning: pg_query() [function.pg-query]: Query failed: ERREUR: syntax error sur ou près de «cache» at character 13 in /var/www/drupal/includes/database.pgsql.inc on line 45
us : Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error on or near «cache» at character 13 in /var/www/drupal/includes/database.pgsql.inc on line 45

fr : Fatal error: ERREUR: syntax error sur ou près de «cache» at character 13 query: LOCK TABLES cache WRITE in /var/www/drupal/includes/database.pgsql.inc on line 62

us : Fatal error: ERREUR: syntax error on or near «cache» at character 13 query: LOCK TABLES cache WRITE in /var/www/drupal/includes/database.pgsql.inc on line 62

kinai’s picture

Priority: Normal » Critical
kinai’s picture

CREATE TABLE users (
uid integer NOT NULL default '0',
name varchar(60) NOT NULL default '',
pass varchar(32) NOT NULL default '',
mail varchar(64) default '',
mode smallint NOT NULL default '0',
sort smallint default '0',
threshold smallint default '0',
theme varchar(255) NOT NULL default '',
signature varchar(255) NOT NULL default '',
created integer NOT NULL default '0',
access integer NOT NULL default '0',
login integer NOT NULL default '0',
status smallint NOT NULL default '0',
timezone varchar(8) default NULL,
language varchar(12) NOT NULL default '',
picture varchar(255) NOT NULL DEFAULT '',
init varchar(64) default '',
data text default '',
PRIMARY KEY (uid),
UNIQUE (name)
);
CREATE INDEX users_changed_idx ON users(changed);

=> NO COLUMN "CHANGED" IN USERS TABLE ???

Cvbge’s picture