Problem with Admin

[fatshoesday]

I am trying to access my admin site and I keep getting this

 

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

 

select id from administrators limit 1

 

[TEP STOP]

 

Anybody tell me what it is and how to correct?

 

Thanks

[web-project]

as you have upgraded your existing oscommerce to the latest version, you need to add the administrators table to your mysql database.

[fatshoesday]

as you have upgraded your existing oscommerce to the latest version, you need to add the administrators table to your mysql database.

Thanks, How do I do that?

[web-project]

Thanks, How do I do that?

 

have you got the phpmyadmin utility in webhost control panel?

 

you need to run the following in SQL query.

CREATE TABLE `administrators` (
`id` int(11) NOT NULL auto_increment,
`user_name` varchar(32) character set latin1 collate latin1_bin NOT NULL,
`user_password` varchar(40) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1