Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database help


halltristan

Recommended Posts

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?

I'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

* 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...

I'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

... 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. :)

Link to comment
Share on other sites

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;

Link to comment
Share on other sites

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'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

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.

I'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

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.

I'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

I'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

fixed?

I'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

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:

I'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...