1054 - Unknown column 'id' in 'field list'

[agarban]

Hi, im having problems traying to instale my oscommerce.

 

I cant get int in my admin beacuse i get this message:

 

1054 - Unknown column 'id' in 'field list'

 

i have created my administrator database table (i dont know if i did it rigth) using phpMyAdmin.

 

but i get that error. i dont how to resolve. if someone have an idea i really apriciate.

 

excuse my bad english

[♥geoffreywalton]

Try this sql

 

DROP TABLE IF EXISTS administrators;

CREATE TABLE administrators (

id int NOT NULL auto_increment,

user_name varchar(32) binary NOT NULL,

user_password varchar(40) NOT NULL,

PRIMARY KEY (id)

);

 

But I suspect the error is more serious than this. If the installation didn't create this table what elese didn't it do?

 

The complete sql is in your install directory.