Trying to install a fresh clean Drupal version 6.2 on my webserver ended up with these error messages :
Drupal installation complete ------------------------------ warning: pg_query() [function.pg-query]: Query failed: ERROR: column "uid" does not exist LINE 1: SELECT * FROM users u WHERE uid = 1 ^ in /www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138. user warning: query: SELECT * FROM users u WHERE uid = 1 in /www_root/drupal.famped.dk/modules/user/user.module on line 167. warning: pg_query() [function.pg-query]: Query failed: ERROR: column "uid" does not exist LINE 1: SELECT * FROM users WHERE uid = 1 ^ in /www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138. user warning: query: SELECT * FROM users WHERE uid = 1 in /www_root/drupal.famped.dk/modules/user/user.module on line 527. warning: pg_query() [function.pg-query]: Query failed: ERROR: column "name" of relation "users" does not exist LINE 1: INSERT INTO users (name, mail, pass, init, status, created) ... ^ in /www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138. user warning: query: INSERT INTO users (name, mail, pass, init, status, created) VALUES ('jkp', 'jesper@famped.dk', 'cb32154ec178b88cb055c4b8f50aeaae', 'jesper@famped.dk', 1, 1207916857) in /www_root/drupal.famped.dk/modules/user/user.module on line 325. warning: pg_query() [function.pg-query]: Query failed: ERROR: column "name" does not exist LINE 1: SELECT * FROM users u WHERE LOWER(name) = LOWER('jkp') AND p... ^ in /www_root/drupal.famped.dk/includes/database.pgsql.inc on line 138. user warning: query: SELECT * FROM users u WHERE LOWER(name) = LOWER('jkp') AND pass = 'cb32154ec178b88cb055c4b8f50aeaae' AND status = 1 in /www_root/drupal.famped.dk/modules/user/user.module on line 167. ---------
When checking my PostgreSQL backend I can see the problem. The "users" table do not contain the columns "uid", "name" and "pass" but have the following definition :
Table "public.users" Column | Type | Modifiers -------------+-----------------------+---------------------------------------------------- id | integer | not null default nextval('users_id_seq'::regclass) user_name | character varying(25) | not null user_passwd | character varying(25) | not null Indexes: "users_pkey" PRIMARY KEY, btree (id)
Any ideas of what the problem is?
Thanks Jesper K. Pedersen