Cannot log into Admin section after installation

[Guest]

I have installed Module Cart which is a derivative of OsCommerce 2.2. It works perfectly on my local server. Then I installed it on the web, and although I use the same database name and settings, it will not allow me to enter admin because of:

1146 - Table 'xxxxx.administrators' doesn't exist

 

Can somebody please help me? I have tried the ModuleCart forum, but have not received any reply.

[FIMBLE]

this is the default osc sql for the administrators table

 

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)

);

[Guest]

this is the default osc sql for the administrators table

 

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)

);

 

===================================

Thank you very much, I did this, and my problem was immediately solved.

Thank you once again. Gerrit

[FIMBLE]

You're welcome