Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Running SQL query ?


Alastair

Recommended Posts

Posted

I found a contribution for Minimum Product Quantity with Admin control by Mark Rickert and Dave Latham

http://www.oscommerce.com/community/contributions,2953 which is ideal. The problem is that although I can edit the code as required I dont know how to run an SQL query.

 

The contribution says (step 5)

Run this SQL query on your database:

 

I dont even know where the database is, when I ftp changes to my site www.lannagifts.com I can't see the database. I only have backups that I generate via the admin panel.

 

Any help for a novice would be greatfully recieved.

 

Cheers

Ali

Posted

Who set up your site?

Giovanni Putignano

Posted
I dont even know where the database is, when I ftp changes to my site www.lannagifts.com I can't see the database. I only have backups that I generate via the admin panel.

 

Often your web site control panel (cPanel, plesk...) will provide phpmyadmin for managing databases. Try looking there.

"Buy the ticket, take the ride..." -HST

Posted
Who set up your site?

 

 

I have my site with "thehostserver.com" and they have oscommerce within the package. I have put a request in to them to find out where it is so I can download it. But still dont know how to run a query?

 

I checked the admin panel but nothing there for me to see regarding the database location. :(

Posted
They may not have phpmyadmin installed. You can install it yourself if they don't have it and won't install it.

 

Jack

 

Hi All

 

I have access to phpmyadmin control panel now. :-"

 

I selected my data base and I see tabs SQL and I also see QUERY. Do I use the SQL tag and then run the query from here or do I go to QUERY ?

 

In the contribution one query seems to be to the database as a whole and the second query is to "products description" table.

 

Lost now :'(

 

This is what I am supposed to do.

 

STEP 5:

________________________________________________________________________________

_____________________

 

Run this SQL query on your database:

 

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 ('500', 'Minimum Orders', 'MINIMUM_ORDERS', 'true', 'Whether or not to enforce minimum orders', '1', '19', NOW( ) , NOW( ) , NULL , NULL);

 

________________________________________________________________________________

_____________________

STEP 6:

________________________________________________________________________________

_____________________

 

Run this SQL query to modify your "products description" table:

 

ALTER TABLE `products` ADD `minorder` INT( 4 ) DEFAULT '1' NOT NULL ;

________________________________________________________________________________

_____________________

STEP 7:

________________________________________________________________________________

_____________________

 

Populate the minorder field in your products_description table.

*note* that the table automatically sets all minorder's to one (1).

Or continue to be able to do it via Admin interface.

Posted

Use the SQL tab. The Query tab is for finding something in the database. If the contribution included an SQL file, tehn use the Browse button on the SQL tab to upload that file. If not, just copy and past the changes into the white box on the SQL tab.

 

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

Archived

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

×
×
  • Create New...