Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Running command on MySQL?


Guest

Recommended Posts

Hi Again,

 

I am thinking about installing a contribution. While I can find the code lines in the various files, I am scratching my head over the directive shown below. Being a newbie, I am just not familiar with the lingo. And I have done very little with SQL other than importing a file into the db.

 

Could someone explain what I am to do here?

 

Thanks, Kathy

 

 

Run the following command on your MySQL database (if you always or almost always charge tax on shipping, you may want to enter a different default value for shipping_tax, ie 16.0000 instead of 0.0000):

 

ALTER TABLE orders ADD shipping_tax DECIMAL( 7, 4 ) DEFAULT '0.000' NOT NULL ;

INSERT into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('', 'Order Editor- Display Payment Method dropdown?', 'DISPLAY_PAYMENT_METHOD_DROPDOWN', 'true', 'Display Payment Method in Order Editor as dropdown menu (true) or as input field (false)', '1', '21', NULL, '2006-04-02 11:51:01', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

Link to comment
Share on other sites

You need to copy the given command into the SQL window in phpmyadmin. If you are not familiar with that program, you can get a good idea of how to use it from this thread.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...