Alastair Posted July 9, 2005 Posted July 9, 2005 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
bglkk Posted July 9, 2005 Posted July 9, 2005 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. <{POST_SNAPBACK}> Often your web site control panel (cPanel, plesk...) will provide phpmyadmin for managing databases. Try looking there. "Buy the ticket, take the ride..." -HST
Alastair Posted July 9, 2005 Author Posted July 9, 2005 Who set up your site? <{POST_SNAPBACK}> 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. :(
Jack_mcs Posted July 9, 2005 Posted July 9, 2005 They may not have phpmyadmin installed. You can install it yourself if they don't have it and won't install it. 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
Alastair Posted July 14, 2005 Author Posted July 14, 2005 They may not have phpmyadmin installed. You can install it yourself if they don't have it and won't install it. Jack <{POST_SNAPBACK}> 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.
Jack_mcs Posted July 15, 2005 Posted July 15, 2005 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.