Help Please - Mysql

[Guest]

Hi all

 

Have installed a contribution Login and Logoff for osCommerce Administrators.

 

Everything is installed correctly but, I get an error mesage:

 

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

 

select * from administrators

 

[TEP STOP]

 

Obviously this file does not exist in mysql and I was hoping that someone with knowledge would help me create adminstrator file

 

Thanks in advance

 

Liam

[jpweber]

They gave you an SQL file in the contribution (assuming you downloaded the full package). You have to log onto your cpanel, then go into your database section, and find phpmyadmin.

 

Then you have to click the SQL button, and run that query -- copy the contents of the SQL file that came with the contribution into the SQL box, and run the query. This will create the table you need.

[Guest]

They gave you an SQL file in the contribution (assuming you downloaded the full package). You have to log onto your cpanel, then go into your database section, and find phpmyadmin.

 

Then you have to click the SQL button, and run that query -- copy the contents of the SQL file that came with the contribution into the SQL box, and run the query. This will create the table you need.

 

 

Hi

 

Thanks for your reply, I have got this with it but as there are know readable instructions, I am not sure if I have to change any values and exactly what part do I run from mysql

 

1. ???????????Աadmin???ݣ??˹???Աӵ??????Ȩ??

 

 

DROP TABLE IF EXISTS administrators;

CREATE TABLE administrators (

administrator_id int(11) DEFAULT '0' NOT NULL auto_increment,

username varchar(20) NOT NULL,

password varchar(20) NOT NULL,

allowed_pages varchar(255) DEFAULT '*' NOT NULL,

PRIMARY KEY (administrator_id)

);

 

INSERT INTO administrators VALUES ( '1', 'admin', 'admin', '*');

[Guest]

Hi

 

Thanks for your reply, I have got this with it but as there are know readable instructions, I am not sure if I have to change any values and exactly what part do I run from mysql

 

1. ???????????Աadmin???ݣ??˹???Աӵ??????Ȩ??

DROP TABLE IF EXISTS administrators;

CREATE TABLE administrators (

administrator_id int(11) DEFAULT '0' NOT NULL auto_increment,

username varchar(20) NOT NULL,

password varchar(20) NOT NULL,

allowed_pages varchar(255) DEFAULT '*' NOT NULL,

PRIMARY KEY (administrator_id)

);

 

INSERT INTO administrators VALUES ( '1', 'admin', 'admin', '*');

 

 

just to add when I run the above text I do get an error message from Mysql:

 

#1067 - Invalid default value for 'administrator_id'

 

 

Regards

[jpweber]

You should just be able to go into phpmyadmin and run:

 

DROP TABLE IF EXISTS administrators;

CREATE TABLE administrators (

administrator_id int(11) DEFAULT '0' NOT NULL auto_increment,

username varchar(20) NOT NULL,

password varchar(20) NOT NULL,

allowed_pages varchar(255) DEFAULT '*' NOT NULL,

PRIMARY KEY (administrator_id)

);

 

INSERT INTO administrators VALUES ( '1', 'admin', 'admin', '*');

 

 

As far as that error is concerned, I'm not a database expert. I'll have to research into that. In the meantime, hopefully someone more knowledgable about databases and queries will respond. But I will look into it; just give me a few.

[Guest]

Hi Jason

 

Really appreciate your time and patience many thanks for your help so far

 

Regards

 

Liam