Database help

[halltristan]

I'm trying to install a contribution into the osCommerce engine, but I cannot find the database to add the needed script to. Is there a default location that the database is created?

[tigergirl]

I'm trying to install a contribution into the osCommerce engine, but I cannot find the database to add the needed script to. Is there a default location that the database is created?

 

which contribution?

[halltristan]

which contribution?

 

 

 

 

* OSCommerce Patch

*

* Name: Price Break

*

* Author: Andrew Baucom ([email protected])

[tigergirl]

* OSCommerce Patch

*

* Name: Price Break

*

* Author: Andrew Baucom ([email protected])

 

There are many listed. I saw if it helps. http://www.oscommerce.com/forums/index.php?showtopic=220794

I'm not really sure what your trying to do from your explanation. whats the URL to the coontribution and I'll look...

[Guest]

... but I cannot find the database to add the needed script to. Is there a default location that the database is created?

This should be defined in your configuration file, details of which would have been requested at install time.

 

Basically, you access your database via phpAdmin or similar tool, provided by your host. :)

[halltristan]

This should be defined in your configuration file, details of which would have been requested at install time.

 

Basically, you access your database via phpAdmin or similar tool, provided by your host. :)

 

 

Below if the script I am trying to install into the database. Where should it go and using phpmyadmin, how do I do it? I'm an idiot with all of this.

 

alter table products add column products_price1 decimal(15,4) not null default 0.0;

alter table products add column products_price2 decimal(15,4) not null default 0.0;

alter table products add column products_price3 decimal(15,4) not null default 0.0;

alter table products add column products_price4 decimal(15,4) not null default 0.0;

alter table products add column products_price5 decimal(15,4) not null default 0.0;

alter table products add column products_price6 decimal(15,4) not null default 0.0;

alter table products add column products_price7 decimal(15,4) not null default 0.0;

alter table products add column products_price8 decimal(15,4) not null default 0.0;

alter table products add column products_price1_qty int not null default 0;

alter table products add column products_price2_qty int not null default 0;

alter table products add column products_price3_qty int not null default 0;

alter table products add column products_price4_qty int not null default 0;

alter table products add column products_price5_qty int not null default 0;

alter table products add column products_price6_qty int not null default 0;

alter table products add column products_price7_qty int not null default 0;

alter table products add column products_price8_qty int not null default 0;

alter table products add column products_qty_blocks int not null default 1;

[tigergirl]

I'm assuming you have access to phpmyadmin?

1) BACKUP YOUR DATABASE

2) BACKUP

3) backup

 

If you have phpmyadmin, at the top left there is an icon with SQL on it. Click it, which sould open a box where you can paste in all that code, then click run.

[tigergirl]

I'm assuming you have access to phpmyadmin?

1) BACKUP YOUR DATABASE

2) BACKUP

3) backup

 

If you have phpmyadmin, at the top left there is an icon with SQL on it. Click it, which sould open a box where you can paste in all that code, then click run.

 

I have access to phpmyadmin via my hosting account.

[halltristan]

I have access to phpmyadmin via my hosting account.

 

Yeah I have phpmyadmin. Thanks for the help.

[tigergirl]

Yeah I have phpmyadmin. Thanks for the help.

 

OK, did what I said work then?

I had a real nightmare trying to run a script on my first attempt, I had no clue what "run this sql file" meant,

Glad to be of help. Nice when someone replies eh? I can log-off and get some kip now.

[halltristan]

I have access to phpmyadmin via my hosting account.

 

Which group do I need to choose to add the script in.

I have:

 

configuration_group_id

configuration_group_title

configuration_group_description

sort_order <----------which is where I'm thinking but I want to make sure

[tigergirl]

Below if the script I am trying to install into the database. Where should it go and using phpmyadmin, how do I do it? I'm an idiot with all of this.

 

alter table products add column products_price1 decimal(15,4) not null default 0.0;

alter table products add column products_price2 decimal(15,4) not null default 0.0;

alter table products add column products_price3 decimal(15,4) not null default 0.0;

alter table products add column products_price4 decimal(15,4) not null default 0.0;

alter table products add column products_price5 decimal(15,4) not null default 0.0;

alter table products add column products_price6 decimal(15,4) not null default 0.0;

alter table products add column products_price7 decimal(15,4) not null default 0.0;

alter table products add column products_price8 decimal(15,4) not null default 0.0;

alter table products add column products_price1_qty int not null default 0;

alter table products add column products_price2_qty int not null default 0;

alter table products add column products_price3_qty int not null default 0;

alter table products add column products_price4_qty int not null default 0;

alter table products add column products_price5_qty int not null default 0;

alter table products add column products_price6_qty int not null default 0;

alter table products add column products_price7_qty int not null default 0;

alter table products add column products_price8_qty int not null default 0;

alter table products add column products_qty_blocks int not null default 1;

 

oops, forgot to say to click on your database name first, doh(top left in phpmyadmin). then run the query like I said. this will alter the tables for you.

[tigergirl]

fixed?

[halltristan]

fixed?

 

I think I have it... if I have any problems I'll pm you. Thanks for all of the help

[tigergirl]

I think I have it... if I have any problems I'll pm you. Thanks for all of the help

 

Good, good. Best to continue on this thread if you have more problems though.

Take it easy.

:thumbsup: