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
On Fri, 11 Apr 2008 14:41:11 +0200 (CEST) "Jesper K. Pedersen" linux@famped.dk wrote:
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
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)
this looks as the wrong table/database.
Columns for users table should be uid, name, mail, created... up to my memory.
It looks as if you connected to another DB/schema.
On Fri, 11 Apr 2008 14:41:11 +0200 (CEST) "Jesper K. Pedersen" linux@famped.dk wrote:
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
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)
this looks as the wrong table/database.
Columns for users table should be uid, name, mail, created... up to my memory.
It looks as if you connected to another DB/schema.
You were (partly) right. I just checked my postgresql and at some point in time I must have accidentally created that table in my template1 database instead of my users database. This in turn hindered drupal in creating its own users table.
I just fixed that and now drupal install and runs as it ought to (sorry about that problem).
Best regards JesperKP