Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

myPHPadmin, query?


Recommended Posts

I'm a newb at databases and PHP so excuse my newbiness! lol

 

I'm going to upgrade an OS site from version 2.2 rc1 to rc2a. I opened up the upgrade.html file and it says to make these changes to the SQL:

 

alter table banners add index idx_banners_group (banners_group);

alter table banners_history add index idx_banners_history_banners_id (banners_id);

alter table currencies add index idx_currencies_code (code);

alter table customers add index idx_customers_email_address (customers_email_address);

alter table customers_basket add index idx_customers_basket_customers_id (customers_id);

alter table customers_basket_attributes add index idx_customers_basket_att_customers_id (customers_id);

alter table orders add index idx_orders_customers_id (customers_id);

alter table orders_products add index idx_orders_products_orders_id (orders_id);

alter table orders_products add index idx_orders_products_products_id (products_id);

alter table orders_status_history add index idx_orders_status_history_orders_id (orders_id);

alter table orders_products_attributes add index idx_orders_products_att_orders_id (orders_id);

alter table orders_products_download add index idx_orders_products_download_orders_id (orders_id);

alter table products add index idx_products_model (products_model);

alter table products_attributes add index idx_products_attributes_products_id (products_id);

alter table reviews add index idx_reviews_products_id (products_id);

alter table reviews add index idx_reviews_customers_id (customers_id);

alter table specials add index idx_specials_products_id (products_id);

alter table zones add index idx_zones_to_geo_zones_country_id (zone_country_id);

alter table orders_status add public_flag int DEFAULT '1';

alter table orders_status add downloads_flag int DEFAULT '0';

alter table orders modify payment_method varchar(255) NOT NULL;

alter table whos_online modify last_page_url text NOT NULL;

 

Ok so I've never played with myPHPadmin. Are each one of these lines "alter table banners add index idx_banners_group (banners_group); " a query string??

 

If so do I select the "banners" table and click on the SQL tab? From there do I add the SQL query "alter table banners add index idx_banners_group (banners_group); " and select go??

I'm stumped on how to make the changes to the SQL. I did backup the SQL database just in case.

 

Many thanks in advanced

Link to comment
Share on other sites

Back up yes.

Make a text file of the update code, call it what you like

in phpmyadmin you will see an insert tab at the top, click it then click browse, then navigate to the folder with the code in.

Click ok

at the bottom of the PHPMYADMIN page click go.

That will do it all for you

Regards

Nic

Sometimes you're the dog and sometimes the lamp post

[/url]

My Contributions

Link to comment
Share on other sites

Back up yes.

Make a text file of the update code, call it what you like

in phpmyadmin you will see an insert tab at the top, click it then click browse, then navigate to the folder with the code in.

Click ok

at the bottom of the PHPMYADMIN page click go.

That will do it all for you

Regards

Nic

 

I clicked on the insert tab and i don't see a browse button, i only see the browse button in the upper right.

You didn't happen to mean the import tab??

Link to comment
Share on other sites

1) Go to your ISPs admin area for your site.

 

2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk.

 

3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.

 

4) Click on "SQL" on the navigation bar.

 

5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts.

 

6) For both methods click "Go"..

 

7) If all goes well, your SQL query will run successfully

 

For another explanation see:-

 

http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code

 

Or for a contribution to allow you to run SQL Script from Admin

 

http://www.oscommerce.com/community/contributions,4567

 

Cheers!

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...