Missing Administrators Table.

[CollinR]

It's missing from my oscommerce.sql

 

Dows anyone have a table structure for it? I can't seem to find the SQL structures alone.

[♥geoffreywalton]

There is no such table in the standard osCommerce.

 

Is it from a contribution?

 

Whoops should have said my version.

 

Nice one Bob.

[bobg7]

I'm guessing you did something like uploaded the new RC1 files but didn't update the database so you wouldn't loose any info.

 

Here is the statement from the oscommerce.sql file located in ms3/install:

 

DROP TABLE IF EXISTS osc_administrators;
CREATE TABLE osc_administrators (
 id int NOT NULL auto_increment,
 user_name varchar(32) NOT NULL,
 user_password varchar(40) NOT NULL,
 user_full_name varchar(255) NOT NULL,
 user_email_address varchar(255) NOT NULL,
 PRIMARY KEY (id)
);

 

You should be able to just copy/paste the code and I think the first time you enter the admin panel it will prompt you for a username/password.

 

Hope this helps.......

[CollinR]

Although it's possible I have downloaded an upgrade package this is a fresh install and it was only missing that table (that I can tell).

 

Either way much thanks guys! I am off and on my way. This is my first go at oscommerce and e-commerce in general, so we'll see how it goes. I have been playing with Apache/PHP/MySQL for about 10 years on hobby sites just never really tried to open a storefront.

 

Sucks too as I use Godaddy for hosting and they prohibit remote access to your MySQL DB, so updating my products will have to be interesting. :(

 

 

Thanks again!

Collin