Submitted by gilgam on
bonjour
je viens d'essayer d'installer drupal sur les pages perso de nerim
j'ai téléchargé le dossier
j'ai configuré le settings.php avec notamment un prefix drupal_ j'ai une seule base ...
Puis en passant par phpgadmin j'ai importé le fichier database/database.pgsql sans aucuns problèmes apparement
mais quand je me connecte à mon adresse drupal j'ai une foule d'erreurs php
dont voici un court extrait (désolé c'est un peu long ;-) ) :
siq quelqu'un a une idée pour l'installation propre et claire merci. je n'ai pas accès à un shelle distant d'où l'impossibilité de suivre les instructions du document install pgsql dans le package drupal .
merci de votre réponse
Warning: pg_query(): Query failed: ERROR: relation "drupal_sessions" does not exist in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 84
Warning: ERROR: relation "drupal_sessions" does not exist query: SELECT sid FROM drupal_sessions WHERE sid = 'c1854094f986425692e1892a49d03735' in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 103
Warning: pg_query(): Query failed: ERROR: relation "drupal_users" does not exist in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 84
Warning: ERROR: relation "drupal_users" does not exist query: SELECT u.* FROM drupal_users u WHERE u.uid = 0 in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 103
Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc:84) in /filer/s/a/sabnico1007/drupal/includes/bootstrap.inc on line 750
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc:84) in /filer/s/a/sabnico1007/drupal/includes/bootstrap.inc on line 750
Warning: pg_query(): Query failed: ERROR: relation "drupal_access" does not exist in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 84
Warning: ERROR: relation "drupal_access" does not exist query: SELECT * FROM drupal_access WHERE status = 1 AND type = 'host' AND LOWER('86.208.212.156') LIKE LOWER(mask) in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 103
Warning: pg_query(): Query failed: ERROR: relation "drupal_access" does not exist in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 84
Warning: ERROR: relation "drupal_access" does not exist query: SELECT * FROM drupal_access WHERE status = 0 AND type = 'host' AND LOWER('86.208.212.156') LIKE LOWER(mask) in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 103
Warning: pg_query(): Query failed: ERROR: relation "drupal_cache" does not exist in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 84
Warning: ERROR: relation "drupal_cache" does not exist query: SELECT data, created, headers, expire FROM drupal_cache WHERE cid = 'variables' in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 103
Warning: pg_query(): Query failed: ERROR: relation "drupal_variable" does not exist in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 84
Warning: ERROR: relation "drupal_variable" does not exist query: SELECT * FROM drupal_variable in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 103
Warning: pg_query(): Query failed: ERROR: relation "drupal_cache" does not exist in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 84
Warning: ERROR: relation "drupal_cache" does not exist query: BEGIN; LOCK TABLE drupal_cache IN EXCLUSIVE MODE in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 103
Warning: pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 84
Warning: ERROR: current transaction is aborted, commands ignored until end of transaction block query: UPDATE drupal_cache SET data = 'N;', created = 1153502185, expire = 0, headers = '' WHERE cid = 'variables' in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 103
Warning: pg_affected_rows(): supplied argument is not a valid PostgreSQL result resource in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 200
Warning: pg_query(): Query failed: ERROR: relation "drupal_url_alias" does not exist in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 84
Warning: ERROR: relation "drupal_url_alias" does not exist query: SELECT COUNT(pid) FROM drupal_url_alias in /filer/s/a/sabnico1007/drupal/includes/database.pgsql.inc on line 103
Tu as configuré le préfixe
Permalien Soumis par geeloo@drupal.org le 24 Juillet, 2006 - 16:46
Tu as configuré le préfixe "drupal_" dans le fichier settings.
Or dans la requête (database.pgsql) ce préfixe n'est indiqué nulle part.
Il te faut donc :
- supprimer les tables créées par Drupal,
- modifier ton fichier database.pgsql afin que la requête insère le préfixe aux bons endroits (cf. ci-dessous),
- exécuter à nouveau la requête contenue dans ce fichier.
Par exemple là où tu as :
--
-- Table structure for accesslog
--
CREATE TABLE accesslog (
aid SERIAL,
sid varchar(32) NOT NULL default '',
title varchar(255) default NULL,
path text default NULL,
url text default NULL,
hostname varchar(128) default NULL,
uid integer default '0',
timer integer NOT NULL default '0',
timestamp integer NOT NULL default '0',
PRIMARY KEY (aid)
);
CREATE INDEX accesslog_timestamp_idx ON accesslog (timestamp);
tu dois modifier en
--
-- Table structure for accesslog
--
CREATE TABLE drupal_accesslog (
aid SERIAL,
sid varchar(32) NOT NULL default '',
title varchar(255) default NULL,
path text default NULL,
url text default NULL,
hostname varchar(128) default NULL,
uid integer default '0',
timer integer NOT NULL default '0',
timestamp integer NOT NULL default '0',
PRIMARY KEY (aid)
);
CREATE INDEX accesslog_timestamp_idx ON drupal_accesslog (timestamp);
NB : Cela concerne les opérations CREATE TABLE, CREATE INDEX mais aussi les opérations INSERT INTO qui sont placées à la fin (
INSERT INTO system
devientINSERT INTO drupal_system
).Tu peux utiliser un éditeur de texte pour remplacer automatiquement, ou parcourir le fichier (ce qui est plus sûr mais plus long).