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

[lizards]

Hi,

 

Does any one have an idea what seems to be wrong in my instalation. Shop is working fine but when trying to access admin side, I´ll get this error message:

 

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

 

select id from administrators limit 1

 

[TEP STOP]

 

BR,

Juha

[Guest]

I am having the same exact problem.

 

http://98.130.113.49/catalog/admin/login.php

"

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

 

select id from administrators limit 1

 

[TEP STOP]

"

 

I imported directly to the db of store B using the sql backup from store A. The front end has the items and categories but the ..catalog/admin/ comes up with the error above.

[lizards]

Hi,

 

i found the solution from here:

 

This is due to the new administrators table not existing in the backup you are restoring. This table can be created with the following SQL statement:

 

 

SQL

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)

);

 

 

 

The Administration Tool will then detect that the administrators table is empty and will ask you to create a new administrator account on the login pag

 

BR,

Juha

[crcorey]

Thanks. That worked