Closed (duplicate)
Project:
Drupal core
Version:
x.y.z
Component:
postgresql database
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
13 May 2005 at 14:59 UTC
Updated:
25 May 2005 at 20:49 UTC
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
Comment #1
Cvbge commentedUsing english would help.
Comment #2
kinai commentedError 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
Comment #3
kinai commentedComment #4
kinai commentedCREATE 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 ???
Comment #5
Cvbge commentedDuplicate of http://drupal.org/node/22909